…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… only want to patch security issues whereas MySQL also fixes non-security bugs like server crash, wrong result or just performance regressions. From my point of view the distros insisting on sticking to the original version they released and cherry pick patches…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1 It also should be possible to start… Scalability patches Mark Callaghan from Google released so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table… bit ugly solution. That is where this patch can be very useful. With simple MySQL SHOW command it gives you the basic… statements which all currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table scans, disk…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… be a performance killer for a busy application. Recently I have started the development of an updated version of the patch. The… STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch allows you… it in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… the whole MySQL testsuite is not very practical due to 100x slowdown imposed by Helgrind). For this purpose, I have patched mysql-test-run.pl to accept a new option: –helgrind. The patch is a copy-paste-modify… serialized in memory after the reset. A speculative processor might perform the read first, which could leave a waiting thread hanging…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… than one is considered experimental at the moment. Unfortunately this patch hasn’t been ported to Percona Server 5.5 yet… tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve made a tiny change along these lines (the patch can… I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am looking…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL… features and patches for MySQL We can help with developing custom features and extensions for MySQL, help…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… on MySQL Performance the scope of our work proved to be much larger. We handle a lot of architecture design for MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL patches…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL 5.0 which went to… when you see old MySQL versions are used is typically when application is not overly demanding so performance improvements in recent releases…
