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
The contents of
[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.