Advertisement
Guest User

Untitled

a guest
May 26th, 2013
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 3.33 KB | None | 0 0
  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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement