3.0.1 keeps locking tables - server run out of connections

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
amochohan
Registered User
Posts: 92
Joined: Tue Dec 11, 2007 2:59 pm

3.0.1 keeps locking tables - server run out of connections

Post by amochohan »

As per the title really,

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;

amochohan
Registered User
Posts: 92
Joined: Tue Dec 11, 2007 2:59 pm

Re: 3.0.1 keeps locking tables - server run out of connections

Post by amochohan »

Anyone???!!!

User avatar
Phil
Former Team Member
Posts: 10403
Joined: Sat Nov 25, 2006 4:11 am
Name: Phil Crumm
Contact:

Re: 3.0.1 keeps locking tables - server run out of connections

Post by Phil »

You should just be able to alter the table(s) as per your query.
Moving on, with the wind. | My Corner of the Web

Seether
Registered User
Posts: 74
Joined: Thu Apr 10, 2003 8:09 pm

Re: 3.0.1 keeps locking tables - server run out of connections

Post by Seether »

amochohan wrote:
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.
I have the same problem, but max_user_connection ist set to 150.

Did you're board runs fast again after changing to innodb?

Locked

Return to “[3.0.x] Support Forum”