how to optimization my.cnf
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 ...
]http://ft.trillian.im/3a38c1b4d3162d7ca1e69c52a7cec8e0082ec605/6GVR0SoqA2nuVzhxpwO6mhIeIhlLg.jpg
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 ...
-
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 0 -
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. 0
Please sign in to leave a comment.
Comments
2 comments