When checking whether a slow query occurred in the server, it was confirmed that a query delay occurred while selecting a large number of rows as shown below.
# Thread_id: 29080440 Schema: kucmwbi QC_hit: No
# Query_time: 5.846834 Lock_time: 0.000000 Rows_sent: 3275030 Rows_examined: 3275030
# Rows_affected: 0
SELECT /*!40001 SQL_NO_CACHE */ * FROM `mdl_logstore_standard_log`;
It looks like a log table, but it looks like data needs to be cleaned up.
If you could tell me how to organize it, I would appreciate it.