I have a client on mysql3 that for the last week has been getting timeout issues on multiple domains and multiple applications. (Joomla, WordPress, and some forum)
They said it has been happening for about a week and today I witnessed it several times myself. Some apps actually spit out the error that php shows and another displays a more friendly error, but it all leads to the database and it timing out. I have verified that the Joomla and Wordpress have been both installed properly and currently there is very little data so they should not be experiencing any sort of timeouts or issues.
OK. Have you reported this issue to us via a ticket? Please do so mentioning URLs and database names so we can investigate. Our monitoring system has not shown any issues with MySQL3, so customer reports are essential for us to diagnose such issues…
I have left 7 followup replies to this ticket after the last post from Jodo on Oct 9th 12:19PM.
My client is starting to get irritated with these intermittant timeout errors. Examine the ticket for details… but it may not be a timeout for mySQL as much as maybe it is the PHP.
I am using mysql3 from a wordpress install (on a windows server) and have not seen any errors. I have used it extensively in the last 24 hours setting it up. I will point a unix tech here to see if it may be php.
I am not sure why wordpress would take longer than 30 seconds to execute, as my install is on the same servers with no issue, the longest load I have seen has been about 3 seconds.
however I increased the time, as it has a custom php.ini
Do you know what is being posted? Image upload possibly?
On occasion there are images, but they are usually properly downsized.
This is not just happening with wordpress. She was getting it in joomla and smf (forums).
She is still sending me error information and I will update the ticket OR here as I get more information. When it happens it usually happens several times in an hour.
She is getting quite frustrated since it is obviously happening on multiple domains and multiple applications.
Here is what I said in the ticket post… increasing the time may result in getting rid of the symptom, but I am more concerned about the problem itself. WHY is it taking 30 + seconds and then failing (on multiple domains and multiple apps). The primary common piece between them is the web server and the mysql server.
The other URL’s are www.sleepyblogger.com , www.duzins.com , www.problogwriter.com . They have gotten this error at various points… just reading the as well as when posting to the site. So it doesn’t seem to be tied to just posting.
Here is a another specific error:
Fatal error: Maximum execution time of 30 seconds exceeded in D:\hshome\xxxxxx\problogwriters.com\mambots\content\mosimage.php on line 15
Those are al the same account and same server, but as I said I also have a wordpress site on this server that is using mysql3 backend and not showing any issue at all.
That error has to be old, as that is not the php values anymore. I have also increased the memory limit a bit for php which may allow the execution to continue if ti is using large amounts of RAM.
My wordpress is pretty base with just 3 themes and 2 plugins installed.
I was just pulling the errors out that we had when I first posted (before the changes). They said they had 4 more times last night. 2 times on one blog and 2 times on joomla. She didn’t give the exact error other than it was a timeout. I have requested that she send the EXACT error EVERYTIME.
She also changed from using the mysql host name to IP address per Deepak’s request.
What exactly has changed on your end since my original ticket post?
I just modified the first one, at first, then the system wide, I dont have in front of me now the exact parameter but it is
Mem_limit=8MB I changed to 16MB and uplaod from 2 to 16MB, also time from 30 to 90
They got a different error today. She was emailed this from this system. This is the only detail she got:
Just fwding it to let you know I got this. Means someone was accessing the forums and it hiccupped. No idea on time involved as it wasn’t me that experienced the error. There was no error in the MySQL reported part when I received it, this is exactly how it looks on my end.
This is the first time she has gotten this, but it is indicative of some sort of problem going on. Like I said… multiple domains, multiple php applications, same server, same mySQL server.