It looks like a log table

It looks like a log table

by 의과대학 의학3,4학년 고신대학교 -
Number of replies: 0

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

use kucmwbi;

SET timestamp=1578298903;

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.
Average of ratings: -