Run mysqladmin extended-status Look for something like this:
| Max_used_connections | 138 | If it says, 512 is your max connections that you have used, then you need to raise it. If your number is much lower and you are getting that problem, it's a different problem, but that's just what mysql is reporting. Donny > -----Original Message----- > From: Mark Susol | Ultimate Creative Media > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 07, 2004 10:35 PM > To: [EMAIL PROTECTED] > Subject: Too Many Connections > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
