Issue about how to optimization my.cnf

[scarlett]

Hello everyone,

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 ,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!

 

[pravinganore]

Did you try mysql mysqltuner (MySQLTuner-perl by major) script on your server? Give a try and monitor your server performance.

 

[scarlett]

Thanks a lot for your advice!