Apache Friends Support Forum

Hello, been having this problem for a few days now.

As of late, I started up the SQL service. Could connect to DB's fine and dandy. Then (here's the random part), within a 5 minutes - 3 hours time-frame. It will suddenly, stop. No reason...I've tried it on a different port. (3336) to see if it was a port collision error. It still randomly shut down on the new port.

I then got to thinking it could be just overflowing...it is being sent around

I would of checked in the mySQL logs...but I haven't a clue where that is...

Also is there a way to increase the amount of queries an such a second? I checked in the many config files and it mentions "These are the standard settings for a small server".
What I require is something a little more demanding than 1 query a second...

I've come to the conclusion the SQL must be overflowing. Since I've left it on, with nothing connected to it, over night and it didn't randomly shut down, until I started up the program that needs the SQL database, in which the SQL shutdown 30 minutes later.

Never had this problem until last week. But I have put a greater strain on the SQL since then...

Xampp: 1.7.7

Would you be so kind as to add your Windows version to your profile please as just Windows tells us nothing:
viewtopic.php?f=16&t=48626
Thanks.

The log files are in \xampp\mysql\data folder and some template type ini files are in \xampp\mysql which you can read with a view to adjusting the my.ini file in the \xampp\mysql\bin folder - do not use those sample ini files but rather use them to give you some ideas that may help your problem and always make a back up of any configuration files you may edit so you have a point you can revert to.

Also another place to look that may have a clue is in the Windows Event viewer under Applications.

Good luck.

OS: Windows Server 2008 R2 Standard

Just tried the "large" ini config.

Just this second stopped again.

Log: (Using the default me.ini)

www.pastebin.com/6WusderF


EDIT: It's not being overtaxed. Just found out. It randomly crashed 15 minutes after using the large template. And it was only receiving 3 queries a second.

Open \xampp\php\php.ini file in your text editor and find this line and change from 60 to this

Code: Select all

max_input_time = 300

and this line change it also to read

Code: Select all

max_execution_time = 300

Save the file and restart Apache and MySQL and try again.

Let me know if it helps.

I shall do that. But wont be able to get a result until tomorrow.

I left the forum support a little to late in the day. It's 2am and I don't want to wait around 5mins - 3 hours to see if it shuts down. I shall test it out tomorrow.

Thank you for the support.

Also these may be worth a read:
Google Search Results
as it seems you are not alone with this tussle between MySQL and Server 2k8 but the solutions seem yet to be positively found.

If the above fails to help then perhaps save your own data and remove this XAMPP installation and try again using a different method - zip or 7zip for example as per these instructions:
viewtopic.php?p=179699#p179699

Don't forget to add your correct Operating System to your profile as it is important.

Sleep well and my best wishes.

Still having the problems.

Even ramped it up to 600 on both of them.

Then tried -1. Still getting error code 6.

Tried WAMP...getting the same errors on that program to...I'm guessing it's a OS problem.

There was a possible fix in this thread for a similar stopping issue with Apache that may help:
viewtopic.php?f=16&t=50090#p193124

Good luck.

Error code 6 in this case (from looking at your log file) is related to invalid file handles which is quite strange. Is this an isolated issue (just mysql) or have you noticed similar problems with other programs? Are there any similar errors in your Windows Event viewer (Start > Run > eventvwr > Windows Logs > Application)?