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…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 5 Comments
…, while 8! = 40320. The worst-case complexity of MySQL’s join optimizer is N!. The goal of this choice was to…
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 5 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…
Comment: MariaDB 5.3.4 benchmarks
February 22, 2012 By 22 Comments
Cache 
Try joining a table with a nested query, include a where clause … as it does not support hash join. But it compensates by caching the results and the joined temp table. However if you… mysql to expire its cache related to that join. Mariadb is faster with those joins but seems like its cache system could…
