So lately my MySQL database has been exceeding his capacity on a regular basis due to the overflowing evo_sessions. It used to occur monthly, but soon started occurring weekly, and now it's happening every few days. Truncating the table from cPanel from my ISP is not too painful, but it does get annoying.
It seems that my site (giandosigurani.com) is recording EVERY session in its evo_sessions table. For some reason, spambots have taken a special liking to my site, and I'm constantly getting referred by skeevy Russian porn and illegal software sites. By the thousands. True story.
So my question is twofold. 1) is there a way I can config B2Evo not to record anything in the evo_sessions table? Or perhaps a way to make it automatically truncate the tables every day or so? And 2) is there any way I can block those skeevy Russian sites?
Thanks in advance for the help.
General Support
b2evolution CMS Support Forums
Hi @giandroid,
I guess that there is no way to configure b2evolution to don't save certain session records, but you can trim them automatically by using the scheduler (http://b2evolution.net/man/scheduler). You need to set a "Prune old hits & sessions" job (http://b2evolution.net/man/task-prune-old-hits-and-sessions), and make it repeatable according the frequency that you consider necessary.
Regarding your second question, maybe your hosting provider can give you more help with that, however, here is a (long) post describing a similar problem that can work as a staring point: http://forums.b2evolution.net/excessive-server-resource-usage.
Regards!