Even though multiple fixes have been implemented in Percona Server and MySQL 5.5, … see the CPU usage being low with a lot of CPU being idle, increased compared to normal workload portion of system CPU and high number of… wanted to highlight how much context switches you can get from the system, as unlike CPU usage it is not obvious what to consider a high…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… can see the CPU usage and the replication lag… once again cacti is very helpful ! How to fix then ? There are several possibilities to fix this problem… the mmm mode and put it to passive to disable any automatic failover during the process because high availability tools like mmm can…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…The downside in gzip is increased usage of CPU time. PZ: We will see how it plays when we can …has Patches which let you to try it out. Q14: Are there any plans to fix Innodb so it unlocks (…INNODB uses fuzzy checkpointing to commit data to disk. The problem that we’ve seen in high IO scenearios is …
Post: Percona Server with XtraDB Case Study, Behind the Scenes
October 21, 2010 By 13 Comments
…with the noise. Knowing when and how to get and interpret good diagnostic data… causing both mutex contention and excessive CPU usage, for different reasons, and I …. Nothing more could be done without fixing these problems inside MySQL and … server’s performance is not as high as many I’ve worked on…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…how many disks they have instead of how…to insert new data and fetch few rows to show search results which does not require too much IO capacity or high… can become CPU bound even … temporary space usage to stop the …to swap actively – if it does your’re in trouble anyway so it is better to fix…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… buffer pool usage (currently you may need to both store…to specify compressed block size, this is the size to which you expect each page to compress. If you choose this number too high… CPU just keeps doubling. It is also rather interesting how…1+ it is also possible to fix this problem for cases…
