Peter, I think even changing the query to use index/join hints can bring down the time its taking the query to complete, did you try with STRAIGHT_JOIN and/or index hints.
Post: Webinar: MySQL and SSD
May 8, 2012 By Leave a Comment
Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… 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…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… you did not attend my talk – you are welcome to join the webinar. Disclaimer: This benchmark is done as part of…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… you did not attend my talk – you are welcome to join the webinar. Follow @VadimTk !function(d,s,id){var js…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… one join algorithm and that is Nested Loop Join. MariaDB has introduced a new join algorithm Hash Join. This join algorithm only works with equi-joins. Now let me briefly explain how hash join…
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… risk likehood of execution plans changing for some over queries joining less number of tables. I was wondering if 0 is… the default: – backwards compatibility, – the hypothesis that most users have joins with few tables, – it is not clear how far from…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… lookups as well. But this works only with joins and specifically with Block Access Join Algorithms. So I am not going to… in my next post which will be on Block Access Join Algorithms. Conclusion There is a huge speedup when the workload…
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 badly, people have… a kind of self-fulfilling prophesy, we don’t benchmark joins because they’re slow and we avoid them in the…
