What is the best way to diagnose the root cause of this error? What scripts
are doing the connecting and totalling them up?

Warning: mysql_connect(): User ultimated has already more than
'max_user_connections' active connections

I have a very active phpBB but I'm on a new server and its not pulling a
server loading over 0.5. I ran some data before (crontab php script gathered
the info for me every 5 minutes for several weeks) and the problem happened
before related to server loading..not necessarily how many users I had on
that site posting. That was an older Cobalt RaQ4. I seemed to be having a
lot of search bots accessing the site then.

[mysqld]
set-variable = max_connections=512
set-variable = max_user_connections=200
set-variable = key_buffer=64M
set-variable = table_cache=256
set-variable = sort_buffer=4M
set-variable = wait_timeout=300

I've only had this problem this week, its run 3 weeks fine. I do have a
corrupted MYI file according to myisamck.


Mark Súsol
-------------------------------
u l t i m a t e ­ CreativeMedia
Web | Print | CD Media | eCommerce
www.ultimatecreativemedia.com
Ph: 301-668-0588


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to