This morning Stewart announced the release of Percona Playback 0.4 (with packages).
Unfortunately, the bug I was referring in my previous post was not fixed in that release. Therefore I created again a package based on 0.4 including the patch that allows to parse slow query log with statements written on multiple lines.
Recently (yesterday), I faced a problem with percona-playback when I tried to use a slow query log (captured on a customer's server) and it fails dramatically. The log files was 2.3G and the second query was already returning an error :-(
I seemed that I hit a bug that Aurimas, my colleague at Percona, already reported (bug 1035217): queries written on multi lines don't work !
My C++ knowledge is very old and also very limited, so I tried to understand and fix this issue myself. Mushu (dbasquare) already faced this problem and started to fix it before giving up as he needed to run it on Slowaris... Gently he sent me his patch that I modified to support my slow query log:
- queries on multi-lines
- queries being only a ; (semi-colon)
- queries finishing by another character than ; (with comments for example)
Attached to this post, you can find the rpm for CentOS 6 including that patch.
Baron announced today the release of Innotop 1.9.0..
Fedora provides Innotop 1.6.0 !
I have then build rpm for CentOS 6 to test it as soon as possible !
[update]: I made a typo (see comment bellow) in the requirement of perl-TermReadKey, I've fixed this in innotop-1.9.0-2.
As I wanted to test in my vagrant environment Yoshinori's MySQL replication booster, I needed to create rpms to be able to install it quickly and easily on those virtual machine without compiling it on the vm's.
So if you are interested in this nice replication solution and you are lazy to compile it, you can use my rpm's listed bellow.
Some links about the project:
mysql replication listener's rpm was built using modified specs from https://bitbucket.org/winebarrel/ruby-binlog/downloads
I added the src.rpm as requested by nvidhive on #percona freenode.
If you have recently read Stewart's blog post on mysqlperformanceblog, related to Percona Playback and you wanted to test it but you were too lame^H^H^H^Hbusy to compile it (or it was just not an option), I've made an CentOS 6 rpm just for you ;-)
I hope this helps !
PS: those packages have not been tested yet but you can replace mysql-libs by Percona-Server-shared-compat
During my work I sometimes need to perform some benchmarks. I usually use sysbench. The version provided in EPEL for CentOS is old and I wanted to benefit from all the new features of the latest version from launchpad maintained by my colleague Alexey. But as I don't want to install bzr and devel packages and then recompile each time, I decided to make an rpm. I think some people could find it useful so I share it. Enjoy !
[update] I made a new package that also includes the lua files for db tests.
[update] New package from last bzr trunk where bug related to --tx-rate has been fixed (requested by my colleague Jay for his Percona Live New York tutorial about XtraDB Cluster
I hope to see you there if you want to discuss about Percona Toolkit or any other cool stuff Percona is working on related to HA like PRM and XtraDB Cluster.
I already uploaded the pictures of Fosdem and especially the MySQL & Friends devroom:
Thank you to all visitors and speakers !
I hope you enjoyed it an see you next year !
I will start on Friday with the traditional Beer Event.
On Saturday, I will visit some stands and attend to some talks... and in the evening, I will take part of the MySQL & Friends Meetup.
See you there and enjoy Fosdem 2012 !
Like every year now, MySQL & Friends will meet in Fosdem the night before the MySQL & Friends devroom. If you want to share that moment with us, please register here : eventbrite
Thank you, and see you there !