Hello, my site receive huge traffic regularly and I'm facing with issue that CPU is always overloaded. Because of that website always lags and loads slowly. I'm looking for a man, who would be able to find the CPU overload in mysql problem.
Hello,
I'm linux system engineer with more than 8 years of production experience with high-loaded web applications. I can help you fast and quality.
Regards,
Tony
Hi, would you like tell me what's the result which you run this code (SHOW FULL PROCESSLIST) into your mysql command or in your phpmyadmin?
Let me know if you want me to fix your issue of your database server.
Thanks,
Suwandy
Hello,
I have total 10 years experience with MySQL administration.
I think that your main problem would be the wait timeout or long query execution time of mysql.
If you agree, please give me the chance to look inside your mysql database.
Thanks.
Best Regards.
Hi,
I can help you with the performance analysis and optimization as I have 13+ years experience specifically in database development.
high probability for the high CPU utilization is due to correct indices not existing for the queries getting executed and hence queries are using more of table scans than index fetches.
the quote shared is with the assumption of 4 person-hours of effort but the actual billing would be based only on the amount of effort spent on your project on pro-rata basis.
can we get secured shell access to your instance?
do you have list of queries getting executed or do we need find it from the system?
please note that though I donot have any reviews I have been doing freelancing directly for an european based large business/people directory service portal as database consultant for the last 3 years. I also have overall 20+ years of IT industry experience.
hope to hear from you
regards
Babu
HI I am system admin and expert in web server for high traffic currently I am handling high traffic web server and using nginx Apache with MySQL and working fine. I have 7 Years exp. in MySQL administration I will Optimize your MySQL server so please let me start on it.