How to determine if all CPU resources are fully utilized?
Hello guys,
First of all, I'd like to say that I am new to Linux and MySQL. I am actually a SQL Server DBA. However, there is a MySQL in our environment to I would like to help my team mates to solve the problem with it.
MySQL Ver:
protocol_version: 10
version: 5.1.67
version_comment: Source distribution
version_compile_machine:x86_64
version_compile_os: redhat-linux-gnu
The problem is that, we are monitoring this server using New Relic. In New Relic, it seems that only a specific portion (%50) of the CPU resources (2 Sockets, totally 4 Cores) is being used and it is mysqld which utilizes the resource. When I open a console and run TOP or HTOP, I see that 200% CPU is being used. In HTOP I observe that all cores are utilized.
New Relic says even in the busiest time period only 50% of the CPU resources are utilized and when I monitor using HTOP all cores are used somehow.
What am I supposed to do to verify if there are some wrong parameters in my "my.cnf" file? Below, I am sharing the file contents with you.
P.S. I wrote this question under INNODb category as our database engine is INNODb. Please redirect me to the right category if I am at the wrong place.
my.cnf file:
--------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
default-storage-engine = innodb
server_id = 1
symbolic-links=0
max_connections = 900
log-bin=binlog
expire-logs-days=5
sync_binlog = 1
thread_cache_size = 50
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 1
innodb_thread_concurrency = 0
query_cache_size = 0
query_cache_type = 0
table_open_cache = 2048
table_definition_cache = 1024
innodb_buffer_pool_size = 20G
innodb_log_file_size=2047M
read_rnd_buffer_size=5M
innodb_log_buffer_size=8M
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1
Thank you,
Ekrem
Edited 1 time(s). Last edit at 07/19/2013 05:05AM by Ekrem Onsoy.
Subject
Views
Written By
Posted
How to determine if all CPU resources are fully utilized?
1704
July 19, 2013 05:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.