MyBB Community Forums

Is it good idea to make mybb_sessions temporary?

Code:

ALTER TABLE mybb_sessions TYPE=TEMPORARY

It should little help with MySQL performance IMO.

What do you think?

It shouldn't be marked as "temporary" since it's not. You may make it as memory, but that is all.

Thank you. Yes, I was thinking about memory type. I will try how it works.

It works good and I recommend it to prevent session table crashes.

It's recommended to use the 'ENGINE' keyword since 'TYPE' is deprecated

Code:

ALTER TABLE mybb_sessions ENGINE=MEMORY

witek