通过联合索引优化MYSQL慢查询
一、慢SQL分析
慢SQL如下
SELECT SUM(t.amount) as amount FROM (SELECT game_id,room_id,is_robot,amount,record_time FROM t_statements_logs WHERE game_id = 30 AND is_robot = 0 ORDER BY record_time DESC)t
GROUP BY t.room_id ORDER BY t.record_time
show global status like 'Com_select'; -- 执行select操作的次数
show global status like 'Com_insert';
show global status like 'Com_update';
show global status like 'Com_delete';
show global status like 'Innodb_rows_read'; -- select 查询返回的行数
show global status
