| doozy |
02-09-2006 07:35 PM |
MySQL Problems
Hello everyone.
My site is running very slowly and my hosting provider responded with the following message.
Quote:
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:
Quote:
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
|
Quote:
Database error in vBulletin :
Link-ID == false, connect failed
mysql error:
mysql error number: 0
|
Any help would be greatly appreciative.
Thanks |
More Information