… much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does it affect MySQL performance, and I am going to run some MySQL… talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar. Follow…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as… it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards… talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar. Disclaimer…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… is further extended to improve join performance. As I told you above, when table t1 would be joined to table t2, then selected… before MySQL has only supported one join algorithm and that is Nested Loop Join. MariaDB has introduced a new join algorithm Hash Join. This join algorithm… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search… Timour explanation somewhat conflicting though as if we assume MySQL users do not join lots of tables (less than 7) when using… important than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins of many tables as optimizer…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… improve the performance of secondary key lookups as well. But this works only with joins and specifically with Block Access Join Algorithms. So…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented key…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… be used. Your tpcc-mysql for example doesn’t use JOINs, something we know is expensive in the MySQL world, yet Oracle and to some extent SQL Server handle better. JOIN has long been something MySQL has done… emphasising benchmarks that benchmark performance across the board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… the most popular. I do not particularly like its write performance – I wrote about it before, that’s why I am… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as… talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar. Follow…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… instead of expected performance improvement you see your performance being worse. What should you do ? First if you followed MySQL upgrade best practices… (for example with MySQL Sandbox) can especially be helpful. Once you have spotted the query which performs differently between MySQL Server versions you… to the old one by using hints such as STRAIGHT_JOIN, FORCE INDEX, BIG_RESULT/SMALL_RESULT. Check whatever stats are…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… a small benchmark which shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you… show close performance, while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE c.city from cities_join c JOIN states s…
