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…
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: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 22, 2012 By 10 Comments
Oystein, As benchmark show using MRR makes sense when data is not in memory. Do you have any plans to store information about how much of the table fits in memory ? It can be helpful for other choices too, for example full table scan vs index scan depends a lot whenever table is in memory or not.
Comment: ext4 vs xfs on SSD
March 19, 2012 By 23 Comments
… average). At 16 threads it was a draw (2036 tps vs. 2070 tps). At 32 threads ext4 was 28% faster (2345 tps vs. 1829 tps). At 64 threads ext4 was even 47% faster (2362 tps vs. 1601 tps). At higher concurrency ext4 lost it’s bite…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
Baron: On MariaDB vs Percona server, I sometimes see MariaDB having a group consisting …
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… scaling limitations of server x. (Kinda a once off exercise vs something that should be done with iterative code releases) I… thats our solution – and interms of development costs to rearchitect vs cost-making initiatives; its the right way. (Shading is frickin…
