Завершено

Fix MySQL Huge CPU Usage resulting in queries taking 20x as long as they should

I am using a MySQL database with around 300-500 connections at the same time.

I am hosting this on a Ubuntu 18.04, 8 GB Dedicated RAM, 4 CPU, 140GB SSD server.

My database is not huge but I am running into issues and would like to consult with an database (mysql) expert to help me fix the problem, or understand if I need to upgrade the server resources.

Квалификация: MySQL, Управление базами данных, Программирование баз данных

Показать больше mysql cpu usage, mysql cpu usage tuning, optimizing mysql cpu usage, php mysql cpu usage, mysql apache memory cpu usage, mysql reduce cpu usage linux, number mysql databases cpu usage, linux mysql 100 cpu usage, mysql lower cpu usage, mysql high cpu usage windows, wp mysql high cpu usage, mysql high cpu usage centos, mysql reduce cpu usage, mysql high cpu usage innodb, mysql high cpu usage no queries, mysql high cpu usage, wordpress mysql high cpu usage, mysql high cpu usage ubuntu

О работодателе:
( 30 отзыв(-а, -ов) ) CAMBRIDGE, United Kingdom

ID проекта: #23519433

Поручен:

rflurey

Hi, I am a multi database specialist but mostly specialising in MySQL in both on premise and in cloud. My first job on Freelancer was building a MySQL cluster with performance monitoring and the client was very happy Больше

£61 GBP за 1 день
(3 отзывов(-а))
3.2

17 фрилансеров(-а) в среднем готовы выполнить эту работу за £147

AndrwProjects

Hi. Ok do you have certain strong question which can be reproduce and seen? Or you just want general speed up.. are you did exact measurements?

£150 GBP за 8 дней(-я)
(210 отзывов(-а))
6.7
wmtoolsnet

Hello. I'm professional Linux admin, and can reduce CPU usage by MySQL. Please contact me, and let's start. Thanks!

£100 GBP за 1 день
(215 отзывов(-а))
6.8
digitalfog

Hey. I know the whole family of *SQL. I worked with high-load projects, so I know where to look for "bottlenecks" to your database or queries. I will try to help solve your problem quickly. Good luck.

£77 GBP за 1 день
(22 отзывов(-а))
5.0
servermaster

Hello I can troubleshoot. IT could be that MySQL needs more memory. I can fine tune this. Other thing could be that database needs optimizations. I can analyze and point out mysql queries what are slow. I am professio Больше

£171 GBP за 3 дней(-я)
(9 отзывов(-а))
4.9
RyuMaster

Hello, dear. I understand what do you need. I have already experienced problem like that, and resolved that. I can help with that and can start right away! I 'd like discuss with you via chatting. I will wait. Thank yo Больше

£100 GBP за 1 день
(5 отзывов(-а))
4.8
mohammedhdotio

Hello, it could be bad database design for your tables, keys, etc.. I need to investigate slow_log of your mysql database server to understand which query is dragging server to it knees and offer a solution if possibl Больше

£135 GBP за 1 день
(11 отзывов(-а))
4.2
Programmer59

Hello Sir/Madam, I can start right now I am professional MySQL developer with having more than 5 year's experience in this field. I read your project description and I am interested in it I need some more information r Больше

£150 GBP за 3 дней(-я)
(8 отзывов(-а))
4.3
artsun1990

Hi, Nice to meet you! I have been working for 10 years working as Web Developer and Designer. In these times , I have a lot of experiences in Javascript , HTML5, PHP ,Node.js and Angular.js ,Laravel, Symfony, CI, React Больше

£200 GBP за 7 дней(-я)
(1 отзыв)
2.0
xiaoxishan1990

Hi! I am a Ubuntu expert and have 7 years of experience with MySQL and MSSQL. I have read project detail carefully, So I know how to complete your project, and can get this developed for you quickly! If you hire me, I Больше

£50 GBP за 1 день
(1 отзыв)
1.4
karpvasily930314

Hello. I am a expert in MySQL with full experiences for 6+ years. I can handle your requirements using MySQL application. If you hire me, I can finish it as you want. I am always ready to work for you and can I start Больше

£135 GBP за 1 день
(2 отзывов(-а))
1.3
nikhilgarg96

Hello Sir, Hope you are doing well. I have analyzed your job requirements for a MySQL developer and I know I am the best. I am an interactive developer with over 6 years commercial expertise of delivering high quali Больше

£250 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
niceworker7

Hi Sir I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. Don't worry about your problem. I have a lot of experience of administration & fixing troubles in Больше

£150 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
eblive

Hi, Can you provide the queries in question and access to a replica of the database? Do you currently have indexing on the tables? If you can provide the scripts that are calling the queries those would likely be opt Больше

£277 GBP за 20 дней(-я)
(0 отзывов(-а))
0.0
patilmadhav

Ready to take the issue with complete [login to view URL] you fine with everything. Please contact my personal what's app number +919008019158 Relevant Skills and Experience Please contact my personal what's app number +919008019 Больше

£166 GBP за 3 дней(-я)
(0 отзывов(-а))
0.0
vw1758978vw

Hi There, I am a developer having more than 10yrs of experience in making heavy load websites and fine tuning mysql server. Slow query can be result of multiple issues and it can be at server/hardware or software level Больше

£135 GBP за 3 дней(-я)
(0 отзывов(-а))
0.0
codfy

hi! I don0t think you need to upgrade your server, or at least to be sure we must look @ MySQL logs. Of course, we need also to look @ memory and heap settings of your MySQL installation. I just need ssh credentials f Больше

£200 GBP за 5 дней(-я)
(0 отзывов(-а))
0.0