MySQL Problems

[doozy]

Hello everyone.

My site is running very slowly and my hosting provider responded with the following message.

Hello,

We have investigated that & it seems that your script is creating too many connection on mysql :
Please check the logs. This is causing to load your site slowly.


root@computersemidedicated [/home/dogpaw/public_html]# mysqladmin pr
+-----+---------------+-----------+---------------+---------+------+------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------------+-----------+---------------+---------+------+------------------+------------------+
| 59 | nybgroup | localhost | | Connect | 321 | Reading from net | |
| 66 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 110 | | |
| 67 | nybgroup | localhost | nybgroup_base | Sleep | 294 | | |
| 69 | nybgroup | localhost | nybgroup_base | Sleep | 293 | | |
| 75 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 84 | | |
| 83 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 188 | | |
| 84 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 186 | | |
| 88 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 161 | | |
| 89 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 145 | | |
| 91 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 142 | | |
| 92 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 140 | | |
| 93 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 128 | | |
| 94 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 125 | | |
| 95 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 114 | | |

Unfortunatly I don't know how to go about fixing this. My hosting provider has said they have restarted MySQL and that the site is fine. I had asked them to increase the max connection (which is currently set at 500) but they skirted the request. I also have my config.php file set to "0" for PERSISTENT CONNECTIONS.

I am getting the following errors sent to me by email:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT value AS logtime FROM statistic_setting WHERE setting_for = 'logtime'
mysql error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

mysql error number: 2002

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Any help would be greatly appreciative.

Thanks

[Xenon]

change persistent connections to 1