List:General Discussion« Previous MessageNext Message »
From:Tom O'Neill \(MySQL User\) Date:July 23 2003 5:26pm
Subject:EXPLAIN - Question..
View as plain text  
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 |                                             |
+-------+--------+----------------------------------+---------+---------+--------------+-----------+---------------------------------------------+

Thread
What is a good benchmark?Jake Johnson23 Jul
  • RE: What is a good benchmark?Bryan Koenig23 Jul
    • Re: What is a good benchmark?Yves Goergen23 Jul
    • RES: What is a good benchmark?julio23 Jul
      • RES: What is a good benchmark?julio23 Jul
      • Re: RES: What is a good benchmark?NTLUG23 Jul
  • RE: What is a good benchmark?artem23 Jul
  • RE: What is a good benchmark?Christopher Knight23 Jul
    • Re: What is a good benchmark?Andrew Edwards23 Jul
      • RE: What is a good benchmark?Christopher Knight23 Jul
        • RE: What is a good benchmark?mos23 Jul
          • RE: What is a good benchmark?Jeff Shapiro26 Jul
    • Re: What is a good benchmark?David Griffiths23 Jul
RE: What is a good benchmark?John Griffin23 Jul
RE: What is a good benchmark?Dan Hubbard23 Jul
  • Re: What is a good benchmark?Jim Dickenson23 Jul
    • Re: What is a good benchmark?Chris Knipe23 Jul
    • EXPLAIN - Question..Tom O'Neill \(MySQL User\)23 Jul
RE: What is a good benchmark?John May23 Jul
  • RE: What is a good benchmark?Asif Iqbal29 Jul
    • Re: What is a good benchmark?Jeremy Zawodny29 Jul
      • Re: What is a good benchmark?daniel29 Jul
    • Re: What is a good benchmark?Dan Nelson29 Jul
      • Re: What is a good benchmark?Asif Iqbal29 Jul
        • Re: What is a good benchmark?Dan Nelson29 Jul
          • Re: What is a good benchmark?Asif Iqbal29 Jul
            • Re: What is a good benchmark?Dan Nelson29 Jul
RE: What is a good benchmark?Mark Graves23 Jul
RE: What is a good benchmark?Andrew Braithwaite23 Jul
  • Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlEgor Egorov24 Jul
  • Re: What is a good benchmark?Gustavo A. Baratto23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlNils Valentin24 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
Re: Re-attaching DB to mysqlNils Valentin24 Jul