Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

Error logging should not have significant impact on your MySQL performance, as there shouldn't be many of them. If you've got enough errors for logging to impact performance, the solution is to fix the errors, not ignore them.

You have relatively low CPU load and low memory usage. Do some benchmarking to find out what's making your site slow instead of selecting possible optimizations at random.

share|improve this answer
    
Does 23.38% is low when no any visitors or any operations on the databse? –  adnan Nov 10 '13 at 14:56
1  
MySQL will attempt to load as much into cache as it can, in order to speed up queries. A MySQL database with zero queries should still be taking up a lot of RAM if it's properly configured. –  ceejayoz Nov 10 '13 at 14:58
    
Well, Could you please suggest any ideas to improve MySQL performance? –  adnan Nov 10 '13 at 15:02
    
Have you benchmarked it to confirm that MySQL performance is your problem? Have you done EXPLAIN queries to evaluate your queries? Do you have MySQL's slow query log enabled to find which ones to optimize? –  ceejayoz Nov 10 '13 at 15:18
1  
That's one insertion every 30 seconds or so - hardly significant load if it's coded well. You're going to have to do some digging. Don't "think", know. Enabling the slow query log is easy and very useful. –  ceejayoz Nov 10 '13 at 15:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.