… would cause blocking that would defeat the purpose of the tool. Q: When you say bail out, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What… run. will that cleanup ? Q: dose the tool exit gracefully while interupted? The tool doesn’t clean up the temporary table or…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1… insert challenge” for which this tool was originally built is long over, but still the tool serves well for benchmark purposes. OK…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Comment: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
That limitation is lifted, yes. It does need some kind of a unique key. The 2.1 version is a complete rewrite of the tool, though, and your experiences with 2.0 probably won’t indicate how 2.1 will work for you.
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… results, they’re available here: https://github.com/tsuna/sysbench-tools I understand you need the fixes in your kernel, and…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… this one or provide a link to sample configuration. Your tool do not provide config for xtradb cluster. thanks.. karim…..
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… and Statement-Based replication. This was possible before by using tools like grep, awk and sed but only for SBR, because…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release we introduce a new version… table with no interruption. With this new version of the tool, one of the most painful things anyone experiences with MySQL…. The new 2.1 version of the tool removes those limitations and makes the tool fully featured and much easier to use…
Comment: Solving INFORMATION_SCHEMA slowness
April 20, 2012 By 16 Comments
… began the tests to integrate the pt-online-schema-change tool into our own migration procedures. It was taking the… I may, I would suggest adding an option to the tool (and this might apply to the rest of the percona tools that use the MySQL INFORMATION_SCHEMA ) allowing it to momentarily …
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH … “field list” operation to be blocked too, which among other tools used by mysql client, so you might get a feel… consider using –no-lock option with Percona Xtrabackup. Many other tools have similar option. This option can be especially helpful when…
