…. In this post I show the results of raw IO performance of this card. The benchmark methodology I described in previous… Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does… you did not attend my talk – you are welcome to join the webinar. Follow @VadimTk !function(d,s,id){var js…
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… you did not attend my talk – you are welcome to join the webinar. Follow @VadimTk !function(d,s,id){var js…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… Percona 5.5 server) I have a complex query w. joins on a table with 10+ million rows. Results are Data…) .90 for the data with SQL_CALC_FOUND_ROWS. No performance impact when using SQL_CALC_FOUND_ROWS 2) .013 for…
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… you did not attend my talk – you are welcome to join the webinar. Disclaimer: This benchmark is done as part of…
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… to the columns participating in the join condition and then a hash table lookup is performed, on the hash table we created… these buffers indirectly impact BKA performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just… taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to… EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… counters. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name… calls made to the storage engine to perform the index record read and then to perform the MRR range scan on the… improve the performance of secondary key lookups as well. But this works only with joins and specifically with Block Access Join Algorithms. So…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… with a perspective of how a piece of software will perform in the real world as much as possible, so they…, yet Oracle and to some extent SQL Server handle better. JOIN has long been something MySQL has done badly, people have… and not the Puppet, writing and emphasising benchmarks that benchmark performance across the board? With the increasing emergence of drop-in…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented …different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world …
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… 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…, but join query performance is 30% lower. Also note the times themselves – traversing about same amount of rows full table scan performs about…
