Fermé

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

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

Compétences : MySQL, PHP, Linux, Nginx, MariaDB

en voir plus : odbc mysql time problem issue, mssql find slow queries, need seo expert website, php mysql expert, need jamroom expert, php mysql ajax problem slow, optimize mysql slow queries, mysql slow queries optimalization, mysql count slow slow query slow queries, fix mysql slow queries drupal, need mysql expert use trigger, vtiger email problem need fixed expert needed, joomla slow queries mysql, need mysql expert, zencart mysql slow queries, need drupal expert fix webform problem, mysql slow queries

Concernant l'employeur :
( 76 commentaires ) Kyoto, Japan

Nº du projet : #21879636

24 freelance font une offre moyenne de $197 pour ce travail

vili1977

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(736 Commentaires)
7.3
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(295 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(63 Commentaires)
7.2
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(116 Commentaires)
7.0
NayaPakistan

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(285 Commentaires)
6.7
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(58 Commentaires)
6.5
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(161 Commentaires)
6.2
webcodeater

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(83 Commentaires)
5.7
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(50 Commentaires)
6.0
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(53 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(17 Commentaires)
5.4
maximivan99

Dear sir. I am a full-stack web developer with 4+ years of experience. I've read your job description and fully understood the main point what you mentioned. It would be great if you share your job in more details. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(42 Commentaires)
4.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(9 Commentaires)
3.8
gurpreet0173

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.5
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.3
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
2.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.2
WelcomeAndroid

hi I am expert in DB management. To reduce the server usage related to db,there are many option. SQL stored precedure,simple query ,weeb traffic probloem... if you can hire me,I will make the website best, I deliver wo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0