Что у меня в slow log mysql выпало много медленных запросов
Code: Select all
use base1;
SET timestamp=1639180800;
SELECT * FROM broker_zone_stats ORDER BY datetime DESC LIMIT 10000;
# Time: 2021-12-11T00:00:04.509023Z
# Query_time: 3.519863 Lock_time: 0.000169 Rows_sent: 10000 Rows_examined: 1579238
use base2;
SET timestamp=1639180800;
SELECT * FROM broker_zone_stats ORDER BY datetime DESC LIMIT 10000;
# Time: 2021-12-11T00:00:04.517266Z
# Query_time: 3.810421 Lock_time: 0.000121 Rows_sent: 10000 Rows_examined: 1579238
....
use base 50;
SET timestamp=1639225926;
SELECT * FROM broker_zone_stats ORDER BY datetime DESC LIMIT 10000;
# Time: 2021-12-11T12:32:08.684613Z
# Query_time: 2.347666 Lock_time: 0.000106 Rows_sent: 10000 Rows_examined: 1589305