在MySQL Front中执行大概0.03s:
SELECT * FROM `videos` WHERE MATCH(ti
tle) AGAINST('dogs,cats');
但在慢查询日志中,直接就2.7s了:
# Query_time: 2.761205 Lock_time: 0.000000 Rows_sent: 18627 Rows_examined: 18627
use videos;
SET timestamp=1453295616;
SELECT * FROM `videos` WHERE MATCH(title) AGAINST('dogs,cats');