| Author |
Message |
derekwhitten
Lifeless Person
Joined: 09 Jun 2005
Posts: 516
Location: Melbourne, Australia
|
 Posted: Mon Feb 12, 2007 9:10 pm Post subject: MySQL connection problems |
 |
|
I'm running an SMF forum on my account (cPanel login hphaven) which is hosted on Asgard.
This morning, at around 3:30 Feb 13 AEDT (GMT + 10) I got several emails generated by the forums with the following message:
| Quote: |
There has been a problem with the database!
MySQL reported:
Lost connection to MySQL server during query
This is a notice email to let you know that SMF could not connect to the database, contact your host if this continues. |
I have also received a few messages from forum members saying the page has been timing out when they post new messages.
I was just wondering if anyone else has been experiencing troubles, or if there's any known reason as to why the connection might be having difficulties?
Thanks for any help 
_________________
[img:02d40409b2]http://harrypotterhaven.l2p.net/images/banners/med.gif[/img:02d40409b2] |
|
| Back to top |
|
| |
Voldemort
Unhandled Exception
Joined: 27 Apr 2005
Posts: 948
Location: In a Galaxy far, far away
|
| Posted: Tue Feb 13, 2007 10:29 am Post subject: |
|
|
That might have happened due to a time the server has had a high load, and the mySQL server was too busy to respond. If it continues happening then there is a problem with the server or your forum installation. (Check to see if it has any tool for cleaning up the database or removing orphaned attachments, that might help I think. You may also disable features to reduce mySQL query count per page)
_________________
It's beginning to look a lot like Christmas
Everywhere you go;
Take a look in the five and ten glistening once again
With candy canes and silver lanes aglow..
(It's beginning to look a lot like Christmas) |
|
| Back to top |
|
| |
derekwhitten
Lifeless Person
Joined: 09 Jun 2005
Posts: 516
Location: Melbourne, Australia
|
| Posted: Wed Feb 14, 2007 2:38 am Post subject: |
|
|
Hmmm....I've set it up to optimise the tables every two days when there are less than 5 people online.
It's a Simple Machines forum, and I'm using database driven sessions. Not sure if that puts heavy load on the server - I'm looking into that now.
Thanks for your suggestions  I'll see how it goes
_________________
[img:02d40409b2]http://harrypotterhaven.l2p.net/images/banners/med.gif[/img:02d40409b2] |
|
| Back to top |
|
| |
|
|
|
Forum FAQs 
Knowledge Base 
Memberlist 
Usergroups 
Hosting
Register
Donate 
Profile 
Log in 
