SHARE
TWEET

Untitled

a guest May 26th, 2013 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL [MyMusic32]> explain select * from songview limit 999999999999999999;
  2. +----+-------------+-------------+--------+-------------------+----------+---------+-------------------------+------+---------------------+
  3. | id | select_type | table       | type   | possible_keys     | key      | key_len | ref                     | rows | Extra               |
  4. +----+-------------+-------------+--------+-------------------+----------+---------+-------------------------+------+---------------------+
  5. |  1 | SIMPLE      | karaokedata | system | idxKarSong        | NULL     | NULL    | NULL                    |    0 | const row not found |
  6. |  1 | SIMPLE      | album       | ALL    | PRIMARY           | NULL     | NULL    | NULL                    | 1113 |                     |
  7. |  1 | SIMPLE      | song        | ref    | idxSong3,idxSong6 | idxSong3 | 5       | MyMusic32.album.idAlbum |   11 | Using where         |
  8. |  1 | SIMPLE      | path        | eq_ref | PRIMARY           | PRIMARY  | 4       | MyMusic32.song.idPath   |    1 |                     |
  9. +----+-------------+-------------+--------+-------------------+----------+---------+-------------------------+------+---------------------+
  10. 4 rows in set (0.00 sec)
  11.  
  12. MySQL [MyMusic32]> explain select * from artistview limit 999999999999999999;
  13. +----+-------------+------------+------+---------------+---------------+---------+---------------------------+------+-------+
  14. | id | select_type | table      | type | possible_keys | key           | key_len | ref                       | rows | Extra |
  15. +----+-------------+------------+------+---------------+---------------+---------+---------------------------+------+-------+
  16. |  1 | SIMPLE      | artist     | ALL  | NULL          | NULL          | NULL    | NULL                      |  465 |       |
  17. |  1 | SIMPLE      | artistinfo | ref  | idxArtistInfo | idxArtistInfo | 5       | MyMusic32.artist.idArtist |    1 |       |
  18. +----+-------------+------------+------+---------------+---------------+---------+---------------------------+------+-------+
  19. 2 rows in set (0.01 sec)
  20.  
  21. MySQL [MyMusic32]> explain select * from albumview limit 999999999999999999;
  22. +----+-------------+------------+------+---------------+--------------+---------+-------------------------+------+---------------------------------+
  23. | id | select_type | table      | type | possible_keys | key          | key_len | ref                     | rows | Extra                           |
  24. +----+-------------+------------+------+---------------+--------------+---------+-------------------------+------+---------------------------------+
  25. |  1 | PRIMARY     | <derived2> | ALL  | NULL          | NULL         | NULL    | NULL                    | 1113 |                                 |
  26. |  2 | DERIVED     | album      | ALL  | NULL          | NULL         | NULL    | NULL                    | 1113 | Using temporary; Using filesort |
  27. |  2 | DERIVED     | albuminfo  | ref  | idxAlbumInfo  | idxAlbumInfo | 5       | MyMusic32.album.idAlbum |    1 |                                 |
  28. |  2 | DERIVED     | song       | ref  | idxSong3      | idxSong3     | 5       | MyMusic32.album.idAlbum |   11 |                                 |
  29. +----+-------------+------------+------+---------------+--------------+---------+-------------------------+------+---------------------------------+
  30. 4 rows in set (1.64 sec)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top