Title: Bloated database
Last modified: May 1, 2026

---

# Bloated database

 *  Resolved [dsmagic9](https://wordpress.org/support/users/dsmagic9/)
 * (@dsmagic9)
 * [1 week, 4 days ago](https://wordpress.org/support/topic/bloated-database-3/)
 * 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](https://wordpress.org/support/users/dsmagic9/).

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

 *  Plugin Support [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/)
 * (@sergecleantalk)
 * [1 week, 4 days ago](https://wordpress.org/support/topic/bloated-database-3/#post-18896608)
 * 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](https://wordpress.org/support/users/denisxam/)
 * (@denisxam)
 * [1 week, 1 day ago](https://wordpress.org/support/topic/bloated-database-3/#post-18899309)
 * 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](https://wordpress.org/support/users/sergecleantalk/)
 * (@sergecleantalk)
 * [1 week ago](https://wordpress.org/support/topic/bloated-database-3/#post-18900554)
 * 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](https://wordpress.org/support/users/sergecleantalk/)
 * (@sergecleantalk)
 * [3 days, 8 hours ago](https://wordpress.org/support/topic/bloated-database-3/#post-18903752)
 * 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](https://cleantalk.org/my/support/open).

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

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fbloated-database-3%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/cleantalk-spam-protect/assets/icon-256x256.png?rev=1637702)
 * [Spam protection, Honeypot, Anti-Spam by CleanTalk](https://wordpress.org/plugins/cleantalk-spam-protect/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/cleantalk-spam-protect/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/cleantalk-spam-protect/)
 * [Active Topics](https://wordpress.org/support/plugin/cleantalk-spam-protect/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cleantalk-spam-protect/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cleantalk-spam-protect/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/)
 * Last activity: [3 days, 8 hours ago](https://wordpress.org/support/topic/bloated-database-3/#post-18903752)
 * Status: resolved