…, is now available. You can watch the recording and get the slides here. I got a lot of questions, … table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I … sounds like you’re using an old version of the tool. Q: Old version of PT OSC said risk in …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… just as the partition switches. So performance gets worse and worse as a partition gets bigger and bigger, then we start a… URL for iibench is slightly incorrect. The correct URL for version you used is http://tokutek.com/downloads/iiBench-1.0… advantages of the newer version of iiBench (the python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… SSD performance is getting closer to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that… that has biggest installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev… read-only workload to have such variety in throughput. It gets even more interesting when we go to read sync IO…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… the essential suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a… interruption. With this new version of the tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If… can read the documentation, discuss it on the mailing list, get the source code from Launchpad, and file bug reports on…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… regular community MySQL 5.5.23 or does it only work (or work better) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… what is happening here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) with the…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… Ubuntu has decided to just keep rolling out the latest version of MySQL for the moment and look to the possibility of… public) instead for the longer run. Upgrading to the latest version of MySQL is fine from a general perspective, but Oracle (and… that get changed that might have unforeseen consequences (one of the reasons why distributions like to pin release versions.) Given MariaDB is MySQL…
Comment: How Percona does a MySQL Performance Audit
March 12, 2012 By 17 Comments
Thanks Baron, I was wondering is this book specific for any version of mysql? or it is an overall performance tuning of mysql. I prefer to get the community version 5.x if you could get me the right one, pls direct me?
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
…, by ‘Even with FLUSH TABLES WITH READ LOCK you are getting in some cases a snapshot that is not recoverable’ I… Oracle MySQL 5.5.x (x=16 on many boxes atm), but we have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ LOCK to get reliable snapshots…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
…This is different issue. In many versions Innodb would print wrong position for current binary log … http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed … doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of relying on that …
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 22, 2012 By 10 Comments
… can do about that. In MySQL 5.6 you can use InnoDB Persistent Statistics to get stable statistics and plan stability. (See…-day.html). You can also reduce the instability in earlier versions by increasing the amount of sampling used to compute the…
