SMF Connection problems..

[wildmck8]

Hello.  I'm kinda new to this group, but have been running a SMF board for over a year now and love it.  Yesterday, I had a problem.  Whenever anyone tried to pull up my board (www.wildguzzi.com/forum), it would yield the following message:
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again late

I contacted my webhost and they replied with this:
There is a problem with your script.
It opened so many connections to the MySQL server and overused the connections limit. You need to fix your script.

The list of connection has been attached to this ticket.

Here is a link to the text file they sent me: http://www.wildguzzi.com/mysql.txt

A little more information that might be helpful.  I am running SMF 1.0.7, SQL version is 4.1.19-standard, Host is Midphase.  I have about 1600 registered members and at any given time there will be about 200 on the board.

As of right now, the board is up and running, but I worry this might happen again.  Any ideas on a fix for this.

Also, I get this message everyday in my email, in which I have been just deleting them.
From: Nobody [[email protected]]
Subject: Wildgoose Chase Moto Guzzi: SMF Database Error!
Message:There has been a problem with the database! MySQL reported:

Thanks for any help on this.

[sawz]

have you tried doing "Forum Mainteneance" in your Admin panel?

[wildmck8]

Yes, I just finished running the "repair" funtion on it right before you replied.  How ironic.  I dont know if this will correct it or not, but we'll see.  Thanks.

[Ben_S]

How big is your sessions table, something odd is going on there. Have a look with phpMyAdmin.

Also can you provide a link to status.php, download from the sticky topic above.

[wildmck8]

How big is your sessions table, something odd is going on there. Have a look with phpMyAdmin.

Also can you provide a link to status.php, download from the sticky topic above.

http://www.wildguzzi.com/forum/status.php
Peak times should be around noon...when everyone is on their lunch hour I guess :-)

[Ben_S]

How big is your sessions table, something odd is going on there. Have a look with phpMyAdmin.

[wildmck8]

How big is your sessions table, something odd is going on there. Have a look with phpMyAdmin.

Hope this helps:
Table         Action       Records      Type       Collation                     Size
35 table(s)  Sum          634,613      MyISAM  latin1_swedish_ci         62.2 MB

[Ben_S]

Try emptying it, people may have to log back it, but it shouldn't be that full.

[minstrel]

I've been experiencing the same problem with 1.1 RC2.

After the first time, I disabled the function that says "allow databse to manage sessions" or whatever. Today it happened again.

I have status.php at http://forum.psychlinks.ca/status.php - I don't see any output from it.

You can also view http://forum.psychlinks.ca/phpinfo.php if that helps.

[minstrel]

Uploaded the newer status.php from Ben_S and it tells me this:

Operating System: FreeBSD 4.11-STABLE
Processor: Intel® Pentium® 4 CPU 3.00GHz (
Notice: Undefined index: mhz in /home/psychlin/public_html/forum/status.php on line 825
MHz)
Load averages: 1.64, 2.10, 2.36
Current processes: 173 (92 sleeping, 42 running, 39 zombie)
Processes by CPU: httpd (43) 16.7%, mysqld (12) 1.8%, perl5.8.3 (3) 0.6% 
Memory usage: 96.228% (2014940k / 2093932k)
Swap: 0.005% (200k / 4194176k) 

MySQL Statistics
MySQL 4.0.x
Connections per second:  1.263 
Kilobytes received per second:  7.0682 
Kilobytes sent per second:  0.2541 
Queries per second:  37.827 
Percentage of slow queries:  0 
Opened vs. Open tables: (table_cache)  1575.375 (should be <= 80) 
Table cache usage: (table_cache)  1 (should be >= 0.5 and <= 0.9) 
Key buffer read hit rate: (key_buffer_size)  0.0209 (should be <= 0.01)  Key buffer write hit rate:
(key_buffer_size)  0.0204 (should be <= 0.5) 
Thread cache hit rate:
(thread_cache_size)  152.0918 (should be >= 30 ) 
Thread cache usage:
(thread_cache_size)  0.75 (should be >= 0.7 and <= 0.9) 
Temporary table disk usage:
(tmp_table_size)  0.2885 (should be <= 0.5) 
Sort merge pass rate:
(sort_buffer)  0 (should be <= 0.001) 
Query cache enabled:
(query_cache_type)  1 (should be >= 1 and <= 1) 
Query cache miss rate:
(query_cache_limit)  0.2202 (should be <= 0.5) 
Query cache prune rate:
(query_cache_size)  0.003 (should be <= 0.05) 


Obviously,  the highlighted values above seem to be WAY out of range. Suggestions? What's going on and how do I fix it?