Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL [MyMusic32]> explain select * from songview limit 999999999999999999;
- +----+-------------+-------------+--------+-------------------+----------+---------+-------------------------+------+---------------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+-------------+--------+-------------------+----------+---------+-------------------------+------+---------------------+
- | 1 | SIMPLE | karaokedata | system | idxKarSong | NULL | NULL | NULL | 0 | const row not found |
- | 1 | SIMPLE | album | ALL | PRIMARY | NULL | NULL | NULL | 1113 | |
- | 1 | SIMPLE | song | ref | idxSong3,idxSong6 | idxSong3 | 5 | MyMusic32.album.idAlbum | 11 | Using where |
- | 1 | SIMPLE | path | eq_ref | PRIMARY | PRIMARY | 4 | MyMusic32.song.idPath | 1 | |
- +----+-------------+-------------+--------+-------------------+----------+---------+-------------------------+------+---------------------+
- 4 rows in set (0.00 sec)
- MySQL [MyMusic32]> explain select * from artistview limit 999999999999999999;
- +----+-------------+------------+------+---------------+---------------+---------+---------------------------+------+-------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+------------+------+---------------+---------------+---------+---------------------------+------+-------+
- | 1 | SIMPLE | artist | ALL | NULL | NULL | NULL | NULL | 465 | |
- | 1 | SIMPLE | artistinfo | ref | idxArtistInfo | idxArtistInfo | 5 | MyMusic32.artist.idArtist | 1 | |
- +----+-------------+------------+------+---------------+---------------+---------+---------------------------+------+-------+
- 2 rows in set (0.01 sec)
- MySQL [MyMusic32]> explain select * from albumview limit 999999999999999999;
- +----+-------------+------------+------+---------------+--------------+---------+-------------------------+------+---------------------------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+------------+------+---------------+--------------+---------+-------------------------+------+---------------------------------+
- | 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 1113 | |
- | 2 | DERIVED | album | ALL | NULL | NULL | NULL | NULL | 1113 | Using temporary; Using filesort |
- | 2 | DERIVED | albuminfo | ref | idxAlbumInfo | idxAlbumInfo | 5 | MyMusic32.album.idAlbum | 1 | |
- | 2 | DERIVED | song | ref | idxSong3 | idxSong3 | 5 | MyMusic32.album.idAlbum | 11 | |
- +----+-------------+------------+------+---------------+--------------+---------+-------------------------+------+---------------------------------+
- 4 rows in set (1.64 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement