Wp_logs_meta > 1 million rows :/

[Elyaz]

Hello

My “wp_logs_meta” table is approaching 2 million rows… I cleared the “Site changes” section, but it didn’t make any difference.
The latest entries are as follows:

Any idea how to fix this?

[bojan (Bojan Katusic)]

Hey @Elyaz

wp_logs_meta stores the data from the Insights module.

To see those entries, navigate to the Sites Changes page (/wp-admin/admin.php?page=InsightsManage), select “Dashboard” as the source, and then click Filter data.

From that page you can also dismiss entries (for selected time period), but considering you have 2 million of them, it might be more performant to delete them directly from the DB.

As always, please make sure to back up your DB.