Posted on: 2004/12/15 6:25
Re: Error [Xoops]: Unable to connect to database in file class/database/databasefactory.php line 34
I am not sure but there is something more into it, which generate this errors. I posted a similar topics before What is there in line 34 of databasefactory.php ?
. Our website is hosted with RackSpace server and system admin reported me that it happened due to some MySQL query which is not working properly in some cases. I hope this will be fine, if i put a excerpt from his comment for better understanding:
"Now I think we've known ever since we moved this site to the new server that there is a big problem with server load - and that the load problem is caused by MySql - RackSpace told us that very early on.
This server has recorded the highest load I have ever seen -over 200 one minute load average - and has a history of becoming unresponsive and requiring a reboot - all due to MySql problems. When I entered the data from the other server it took over 5 hours to read the data file into MySql - and this is only a 750MB database which is NOT that large and should NOT be this kind of problem. I've looked at some of the queries that are running and they are neither outrageous nor are there so many to explain the kind of problems we are seeing. But problems with the database design and missing or invalid indexes ARE enough to cause the problems we've been seeing.
I know the site has been undergoing a redesign, and until you tell me this is done I won't be logging in or doing any work on it. I don't know if part of that redesign has been a redesign of the database table structure - but if not, then this is sorely needed - this server will not stay running until this is fixed."