OPTIMIZE MYSQL FOR LOW CPU USAGE AND HIGH PERFORMANCE

OPTIMIZE MYSQL FOR LOW CPU USAGE AND HIGH PERFORMANCE

An unoptimized mysql usualy takes high cpu and a heavy impact on performace.

To optimize the mysql for low cpu load best performance
edit etc/my.cnf

Code:

Code:

nano /etc/my.cnf

and put the following code:

Code:

Code:

[mysqld]
safe-show-database
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=25
max_connections=500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
innodb_file_per_table=1
log-error=/var/log/mysqld-error.log
log-slow-queries=/var/log/mysql-slow.log
long_query_time=1
[mysqld_safe]
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

save it.

Then restart mysql server

Code:

Code:

service mysql restart