Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tips to increase mybb performence
#11
Quote:You can trim/empty mybb_sessions any time without logging anyone out.

Just to confirm what he says is true. Truncating the sessions table will not effect users. A new session row will be created based on their existing cookie.
#12
This user has been denied support. This user has been denied support.
Thanks for this thread, I have been looking for threads like this to make the site i'm working on
top of the line! Smile
MyBB Researcher
#13
hi,


based on my experience storage engine type 'memory' give better performance rather than InnoDb

because it take ram to store table buffers and field datas
#14
Have somebody how to with transfer all tables to InnoDB?
#15
Wow thank you, but why and how to change a "MyIsam" table to "MEMORY"??
#16
(2013-01-25, 05:30 AM)labrocca Wrote: Sessions best as InnoDB.

HF has a 300-500mb sessions table at any given time. It's perfectly fine. I had serious issues with MyISAM for sessions and even with MEMORY/HEAP. It's been 100% since I moved to InnoDB (MySQL 5.5+).

I find the complete opposite. InnoDB was a huge improvement over MyISAM for obvious row locking reasons, but I still ran into deadlocks every now and then on forums that got many hits very fast. These typically came from social sites such as stumble upon. I converted these forum's session tables to the memory engine and haven't had the problem since. I'm running MySQL 5.6.
RedHat Certified Systems Administrator
#17
So...if i change all tables to innoDB.

It required some modification in the installed plugins?

Best performance?

Any problems related?
[Image: 468x60_bf4brasil_site_zpsd7eefd7f.png]
#18
nice tips
MyBB From My Beautiful Board Heart


Forum Jump:


Users browsing this thread: 1 Guest(s)