… bunch of micro optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue” is finally solved in 5.1 which… enhancement requests. It takes time for the patches to mature. We improved the scalability of InnoDB-5.0.30 in December 2006… slave. Can you make the reorganization run in a tolerable time? PZ: Indeed using master-master setup and switching roles is…
Comment: Slow Query Log analyzes tools
August 22, 2007 By 84 Comments
…/patch.slow-micro.5.0.41.diff to the appropriate sources http://downloads.mysql.com/archives.php?p=mysql-5.0&v=5.0.41 and got Error C2143: syntax error : missing ‘)’ before ‘;’ @ c:\mysql-5.0.41-slowmicro\sql-common\my_time.c line 1244 The fix is – suprisingly 
– to add a ‘)’ before ‘;’ at line 1244 @ my_time…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…’s server. The server is running a Percona build of 5.0.84, so I have microsecond logging in the slow….196] # Thread_id: 3329398998 Schema: app_db # Query_time: 0.306486 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows… do just that. Catching a server having micro-freezes, and capturing diagnostic data just-in-time, is a poor man’s way…
Comment: Slow Query Log analyzes tools
July 2, 2007 By 84 Comments
Another issue: In the patch at: http://www.mysqlperformanceblog.com/files/patches/patch.slow-micro.5.0.41.diff line 2192 should read: if ((ulong) (thd->start_timer – thd->timer_after_lock) > not: if ((ulong) (thd->start_time – thd->time_after_lock) >
