Hello everyone. I have copied the results from and explain on a query that I want to use.
And I am wondering if anyone could tell me if these results are bad or good?
If everything below is coming up garbled for you I will basically I am using 7 tables and
the rows for 6 of the seven are 1 and the the seventh has 190892916 effected.
+-------+--------+----------------------------------+---------+---------+--------------+-----------+---------------------------------------------+
| table | type | possible_keys | key | key_len | ref |
rows | Extra |
+-------+--------+----------------------------------+---------+---------+--------------+-----------+---------------------------------------------+
| bl | ALL | PRIMARY,receiver | NULL | NULL | NULL |
190892916 | where used; Using temporary; Using filesort |
| bm | eq_ref | PRIMARY,sender | PRIMARY | 4 | bl.id |
1 | |
| m | eq_ref | PRIMARY,account_login_last_index | PRIMARY | 15 | bl.receiver |
1 | where used |
| mi | eq_ref | PRIMARY | PRIMARY | 15 | m.nick |
1 | |
| be | eq_ref | PRIMARY | PRIMARY | 15 | m.nick |
1 | where used; Using index; Not exists |
| ms | eq_ref | PRIMARY | PRIMARY | 15 | bm.sender |
1 | |
| si | eq_ref | PRIMARY | PRIMARY | 15 | ms.nick |
1 | |
| z | eq_ref | PRIMARY | PRIMARY | 10 | m.zip,ms.zip |
1 | |
+-------+--------+----------------------------------+---------+---------+--------------+-----------+---------------------------------------------+
