how to optimization my.cnf

[mamadletsgo]

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 ...

 

[Wanabo]

I suggest you use http://mysqltuner.com/.
Follow the recommendations given by that program.

 

[Richard G]

I wouldn't do that if you don't know what you are doing.
Some time ago I used some mysqltuner suggestions which gave a bunch of errors because one of the settings caused problems on my server.
So I should have a good look what it advises and what the change does.