slow query log from /var/log/mysql/slow.log Count: 11 Time=0.12s (1s) Lock=0.00s (0s) Rows=7110.0 (78210), isucon[isucon]@localhost /* /home/isucon/webapp/perl/lib/Isuda/Web.pm line N */ SELECT * FROM entry ORDER BY CHARACTER_LENGTH(keyword) DESC Count: 2 Time=0.02s (0s) Lock=0.00s (0s) Rows=10.0 (20), isucon[isucon]@localhost /* /home/isucon/webapp/perl/lib/Isuda/Web.pm line N */ SELECT * FROM entry ORDER BY updated_at DESC LIMIT N OFFSET N Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), isucon[isucon]@localhost /* /home/isucon/webapp/perl/lib/Isuda/Web.pm line N */ SELECT COUNT(*) FROM entry
14216 SELECT keyword FROM entry ORDER BY CHARACTER_LENGTH(keyword) DESC; # Query_time: 0.373342 Lock_time: 0.000047 Rows_sent: 7108 Rows_examined: 14216 SELECT * FROM entry ORDER BY CHARACTER_LENGTH(keyword) DESC;