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
24 freelanceria on tarjonnut keskimäärin 197$ tähän työhön
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, 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
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
Please ping me for discussion i will complete your [login to view URL] i think this problem is occur to joins use in [login to view URL] first of all i want to the problem and i will check the solution. Thanks
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.