MySQL - Simple update is very slow and causing high load average with large amount of server
Get rid of indexes on flags (etat_promo).  The Optimizer almost never uses such; it will prefer to do a table scan.  If you have some query that you think might be using that index, run the EXPLAIN and show us the query for further discussion.