MySQL Forums
Forum List  »  Optimizer & Parser

Re: Join Query Performance Problme
Posted by: irek kordirko
Date: February 01, 2012 11:14AM

Please post output of these commands:
SHOW TABLE STATUS LIKE 'tablename' - for all your 4 tables
SHOW CREATE TABLE tablename - for all your 4 tables

Please surround these outputs with code tags - [ code ] + [/ code ]
thanks to code tags your post will be more readable, like this (with code tags)
+----+-------------+-------+------+------------------------+------+---------+------+------+----------------------------------------------------+
| id | select_type | table | type | possible_keys          | key  | key_len | ref  | rows | Extra                                              |
+----+-------------+-------+------+------------------------+------+---------+------+------+----------------------------------------------------+
|  1 | SIMPLE      | ww    | ALL  | fk_workerwork_workerid | NULL | NULL    | NULL |    3 |                                                    |
|  1 | SIMPLE      | w     | ALL  | PRIMARY                | NULL | NULL    | NULL |    3 | Using where; Using join buffer (Block Nested Loop) |
+----+-------------+-------+------+------------------------+------+---------+------+------+----------------------------------------------------+

and not like this (without code tags):
+----+-------------+-------+------+------------------------+------+---------+------+------+----------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+------------------------+------+---------+------+------+----------------------------------------------------+
| 1 | SIMPLE | ww | ALL | fk_workerwork_workerid | NULL | NULL | NULL | 3 | |
| 1 | SIMPLE | w | ALL | PRIMARY | NULL | NULL | NULL | 3 | Using where; Using join buffer (Block Nested Loop) |
+----+-------------+-------+------+------------------------+------+---------+------+------+----------------------------------------------------+

Please explain which exactly query do you want to optimize ?
I see three queries, but only one explain plan, and I am not sure.

Options: ReplyQuote


Subject
Views
Written By
Posted
2104
February 01, 2012 06:51AM
Re: Join Query Performance Problme
1121
February 01, 2012 11:14AM
1145
February 02, 2012 12:39AM
1114
February 02, 2012 06:47AM
1147
February 02, 2012 07:02PM
1112
February 03, 2012 12:29AM
1356
February 03, 2012 11:27AM
1139
February 04, 2012 10:39AM
1123
February 06, 2012 06:13AM
1274
February 14, 2012 06:08PM
1127
February 03, 2012 10:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.