I have a small(ish) forum, with around 150 users online at any given time. 50,000 posts or thereabouts. Basically, I keep getting the problem where it says 'Too Many Connections'.
I'm on dedicated premium hosting and have 100 connections set available to my server. I've checked the processlist and there is a lot of tables which are locked. Most of these are simple SELECT statement queries on the phpbb_users and phpbb_sessions tables.
The tables are currently myISAM but I am thinking of changing them to INNODB to prevent them getting locked.
Just thought i'd check, can this be as simple as changing the table engines as normal or do I need to also do anything with the phpBB config?
Is there anything else I could do to prevent tables from getting locked?
For anyone else who might need to change to InnoDB, use the following query:
Code: Select all
ALTER TABLE tablename ENGINE = InnoDB;