…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5…slow query | 0.000002 | | cleaning up | 0.000002 | +———————-+————+ 17 rows in set (0.00 sec) And you can see how the query…
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 30 Comments
…in a PHP driven website). If there is a bottleneck, a vicious cycle occurs: 1. apache requests increase 2. mysql queries increase 3. mysql slow queries…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…MySQL log you may find some queries which are slow…in this case we could spend a lot of time optimizing PHP code but because it takes only 10% of response time in…down to 5 minutes or even 1 …2419 | 45.388828675971 | 0.9226436892381 | | 09 | 4810 | 6.330725168364 | 0.60329631087965 | | 10 | 5445 | …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…slow it down. Plus there were bunch of micro optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue” is finally solved in 5.1…in it was only recently found and fixed: http://bugs.mysql.com/bug.php…MySQL bugs opened about multi-core scalability (concurrent queries…
Comment: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…in account. Server can’t really profile if page has queries…MySQL to something else is probably less than rewriting them from PHP…MySQL protocol supporting persistent connections would automatically allow to take advantage of it 
6/7) I do not agree. In…slow…
