Does disabling error logging for MySQL increase its performance? How can I disable it?
Here is my server's load:
Server load 0.63 (8 CPUs)
Memory Used 23.38% (957,600 of 4,096,000)
Swap Used 0% (0 of 1)
And here is a screenshot of the process manager
http://elnhrda.com/promgr.jpg
The contents of my.cnf
:
[mysqld]
query_cache_size=64M
skip-name-resolve
#innodb_file_per_table=1
query_cache_limit=2M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 8
thread_concurrency = 8
innodb_buffer_pool_size = 2G
I am looking for any suggestion that could increase my website's speed.
I have VPS, 4GB RAM, CENTOS 6, X86_64.
Please note: these statistics were calculated now with no queries executed, and the site had no visitors in the same time.