MyBB Community Forums

Full Version: if i change my database tables from myisam to innnodb
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
if i change my database tables from myisam to innodb will it affect other plugs such as google seo and upgrades.
am being facing a problems of high server load and the maximum user connection error so somebody was experiencing the same problem i he changed the user,thread and post tables to innodb .so if any one have the ideas please let me know
thanks
my url :www.bigbrotherafrica.com/forum
using 1.4.13 version
I´ve read this type of thing once in SMF Forums, related to perfomance gain

but I think a thread from Labbroca or Ryan Gordon (I don´t remember wich of them) quoted that only "sessions" table must be 'innodb' in mybb to speed up things

"sessions" table change from MyIsam to Memory
ALTER TABLE `mybb_sessions` ENGINE = heap

for this statistic, you may run on VPS server except you didn't use too many plugins.
Our members have made a total of 86,295 posts in 6,470 threads.
We currently have 30,144 members registered & 4191 active users
Labrocca recently (a few months ago?) wrote a pretty detailed thread about his million+ posts board (or was it 2 or 3 million+? I forget now Smile ) in which I believe he discussed things such as this.