… were facing the performance issue. Still MYSQL load was very high but site was not going down. Then we did some… it is slow again. MySQL load is not going very high. We have also noticed that many process stay in sleeping… Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard Core RAM = 12 GB HDD = 1 TB IP Addresses…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… fast. But it’s still significantly slower (and more CPU-intensive under high load) than PCIe flash For example, see http://www…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the event…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the event…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
… mutex. Another function which we’ve seen being responsible for high CPU usage is ha_print_info which also may traverse large… which points to some locks/latches being responsible for this high amount of threads. It turns out this issue is side… on locked innodb buffer pool mutex, so SHOW STATUS shows high number of running threads. This theory can be confirmed by…
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads – it is able to execute a lot of… active replication, if you’re running time sensitive long running CPU bound queries or if queries contribute significant time to generating… MySQL Latency you may see on T2000 may be as high as 500ms which would be well above performance guidelines for…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… even more frequently. IO Bound workload is quite different from CPU bound one, which happens when your working set (normally only… kind of application are you designing ? Can you make it CPU bound/In memory ? If yes the whole class of the… large tables (so chances they would require physical IO are high) I would highlight this query as possibly having performance problems…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
I again work with the system which needs high insertion rate for data which generally fits in memory. Last … is nice to see you can get the numbers as high with Innodb too. I will spare you all experiments we… MySQL 5.1 and Innodb Plugin we could see 40%+ CPU wasted on mutex spinlocks (per oprofile), which went down to…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… an interesting tuning case few days ago. The system serving high traffic using Innodb tables would be stalling every so often… at the same time there was no significant iowait, neither high CPU usage. Closer examination showed there were hundreds of queries stuck… internal contention. In reality though this option best setting is highly application dependent and you should not blindly use somebody elses…
Comment: Bug fix of InnoDB scalability problem
February 12, 2007 By 13 Comments
…NIN-15] CLONE -Slow front page load times and high CPU usage… Potential temporary solution in moving to MySQL 5.0…. has several performance enhancing benefits for innodb with dual core cpu‘s. My hope is that the improved performance with this…
