There are a lot of scalability challenges we see with clients over and over. The list could easily include 20, 50 or even 100 items, but we shortened it down to the biggest five issues we see. 1. Tune those queries
Faudra que je jete un oeil à innodb_flush_log_at_trx_commit, je le connaissais pas celui la. by Aug 2
November 3, 2007 By Peter Zaitsev 39 Comments My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot of clients which came through extreme sufferings leaving it at default value (8M). So if you have dedicated MySQL Box and you’re only using Innodb tables you will want to give all memory you do not need for other needs for Innodb Buffer Pool. This of course assumes your database is large so you need large buffer pool, if not – setting buffer pool a bit larger than your database size will be enough.
innodb_flush_method n'est pas spécifié dans notre conf. Je ferai bien un restart de DB2 en spécifiant sa valeur à O_DIRECT (pas possible de le setter dynamiquement). by Oct 30