Author Topic: Forum seems to be running faster  (Read 4981 times)

Kostya Vasilyev

  • Hero Member
  • *****
  • Posts: 12740
Forum seems to be running faster
« on: May 06, 2013, 03:42:56 am »
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.
Creating debug logs for diagnostics: https://www.aqua-mail.com/troubleshooting/

The official FAQ: https://www.aqua-mail.com/faq/

Лог-файлы для диагностики: https://www.aqua-mail.com/ru/troubleshooting/

Вопросы и ответы: https://www.aqua-mail.com/ru/faq/

Mozart

  • Newbie
  • *
  • Posts: 5
Re: Forum seems to be running faster
« Reply #1 on: May 07, 2013, 04:42:44 am »
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

  • Newbie
  • *
  • Posts: 5
Re: Forum seems to be running faster
« Reply #2 on: May 10, 2013, 01:43:11 pm »
Samsung Note 2 (GT-N7100)

Rachel Ambler

  • Full Member
  • ***
  • Posts: 140
  • Responsis, plura interrogandi
    • Random Thunks
Re: Forum seems to be running faster
« Reply #3 on: July 18, 2013, 08:12:50 am »
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

  • Hero Member
  • *****
  • Posts: 12740
Re: Forum seems to be running faster
« Reply #4 on: July 20, 2013, 02:16:07 am »
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 :)
« Last Edit: July 20, 2013, 02:22:01 am by Kostya Vasilyev, Aqua Mail »
Creating debug logs for diagnostics: https://www.aqua-mail.com/troubleshooting/

The official FAQ: https://www.aqua-mail.com/faq/

Лог-файлы для диагностики: https://www.aqua-mail.com/ru/troubleshooting/

Вопросы и ответы: https://www.aqua-mail.com/ru/faq/