Forum seems to be running faster

[Kostya Vasilyev]

Just going to post some nonsense

I switched the forum's back end from MyISAM to InnoDB, and it seems that browsing, and especially posting messages is much faster now.

Talking to myself here, really, please ignore.

[Mozart]

Hello Kostya, hoping you'll respond to my post regarding Apex Launcher Pro assisting with new email notifications.

I posted in General Discussions

Thanks!

[bfm]

is much faster now.

Yes it is. gj done.

[Rachel Ambler]

This is the sort of post that brings out the DBA in me (it being my day job and all)

At a guess I'd hazard a stab at concurrency with MyISAM as being the culprit given the lack of granular locking in the engine.

I was faced with the same decision recently when setting up a WikiMedia site using MySQL as the backend DB. Went for InnoDB as the engine just because of the concurrency issue.

It still working out for you?

R

Sent from my SCH-I535 using Tapatalk 2

[Kostya Vasilyev]

Yes, you're absolutely right. It's a concurrent locking limitation inherently present in MyISAM.

I believe it was mostly because of user session tracking, which this forum software by default stores in the database (there is a way to use in-memory storage -- APC or memcached -- but I haven't had the time or a reason to figure out how to switch).

And yeah, it's still fine, the MySQL "slow log" only reports one or two slow queries per week (I have it set at two seconds).

Obviously, this forum is very low traffic, but then again it's a low-end VPS... and also runs the main wordpress site (but that's cached using nginx, so barely any system load)...

Overall, very happy with my VPS -- it's Linode -- and it's sort of fun to connect and tweak a few things every now and then