One of my sites on my dedicated Server is suddenly causing a very high sql load making it unreachable.
It is php driven message Board. (Simple machines)
I need someone to analyze the Problem and fix it.
Likely some bad php code or sql querries need to be fixed / optimized
Hi
I think I can help you.
I have many experiences at sql optimization.
I guess you have a(or more) resource consuming and long time sql query which locks your table.
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
Dear sir, I will complete your project asap, LIFETIME error free guarantee and provide ONE YEAR support... I have right Skills required MySQL, PHP, SQL to execute your esteemed project.
100% Top Satisfaction Guaranteed On Project, 7 years experienced on Website Design, HTML/CSS Mobile Responsive, PHP Programs, Invite me to chat discuss further to start project
There seem to be some Bad sql querries or php querries overloading sql on the Server. When i restart ithe server, the Site works but soon sqlload will go to 700% causing it to Crash. Do you think you can fix this?
Hello. Now your site shows:
502 Bad Gateway
Checking your internet connectivity... [OK]
Checking r00tProxy network............ [OK]
Checking backend server............... [ERROR]
If you are the owner of this website please contact your hosting provider, because your server is most likely down.
So perhaps problem is not only in MySQL. What a kind of hosting do you use? Is it VPS or just virtual host? Do you have root access for your server?
Hi.
My name is Viktor.
I'm a developer with 8 years of experience. I have done a lot of different PHP and .NET projects. Among them I had few projects where I were solving same problem you have. So, I think I can help you with your issue.
I can look at it at any moment.
Bid updated as right now I need feedback here more than money)
With regards
Viktor
Hi, I've over viewed the details of the project provided by you and I am please to declare myself the right candidate for this project as I've completed many successful projects of such kind in which client's website response time is increased upto 70 - 80 times then it before. (urls will be provided on request). If you are looking for quality results in reasonable time and rate then lets discuss the further details for successful completion of project. Thanks
I have had similar issues in the past with one of my sites. It is a HUGE VBulletin site I have run since 2000.
One thing you may want to look at is your disk space. Sounds odd but I have seen that cause this same issue.
I'd be happy to take a look and I'm certain I can find and fix your problem.