Færdiggjort

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.

Evner: MySQL, Database Administration, Programmering af database

Se mere: 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

Om arbejdsgiveren:
( 30 bedømmelser ) CAMBRIDGE, United Kingdom

Projekt ID: #23519433

Tildelt til:

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 Flere

£61 GBP på 1 dag
(3 bedømmelser)
3.2

17 freelancere byder i gennemsnit £147 på dette job

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 in 8 dage
(210 bedømmelser)
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 på 1 dag
(215 bedømmelser)
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 på 1 dag
(22 bedømmelser)
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 Flere

£171 GBP in 3 dage
(9 bedømmelser)
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 Flere

£100 GBP på 1 dag
(5 bedømmelser)
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 Flere

£135 GBP på 1 dag
(11 bedømmelser)
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 Flere

£150 GBP in 3 dage
(8 bedømmelser)
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 Flere

£200 GBP in 7 dage
(1 bedømmelse)
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 Flere

£50 GBP på 1 dag
(1 bedømmelse)
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 Flere

£135 GBP på 1 dag
(2 bedømmelser)
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 Flere

£250 GBP in 7 dage
(0 bedømmelser)
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 Flere

£150 GBP in 7 dage
(0 bedømmelser)
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 Flere

£277 GBP in 20 dage
(0 bedømmelser)
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 Flere

£166 GBP in 3 dage
(0 bedømmelser)
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 Flere

£135 GBP in 3 dage
(0 bedømmelser)
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 Flere

£200 GBP in 5 dage
(0 bedømmelser)
0.0