Need MySQL expert to find problem what is causing lots of slow queries
$30-250 USD
Pagato alla consegna
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
Rif. progetto: #21879636
Info sul progetto
21 freelance hanno fatto un'offerta media di $198 per questo lavoro
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.
Hello there. I can review your website/database usage and let you know the cause and solution for this.
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 Altro
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
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
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 Altro
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
i can solve this issue right now its not big issue it's just optimization of quer waiting for your reply thanks
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 Altro
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.
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 Altro
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.