Need MySQL expert to find problem what is causing lots of slow queries

已关闭 已发布的 4 年前 货到付款
已关闭 货到付款

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

MySQL PHP Linux Nginx MariaDB

项目ID: #21879636

关于项目

22个方案 远程项目 活跃的4 年前

有22名威客正在参与此工作的竞标,均价$194/小时

vili1977

Hello. I would like to help you with tunning mysql settings. I have experience. Please read my feedbacks. Thank you.

$40USD 在1天里
(825条评论)
7.3
ShiaFirst

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.

$300 USD 在3天内
(131条评论)
7.1
AndrwProjects

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 更多

$120 USD 在8天内
(304条评论)
7.1
tangramua

Hi Sir, Your project is easy for our experts. We have a huge experience in PHP, Linux, MySQL, System Admin, Software Architecture, and Network Administration, so we can do this for you. Our team has valuable experie 更多

$250 USD 在7天内
(97条评论)
7.4
NayaPakistan

Hello there. I can review your website/database usage and let you know the cause and solution for this.

$200 USD 在3天内
(334条评论)
6.8
pdq

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

$30 USD 在3天内
(198条评论)
6.4
abusayed2004

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

$100 USD 在3天内
(58条评论)
6.4
manojmalviya93

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 更多

$277USD 在1天里
(60条评论)
5.8
webcodeater

i can solve this issue right now its not big issue it's just optimization of quer waiting for your reply thanks

$66USD 在1天里
(89条评论)
5.7
servermaster

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

$140 USD 在2天内
(27条评论)
5.8
eliaa

Hello, I have gone through your requirements and understand what you need. I am a Web developer with 7 years experience I have used a lot of technology to implement my clients solutions. List of Services that i can hel 更多

$200 USD 在5天内
(20条评论)
4.8
ancientb

Hello, im experienced in Linux System administration, including Server security and Optimization. Ill be able to take on the project and work on it, until we figure out the issue and provide a solution. There are many 更多

$250 USD 在7天内
(42条评论)
4.9
toshazed

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.

$150USD 在1天里
(8条评论)
3.5
AndreyBarykin

Hello. I have big experience as Senior Database Developer/DBA. Know well query optimization, performance tunning and troubleshooting. I can diagnose performance problems myself.

$110 USD 在3天内
(2条评论)
3.0
wolfman199311

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 更多

$140 USD 在7天内
(3条评论)
2.6
gordanbobic

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 更多

$30USD 在1天里
(5条评论)
2.5
bilal966

Hi, Here is Database expert. I have clearly understand your requirement. Now its my job to fix this. I can actively do this job as i have already worked on large scale eCommerce applications. If you allow me we can di 更多

$220 USD 在7天内
(2条评论)
2.2
Varaprasad9676

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 .

$50 USD 在7天内
(0条评论)
0.0
umeshdande

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.

$1000 USD 在7天内
(0条评论)
0.0