Query gore je optimizovan ..i ja bio srecan..dok eto nisam primetio da ga ponovo stavlja u slow query ... i ja da proverim kad gle cuda...vise nije optimizovan kao pre
Code (sql):
mysql> EXPLAIN SELECT v.VID, v.title, v.channel, v.duration, v.thumb, v.thumbs, vs.viewnumber, vs.rate, v.videoURL
-> FROM video v
-> JOIN video_stats vs
-> USING ( VID )
-> WHERE v.TYPE = 'public'
-> AND v.active = '1'
-> ORDER BY v.addtime DESC
-> LIMIT 18;
+----+-------------+-------+--------+--------------------+---------+---------+----------------+-------+-----------------------------+
| id | select_type | TABLE | TYPE | possible_keys | KEY | key_len | REF | ROWS | Extra |
+----+-------------+-------+--------+--------------------+---------+---------+----------------+-------+-----------------------------+
| 1 | SIMPLE | v | ALL | PRIMARY,all_in_one | NULL | NULL | NULL | 26210 | USING WHERE; USING filesort |
| 1 | SIMPLE | vs | eq_ref | PRIMARY | PRIMARY | 8 | redtubes.v.VID | 1 | |
+----+-------------+-------+--------+--------------------+---------+---------+----------------+-------+-----------------------------+
2 ROWS IN SET (0.00 sec)
mysql> EXPLAIN SELECT v.VID, v.title, v.channel, v.duration, v.thumb, v.thumbs, vs.viewnumber, vs.rate, v.videoURL
-> FROM video v
-> JOIN video_stats vs
-> USING ( VID )
-> WHERE v.TYPE = 'public'
-> AND v.active = '1'
-> ORDER BY v.addtime DESC
-> LIMIT 18;
+----+-------------+-------+--------+--------------------+---------+---------+----------------+-------+-----------------------------+
| id | select_type | TABLE | TYPE | possible_keys | KEY | key_len | REF | ROWS | Extra |
+----+-------------+-------+--------+--------------------+---------+---------+----------------+-------+-----------------------------+
| 1 | SIMPLE | v | ALL | PRIMARY,all_in_one | NULL | NULL | NULL | 26210 | USING WHERE; USING filesort |
| 1 | SIMPLE | vs | eq_ref | PRIMARY | PRIMARY | 8 | redtubes.v.VID | 1 | |
+----+-------------+-------+--------+--------------------+---------+---------+----------------+-------+-----------------------------+
2 ROWS IN SET (0.00 sec)
Kako je sad ponovo stavio filesort? i kako ne nadje sad key? A radio je pre koju nedelju odlicno