MyBB Community Forums

Full Version: Optimization and reduce size of database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,
I have a question regarding to optimization of the MyBB database and table sizes - mybb_searchlog has currently a size of over 4GB and mybb_captcha almost 1 GB -  this is almost 90% of the database size - could you tell me somehow optimize it, clear these records without affect on forum? In mybb_searchlog, all searches performed by users are saved - a few thousand a day, so there will be more and more of these records. What do you recommend doing in such a situation?
You can safely truncate the captcha and searchlog tables

TRUNCATE TABLE mybb_searchlog;

TRUNCATE TABLE mybb_captcha;