Bloated database

  • Resolved dsmagic9

    (@dsmagic9)


    1 week, 4 days ago

    Hello!

    During a server issue today, MariaDB was using very high CPU, and the MySQL process list showed many repeated queries like:

    SELECT value FROM cleantalk_sessions WHERE id = …

    The database table cleantalk_sessions currently has approximately 203,455 rows and is about 82.27 MB.

    The server had also been receiving heavy bot/crawler traffic to fake gambling/spam URLs, which likely caused many CleanTalk session checks.

    Can you confirm whether this table size is normal, whether CleanTalk automatically cleans this table, and whether there are settings to reduce session/log retention or prevent the table from growing too much? I don’t want to have bloat in my database by storing all these sessions forever.

    Thank you for your time and help!

    • This topic was modified 1 week, 4 days ago by dsmagic9.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support sergecleantalk

    (@sergecleantalk)

    1 week, 4 days ago

    Hello,

    The size of the cleantalk_sessions depends on your website’s attendance. If I’m not wrong, the table should be cleared automatically once a day. I will ask our developers for more details. We will contact you within 1-3 business days.

    Plugin Support denisxam

    (@denisxam)

    1 week, 1 day ago

    Hello,

    We apologise for the delay, but our developers need more time to finalise the details. We will contact you within three days.

    Plugin Support sergecleantalk

    (@sergecleantalk)

    1 week ago

    Hello,

    Thank you for waiting. Yes, I can confirm that this table should be automatically cleared once every 24 hours. The size you mentioned is normal for 200000 unique visitors a day. The problem is if the number of visitors is less than 200000 while the table size is the same, and also if the table size is not correlated with the number of visitors. Unfortunately, there are no special options for this table.

    Please let us know if you have any further questions.

    Plugin Support sergecleantalk

    (@sergecleantalk)

    3 days, 8 hours ago

    Hello.
    We haven’t heard back from you in a few days, so I’m going to mark this topic as “resolved”.
    If you have any further questions, you can start a new topic or contact us via our private Ticket System: https://cleantalk.org/my/support/open.

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

You must be logged in to reply to this topic.