Bonjour

j'ai un problèle au niveau de la réplication MySQL, une requete delete bien optimisée augmente trop le lag mysql.
je pense que la requete attend un commit d'un autre worker.
processlist me donne le resultat suivant :

| 5 | system user | | NULL | Connect | 49410 | Waiting for master to send event | NULL |
| 6 | system user | | NULL | Connect | 19677 | Waiting for dependent transaction to commit | NULL
| 7 | system user | | NULL | Connect | 39262 | Executing event | delete from ..........
| 8 | system user | | NULL | Connect | 39222 | Waiting for an event from Coordinator | NULL |
| 9 | system user | | NULL | Connect | 39288 | Waiting for an event from Coordinator | NULL |
| 10 | system user | | NULL | Connect | 39891 | Waiting for an event from Coordinator | NULL

je signale que je dispose de la version mysql 5.7.17 sous centos,

log_slave_updates = ON
slave_parallel_workers = 8
slave_preserve_commit_order = ON
slave_parallel_type = LOGICAL_CLOCK

Merci pour votre aide.