mysql error: Too many connections?!?

**Wayne Luke** · Wed 13 Feb '02, 4:47pm

It means you are getting popular..

If you are on a dedicated server you can tweak your MySQL installation and increase the number of concurrent connections allowed.

If you are on shared hosting, you can turn off persistant connections in admin/config.php.

**X-Fan** · Wed 13 Feb '02, 5:06pm

Originally posted by wluke
It means you are getting popular..

Always a plus!

If you are on a dedicated server you can tweak your MySQL installation and increase the number of concurrent connections allowed.

If you are on shared hosting, you can turn off persistant connections in admin/config.php.

My site's on a private server, and to be honest I'm a newbie at all this! What do I have to tweak and how?

Also, I'm curious, but is 3781 MB bandwidth for just over a day's running time good/bad/average for a site running vBulletin 2.2.2 with the vbPortal 3.0 front end?

**X-Fan** · Thu 14 Feb '02, 2:21am

Originally posted by X-Fan
What do I have to tweak and how?

Anyone... anyone...?

I'd really appreciate some help with this!

Cheers,

**George L** · Thu 14 Feb '02, 5:43am

Originally posted by X-Fan

Anyone... anyone...?

I'd really appreciate some help with this!

Cheers,

to tweak your server you'll need me hehe

do you have root server access ? if you do i need the following info so i can help you tweak your server

provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

and post url to that here

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?

8. my sig has lots of mysql and vB related articles and documents

**X-Fan** · Thu 14 Feb '02, 4:34pm

Originally posted by eva2000
1. your server specs, such as mysql and php version

mySQL v3.23.36 and PHP v4.0

2. if possible how mysql was compiled/installed

It was there when I got there!

3. your top stats

Which particular top stats?

or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

I uploaded and ran that script, but all I got was a blank page with the source code of:

Code:

<html><body><pre>


</pre></body></html>

6. oh and is your vB the only thing on the server? or other scripts? sites?

vbPortal, and that's it.

7. how many average and max concurrent users on your vB forum ?

Average 60-80, max concurrent was 193.

**George L** · Sun 17 Feb '02, 7:20pm

how much memory does your server have and cpu speed ?

and what's the exact version of PHP you can create a phpinfo.php file with

<?
phpinfo();
?>

inside it and upload to your web site and give us the url to it

**X-Fan** · Sun 17 Feb '02, 7:46pm

Originally posted by eva2000
how much memory does your server have and cpu speed ?

PIII 1130 MHz with 2048MB RAM.

For full specs, click here

- it's the iP Server4000 package.

and give us the url to it

Just a moment...

http://x-mencomics.com/xfan/forums/phpinfo.php

Note that the admin contact given is not me, but my business partner's.

**George L** · Sun 17 Feb '02, 7:56pm

looks like you have full root access on a private server parition

you can create a file as root user

/etc/my.cnf

in my.cnf place the following

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=3M
set-variable = record_buffer=3M
set-variable = sort_buffer=4M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=3600
set-variable = connect_timeout=10

[safe_mysqld]
open-files-limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=128M

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

and restart mysql

**X-Fan** · Sun 17 Feb '02, 8:02pm

Originally posted by eva2000
looks like you have full root access on a private server parition

Well my business partner has the password, so I'll get him to do it.

and restart mysql

Scuse my newbie-ness showing, but how do I restart mySQL? And what effect will that have on the existing database?

**George L** · Sun 17 Feb '02, 8:10pm

try

/etc/rc.d/init.d/mysql stop
/etc/rc.d/init.d/mysql start

or

mysql.server stop
mysql.server start

you might need to find the correct path to those for ensim private servers

mysql error: Too many connections?!?

mysql error: Too many connections?!?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment