Not Solved [How To?] Optimization and reduce size of database
#1
Not Solved
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?
Reply
#2
Not Solved
You can safely truncate the captcha and searchlog tables

TRUNCATE TABLE mybb_searchlog;

TRUNCATE TABLE mybb_captcha;
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)