Web Hosting Talk







View Full Version : How to config my server to fixe this proplem ?


castleknight
05-07-2004, 11:53 AM
Hi there ...

my fourm's database size ( 1.8 G ) ..

last three day's my fourm was closed cause of this proplem .. and it show that proplem when i tried to access the database from phpMyAdmin ..

---------------

#1203 - User my-user@localhost has already more than 'max_user_connections' active connections

---------------

mr.Steve Machol from vbulletin said :

all you can do is ask your host to raise the maximum number of connections they allow.

And i don't now how to do it ???

i use plesk 7 in my server

Thank's

Best Regard's

CRego3D
05-07-2004, 02:07 PM
on your my.cnf file

set-variable = max_connections=XXX

change XXX with a value over 100 .. since 100 is usally the default

Steven
05-09-2004, 11:07 PM
make sure you restart mysql after you make that change.