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:
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
Update
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
Tomorrow I'll be at Loadays to discuss about Percona Toolkit
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 !
Once again, I will spend my week-end in Brussels for the FOSDEM.
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.
If you search me on Sunday, I wil be locked in the MySQL & Friends' Devroom. I will finish my fosdem by a presentation related to Percona Toolkit.
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 !
It's now time to collaborate on this main event !
This even is for the MySQL Community by the MySQL Community and therefor we want your small contribution to prepare the schedule.
The deadline for talk submission was last Yesterday. Now it's time to vote for the talks you want to see in the schedule.
Everything is explained on this page (thank you @datacharmer) : FOSDEM 2012 MySQL & Friends proposals
So, open your mail client or your twitter client and vote now() !
The MySQL and Friends devroom is Room H.1309 (150 seats). We will be there on Sunday 5th February 2012, all day.
Thank you and see you soon in Brussels to talk MySQL and/or have a nice Belgian Beer ;-)
Since a while, everyday at 8pm, my N900 was complaining because it wasn't able to sync one of my calendar (my corporate google calendar). I never really paid attention... but yesterday I decided to fix this.
The calendar sync is done using erminig-ng.
My first action was to save the backtrace and have a look at it... I could understand that a integer was provided where the code was expecting a string.
So before fixing this, I decided to get the last source code... mmm... and then the github reposirory of thomasvs made my day ! Indeed this guy already fixed the problem and explains that on his blog. He also provides a package to update erminig-ng on the phone :-)
Thank you Thomas to not letting me reinventing the wheel !
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.