how to optimization my.cnf

[Motamedi]

hello

Please provide a brief Lessons , Both me and others understand
Other education did not understand anything
Tell us for a server with 8 GB of RAM and 8 Core CPU and CentOs 6.5
How do I set the CPU the RAM cache ?

Now I am using this my.cnf

client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 784M
max_allowed_packet = 10M
table_open_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 16M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
table_open_cache = 400
tmp_table_size = 24M
max_heap_table_size = 24M
table_definition_cache = 400
table_open_cache = 400
max_allowed_packet=32M


open_files_limit=900000
[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash


[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

But MySQL to 130% of the CPU usage
And 100% of CPU usage and hang server
Please tell me how I set full all amounts

thanks ...

 

[24x7server]

Hello ,

Have you tried mysql mysqltuner (MySQLTuner-perl by major) script on your server ? Please give a try with mysqltuner and monitor your mysql server performance

 

[cPanelMichael]

Hello

The following thread is a good place to start when attempting to modify your MySQL configuration values:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.