Does disable log error for MySQL increasing it's performance ? How disable it?

Posted by adnan on Server Fault See other posts from Server Fault or by adnan
Published on 2013-11-10T14:33:13Z Indexed on 2013/11/10 15:58 UTC
Read the original article Hit count: 311

Filed under:

mysql

|

error-logging

Does disable log error for MySQL increasing it's performance ? How disable it ?

This is my service status

Server load     0.63 (8 CPUs)   
Memory Used     23.38% (957,600 of 4,096,000)   
Swap Used       0% (0 of 1)

And this is print screen for process manager http://elnhrda.com/promgr.jpg

This is 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

Iam looking for doing any thing to increase my website speed

I have VPS 4G.B RAM CENTOS 6 X86_64

Note please : this statics taken now which no any queries executed & site have not any visitors in the same time

© Server Fault or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about error-logging

Error logging with PHP and mod_fcgid

as seen on Server Fault - Search for 'Server Fault'
I have a mediawiki install that is acting up. Whenever I try to save an article, it goes to a blank screen. All though if I refresh that blank screen, it will go on to work. I have no idea why it's doing that, but it seems to be that it's a problem with PHP. I guess by default errors don't get logged… >>> More
MailMan error logging in Apache

as seen on Server Fault - Search for 'Server Fault'
I am working on a MailMan implementation using Fedora 12. I have it set up and running but I was looking at what happens if someone tries to brute force a password on the web GUI and found that MailMan doesn't log these errors at all or I'm completely looking in the wrong place. I have tried both… >>> More
Suggest any Error Logging facility for Winforms application for writing error in a remote database

as seen on Stack Overflow - Search for 'Stack Overflow'
My team working in a project using Winforms application(c#) & MSSQL 2005 as database. When I searched the goggle,I found ELMAH, NLog & log4net.I didn't have enough knowledge to implement in Winforms application. Please suggest any reference/library for writing Error Logging for Winforms… >>> More
ELMAH error logging for Windows Service

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using ELMAH to log the web application exception which works great!. Also we want to know how to customize ELMAH to log the windows service exception. I am not interested in using another application for logging only windows service exception. Any help would be appreciated. >>> More
error logging in zend

as seen on Stack Overflow - Search for 'Stack Overflow'
i am using zend for 1st time..i am facing problems in finding errors. when a setter and getter function name mismatch i get a an error...but the error is show sometimes and not all the time...how do i log such errors.is there any separate log for this? >>> More