MyBB Community Forums

Full Version: How can I optimize my database? mybb 1.8
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I destroyed server Sad Reinstalled all..

So, I can't upgrade to MySQL 5.6 (I don't know how to do and I don't want retry..).

If I change only mybb_sessions from MyISAM to MEMORY? also MEMORY has full text thing? Because if I navigate site like a guest if it really very fast.
But when I login and I try to navigate in posts, it becomes more slow..

Otherwise I keep forum slow and patience...
You don't want to use MEMORY for any other tables other than sessions because on server restarts all data in that table will be truncated.

You could give my Fast Search plugin a try.
The full text index doesn't (particularly) affect anything other than search.

Have you looked at the MyBB debug page? How much of the time is spent on MySQL processing, and can you identify any slow queries?
Hi, I think it was a problem with a plugin, edited and deleted "NOT LIKE 'moved|%'" and for now it's very fast
The reason the NOT LIKE 'moved|%' is in there is because threads that do have that are a redirect.
Pages: 1 2