Đang Thực Hiện

MySQL Optimization, Fixing High CPU Load Problems

My server has high CPU load due to MySQL processes. I need this fixed. I will need someone to:

--monitor mysql processes or check mysql logs to see what kind of queries are being made. Find bad queries and make them better.

--go through the table structures and indexes and optimize them as well (such as column data types, index types, etc).

--check mysql settings to make sure they are at optimal settings.

--check possible server problems that could cause the problem

The problem in more detail: 1 minute load average stays around 4 (there are 4 cores on the server), and 15 minute average varies a lot, but is generally around 15. Sometimes the 1 minute average jumps to 30 or more. Looking at the mysql processlist, sometimes it looks normal, with little to no mysql queries, then all of a sudden there could be a hundred as the tables are locked up. It is not an issue with persistent connections. All of a sudden there are too many connections and mysql needs to restart.

Fixing the problem may also need some monitoring. For example, in the past before I got my new server, this problem would only happen in the morning (I checked all crons, they were not the problem). Now it seems more often. Not sure what happened since then.

Just as a note for everyone: this project's main goal is not to simply optimize mysql. It is to fix this problem so that my server runs smoothly without any mysql downtime.

Kĩ năng: Quản trị cơ sở dữ liệu, Linux, MySQL, Quản trị hệ thống

Xem nhiều hơn: mysql cpu, mysql cpu optimization, cpu load mysql fix, mysql locked cpu, mysql cpu load optimize, mysql cpu load, what is data structures in c, what is data structures, what is a data structures, what are data structures in c, what are data structures, types of data structures in c, types of data structures, types data structures, problem structures, problems that need fixing, problems in data structures, problem fixing, new data structures, fixing problems, fixing problem, fixing my, find problems, data structures types, data structures through c

Về Bên Thuê:
( 5 nhận xét ) Rome, United States

ID dự án: #1732062

Được trao cho:

vili1977

I can help you.

$50 USD trong 2 ngày
(474 Đánh Giá)
6.8

7 freelancer đang chào giá trung bình $124 cho công việc này

shakoush2001

Hi I am a CISSP,RHCE,VCP,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I Thêm

$250 USD trong 4 ngày
(81 Nhận xét)
6.6
triamazikamno

Professional server optimizer with 14 years *nix experience.

$200 USD trong 4 ngày
(60 Nhận xét)
6.3
hamidnk

check my reviews and message to evaluate me

$40 USD trong 1 ngày
(65 Nhận xét)
5.4
nhamza1988

Please see PMB.

$80 USD trong 2 ngày
(52 Nhận xét)
4.8
phpking007

Your CPU Load Will Be In Control Surely. Check PM.

$50 USD trong 2 ngày
(5 Nhận xét)
2.4
KimeraDevelop

Hello, we are available to help you

$199 USD trong 3 ngày
(1 Nhận xét)
1.0