Optimizing mysqld for high traffic site

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 Can I check the website please? Which pages and queries are slowing down the process? I may be able to help you on this. Thanks

Hi I can help you SSH root access is requied ********************************************************************************

Is it custom site or frameworked site ? Can i get the URL ? Is it on shared server od dedicated. For now i have more questions than answers.

Hi, can you provide more details? .

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.