Huge table in database

Hello,

Thank you for opening the topic, please go to Settings → General and set the day for “Data Retention”

Best

hello!

if i set it now to 365 the other days will be deleted? or should i delete them manually? because after this setting my database table is still 1.6gb

(wp_slim_stats 2353628 1.6 GB)

thanks!

It a cronjob event which will be run twice a daily.

Hello!

after that option my database increase more now, now it is 3.2gb and about 2.5gb is slimstat, why so much data on database? how can i delete this data from my database? why it doesn’t delete the older than 365days?

thanks!

Weird indeed, I’d prefer to take a look at the database, but however you can delete the old data manually by the SQL query

DELETE FROM wp_slim_events
WHERE DATEDIFF(NOW(), FROM_UNIXTIME(dt)) > 365;

DELETE FROM wp_slim_stats
WHERE DATEDIFF(NOW(), FROM_UNIXTIME(dt)) > 365;

Before executing the query, get a backup/export from those tables.

Hello! i’m not familiar so with mysql so i deleted all the records from wp-slimstat settings, but (wp_slim_stats_archive1190140 – 848.8 MB) how can i delete this data from database, if i only delete or empty rows it will gone ?and i add to settings to keep data for 365 days now.

Yes, that’s correct.