Sign In
11
Your problems were due to coding issues and missing files and had nothing to do with our MySQL settings on that server. The attached text file will show this. MySQL was dropping your connections simply because, your custom scripts could not process the information within the allotted time which is more than adequate for any well written PHP script.
Just for your information; Our wait_timeout value on that machine is 20, not 10 as you have wrongly posted above in your complaint. This has proven to be more than adequate for every other client on that server.
Increasing that value higher than needed will do nothing more than create bottlenecks and greatly slow MySQL performance because of the higher number of stale or dead processes that would be remaining longer. That could also allow a poorly coded script 'such as the one you were attempting to run', to consume much higher than necessary resources for extended or indefinite periods of time.
My partner David was trying very hard to accommodate you with these non standard requests however, you became very impatient and even rude in your replies and demands when he didn't fully understand what you needed. In his defense; He does fully understand the various e-commerce platforms that we host but, since he is not a developer, he didn't have all the answers that you needed within your short demands. He did then bring this to my attention and asked if I could look into helping you with that broken script (bnfusa.php). I was in the process of checking our error logs and that script when you started insisting that this was due to our MySQL settings. I then started reviewing your ticket communications and noticed how impatient you were with your expectations and decided then that I didn't want anything to do with you. I told David to refund your money and send you on your way because, if you are going to act like that when receiving free additional help, what would you be like if there really was a problem?
A couple things about that custom script you are trying to run.
The first 2 lines of code it contains will tell every host that you are going to be trouble.
ini_set("memory_limit", "400M");
set_time_limit(0);
You will find no host willing to allow any single script to consume 400MB of memory and, trying to completely disable the timeout function as well in line 2 means that, this script could crash a server if not very carefully coded. If an infinite loop were present in a script with these variables, it could easily bring down a server if allowed to run for any length of time. You may want to investigate if this is why the VPS you are moving from is so awful slow.
Good luck to you in your search for hosting. I'm very sorry that we were not able to accommodate you and that it has come to this.
Attached Files
-
teksigns.txt 19.37KB
275 downloads
