Đ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 thêm: mysql cpu, mysql cpu optimization, cpu load mysql fix, mysql locked cpu, mysql cpu load optimize, mysql cpu load, types data structures, problem structures, problems data structures, problem fixing, new data structures, fixing problems, fixing problem, fixing my, find problems, data structures types, data structures problems, data structures example, mysql cpu load problem, optimize mysql, mysql index, fixing, table optimization, project monitor system, lot average

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

Mã Dự Án: #1732062

Đã trao cho:

vili1977

I can help you.

$50 USD trong 2 ngày
(52 Đánh Giá)
5.0

8 freelancer đang chào giá trung bình $121 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
(77 Đánh Giá)
6.3
triamazikamno

Professional server optimizer with 14 years *nix experience.

$200 USD trong 4 ngày
(55 Đánh Giá)
6.3
hamidnk

check my reviews and message to evaluate me

$40 USD trong 1 ngày
(28 Đánh Giá)
4.7
nhamza1988

Please see PMB.

$80 USD trong 2 ngày
(3 Đánh Giá)
3.2
phpking007

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

$50 USD trong 2 ngày
(5 Đánh Giá)
2.4
KimeraDevelop

Hello, we are available to help you

$199 USD trong 3 ngày
(1 Đánh Giá)
1.0
m4riusz

Dear Sir, I can fix this problem. Regards, Mariusz.

$100 USD trong 3 ngày
(0 Đánh Giá)
0.0