PunBB Forums - max user connections

Re: max user connections

dummy@example.com (Papillon) — Fri, 05 Jun 2009 18:11:27 +0000

Thank you sirena.
I'll wait to see if the problem occurs again before trying your tips.

Re: max user connections

dummy@example.com (sirena) — Thu, 04 Jun 2009 21:40:31 +0000

Some useful info:

http://dev.mysql.com/doc/refman/5.1/en/ … tions.html

The note about setting the crawl-delay in robots.txt may be particularly handy, if the bump in connections is caused by search bots hammering you.

The note about adding the 'php_value mysql.connect_timeout 20' line into your .htaccess for the forum might also do some good.

Re: max user connections

dummy@example.com (Papillon) — Thu, 04 Jun 2009 11:19:01 +0000

I will try to check it on a busy moment. I was just wondering if I should change anything, but apparently not?

Re: max user connections

dummy@example.com (Cereal) — Thu, 04 Jun 2009 11:16:04 +0000

could be on a verry calm moment

on a bussy moment (when you have the problem) it should be a lot more

Re: max user connections

dummy@example.com (Papillon) — Thu, 04 Jun 2009 11:09:02 +0000

It just gives one table with 1 row. Makes sense?

Re: max user connections

dummy@example.com (Cereal) — Thu, 04 Jun 2009 10:58:14 +0000

you can run this in phpmyadmin to

just hit sql and then past the comand

Re: max user connections

dummy@example.com (Papillon) — Thu, 04 Jun 2009 10:55:39 +0000

I may do it now as the error is not occurring right now... But honestly, I don't know exactly how to "log into a mysql shell".
(php, mysql, ... -illetrate)

Re: max user connections

dummy@example.com (Cereal) — Thu, 04 Jun 2009 10:51:37 +0000

well it would be good to ahve the output of both commands,

when its not occuring and when its ocuring

Re: max user connections

dummy@example.com (Papillon) — Thu, 04 Jun 2009 10:48:17 +0000

Actually, the forum doesn't show the error message right now. I found out about it in the morning, and 30 minutes later, it was gone. But it sure will occur again since nothing is done to fix it.

Would it still help to run that command?

Re: max user connections

dummy@example.com (Cereal) — Thu, 04 Jun 2009 10:45:32 +0000

on the moment you have this log in into a mysql shell and do the

SHOW PROCESSLIST;

command and output the data here, then we can see what the server is really doing at that time ...

Re: max user connections

dummy@example.com (Papillon) — Thu, 04 Jun 2009 10:33:03 +0000

I have the same problem. The only thing I did last night was upgrade from Punbb 1.2.20 to 1.2.21.

Here is the response my hosting provided:

On our new platform the MySQL concurrent connection is 10 at a time, so you are receiving the error message ‘max_user_connections’. Hence, I suggest you to restrict the limit to less than 10 at a time by editing your script it will fix the issue.

Can someone please tell me what should I do concretely? (step by step)

Thanks a lot.

Re: max user connections

dummy@example.com (TFD) — Tue, 23 Oct 2007 20:40:30 +0000

ok. Thanks. I'll see what they come up with.

Re: max user connections

dummy@example.com (elbekko) — Tue, 23 Oct 2007 20:39:30 +0000

It shouldn't be. PunBB-Hosting used to be on shared hosting for quite a while with a whole lot of concurrent connections, so it shouldn't be a problem.

Re: max user connections

dummy@example.com (TFD) — Tue, 23 Oct 2007 20:31:27 +0000

I have no reference to know if 70 people on and posting at once is a big load for mysql or this message board software or shared hosting so Im having a hard time deciding what to do.

Re: max user connections

dummy@example.com (elbekko) — Tue, 23 Oct 2007 20:29:32 +0000

Hrmm, those shouldn't cause problems.