After Gavin Towey’s recent blog post about Percona Server’s buffer pool dump locking the server for the duration of the operation, I thought I should re-examine MySQL 5.6′s implementation of a similar feature. When InnoDB engineers first announced the feature, I didn’t think it was complete enough to serve a DBA’s needs fully.
I have a chance to test Micron RealSSD™ P320h. Initially I was expecting a good performance, but you know, how big could be a difference with other products on market? PCIe SSD market is getting crowded, and every company is trying to show the best performance. And at the end, there is a single PCIe slot, single controller, we are probably about to reach limits of these components.
However I was really surprised to see performance numbers with Micron P320h.
Another new year by Jewish calendar. What do I wish for the following year?
One of the MySQL servers I help manage was encountering some problems with a full data directory. It was a bit mysterious, because we couldn’t find any files to account for the increased usage. Here are some things we checked:
We are glad to announce the availability of Percona Playback 0.4, the first release where we’ve released binary packages alongside our source release.
Binary packages for RHEL/CentOS 6 are available with Debian/Ubuntu packages soon to come (we are ensuring our dependencies are correct before publishing). Packages and source may be downloaded from here and are available in our EXPERIMENTAL repositories.
On Percona Live New York I’ll be giving two talks
Next Wednesday, September 19 at 10:00 AM PDT I will present a webinar on Percona XtraDB Cluster. The webinar focuses on the basics of XtraDB Cluster, we will install it, break it, fix it, and use HaProxy with it.