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 …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… ran it on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). I did not use Scale Factor of 40 (InnoDB dataset size ~95G), because the query…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… ran it on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
… 4.95/325k 0.12/7k 4.86/319k Throughput scales with thread count – each thread runs at 100% CPU utilsation…
Comment: ext4 vs xfs on SSD
March 16, 2012 By 23 Comments
What would be interesting is to see your data beyond 4 threads. The presentation http://www.youtube.com/watch?v=FegjLbCnoBw shows EXT4 did really well until scaling beyond 4 threads.
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… flash storage is used appropriately for MySQL workloads Approaches for scaling MySQL instances on fewer servers while delivering optimal performance using…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
… most obvious one. MySQL (and systems in general) do not scale perfectly with numbers of CPUs and number of concurrent requests… process. The scalability numbers depend a lot on the system scale, software and workload. Data size impact There are different type… stream in single thread which means it replication can’t scale for large amount of writes. The lack of parallel query…
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
… you may have recently seen there are some articles about scaling MySQL one 256-way system. I though wow did they… or 256 threads all together. Now what is about MySQL scaling to use these 32 cores with 256 threads ? Especially with… which is of course extremely poor number. The scale out and ability to scale by using as many MySQL instances as you…
Post: Percona Server Scales Vertically with Virident tachIOn Drives
February 28, 2011 By Leave a Comment
… white paper that explains how to stop sharding and start scaling vertically with PCI-E flash drives, specifically the Virident tachIOn…-latency I/O performance, exemplified by the Virident tachIOn drive. “Scaling up” is once again a viable and economical strategy for MySQL, and “scaling out” need no longer be the default database architecture.
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got a lot of attention, there can be other quite typical workloads however which do not scale that well. This is why it is important to test…
