I’ve also had to benchmark ext4 vs XFS, on a RAID10 of spinning drives. Many DBAs like …, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… move them). The end result was: I could only use mysqldump to import all the data into a clean/fresh innodb…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… row in set (0.00 sec) SESSION2: root@ubuntu:~/dump# mysqldump –single-transaction dumptest > dump.sql SESSION1: (before dump has completed… at the same time as mysqldump was running we got table empty table with new structure in mysqldump instead of table with…. What are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not have this problem…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result…
Comment: Finding out largest tables on MySQL Server
April 24, 2012 By 24 Comments
… 58G 2012-04-24 13:41 tablename.ibd On disk vs the information_schema query, there is around 9GB discrepancy. Does…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…, and the only difference in query time is 48.78s vs 48.91s, so I don’t see Hash Join and… the amount of data is read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5…
Comment: Percona Server 5.5.21-25.1 released!
March 30, 2012 By 8 Comments
Yep, much appreciated – thanks! Btw, is Percona looking to create a build for the 5.6.x series? We are trying to decide between Percona 5.5.x vs Mysql 5.6.x (assuming that goes GA by summer) for a new project and would like to know your thinking. (FWIW – we have a support contract w/ Percona) AD
Comment: Best kept MySQLDump Secret
March 30, 2012 By 11 Comments
Eric, I tested it with MySQL 5.5 I think what huarong had is just different timing. ALTER TABLE Will be blocked if that table is being dumped right now. However if mysqldump is processing table “A” and you’re altering table “Z” at this time Alter Table will not be blocked.
Comment: Best kept MySQLDump Secret
March 29, 2012 By 11 Comments
… on windows2003 mysql 5.5.15 while mysqldump is going , alter table was BLOCKED! Eventually mysqldump got the old table definition and…
Comment: Best kept MySQLDump Secret
March 25, 2012 By 11 Comments
I wrote about the alter table issue a few years ago and filed bug http://bugs.mysql.com/bug.php?id=28432 which was incorrectly closed as fixed. I’m surprised that more people weren’t upset about it. Maybe I should have added notes about mysqldump.
