Need MySQL expert to find problem what is causing lots of slow queries
$30-250 USD
货到付款
Hello,
I have a high traffic website running piwigo and lately the database (MariaDB) is unstable. Doing several tasks such as: deleting images in admin panel, placing comment on frontend,.. will cause huge loads on the server (800% CPU, 50-200 loads).
I assume there is something wrong with the database it self. Maybe it's too old? Maybe it's too big? I'm not sure.
I need an MariaDB/MySQL expert to help me figure out the problem.
PS. The website is adult
项目ID: #21879636
关于项目
有22名威客正在参与此工作的竞标,均价$194/小时
Hello. I would like to help you with tunning mysql settings. I have experience. Please read my feedbacks. Thank you.
I have worked on couple of such projects before. Let me know if you are interested. Regarding your project I got couple of questions to clear before we proceed further.
Hi. I may look into this, i have prior experience and may locate problem and fix as possible. I need at first find bottlenecks in system and then propose solution. And yes MariaDb CPU high load involved if db not optim 更多
Hello there. I can review your website/database usage and let you know the cause and solution for this.
Hello, i'm a senior linux administrator and i work in a hosting company. I'm ready to discuss your issue with DB if you will specify your piwigo version + your server stack
I can do it, I have 9 years of Linux, VoIP, Python, PHP, MySQL experience and I am a RedHat certified specialist, I am sure I can do it thanks
Hi, As per your requirement, I have expertise in mysql configuration and its optimization. I can help you with that. I have 10 years of experience in this domain and I have done this type of projects many times for m 更多
i can solve this issue right now its not big issue it's just optimization of quer waiting for your reply thanks
Hello I have mysql and webapps experience with more then 20 years. I can troublshoot mysql and find out what causes huge CPU load plus fix it. greetings, taavi
I am Ring. I am about 18+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.
Hello. I have big experience as Senior Database Developer/DBA. Know well query optimization, performance tunning and troubleshooting. I can diagnose performance problems myself.
Dear Client! Thanks for your job posting. I'm a senior web developer with over 5 years of experience and very strong in this Mysql. I can complete your job within a few days. please contact me so that we can discuss 更多
I have 20 years of experience with MySQL and two certifications. I have delivered performance improvements of up to 100,000x to customers. As part of the work proposed here, I will assess and fix for you the single bi 更多
i am working on my sql from past one year .so i think i can handle this . current i am workin as a free lancer .
I am having more than 15-year of experience working in all kinds of databases. I am expert in query tuning. Lets talk about the issues you are facing.