Huge table in database

  • Resolved gigsakos

    (@gigsakos)


    2 years, 1 month ago

    Hello!

    wp_slim_stats on database is 1.6gb and all my database is 2gb, how can i keep only for 365 days data, i don’t want the data for years, because the size on my database increase too much.

    thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Mostafa Soufi

    (@mostafas1990)

    2 years ago

    Hello,

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

    Best

    Thread Starter gigsakos

    (@gigsakos)

    2 years ago

    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!

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    2 years ago

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

    Thread Starter gigsakos

    (@gigsakos)

    2 years ago

    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!

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    2 years ago

    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.

    Thread Starter gigsakos

    (@gigsakos)

    2 years ago

    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.

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    2 years ago

    Yes, that’s correct.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Huge table in database’ is closed to new replies.