I have a web site that uses MySQL database extensively. (While someone is browsing the site, I or some other people are editting the data in the database, so that the users can get most up-to-date information)
Recently, we've gotten mysql connection error. While the site cannot make a connection to the database, the site is totally down until the connection opens.
I thought this was caused by the setting of the hosting company, so we requested to investigate what's causing this error.
They came back with this result.
Is their a reason why you are caching/locking your database connections
instead of closing them?
It seems that these locked connections are using up a great deal of CPU
and causing either too many connection error messages or causing Mysql to
fail due to server resource consumption.
OK. But I don't lock our database connection at all! We close them everytime we connect to the database.
But never LOCK connection.
I read Mannual and understand that INNO DB is the only table type that you can lock and unlock the database.
All of my tables are MyISAM types.
I don't know if it helps in order for you to give me an advise, the version of the MySQL database is MySQL 4.0.15. on the dedicated server.
Does anybody give me some advise? I really need your help!!!
