We’ve had a problem at work recently — very very slow MySQL performance. And I’ve tried everything, increase that buffer, decrease the other buffer. Nothing. MySQL refused to work optimally.
I had noticed tho, that local connections, that is over UNIX sockets — not TCP/IP, were blazing fast. Then I’ve realized that MySQL was trying to reverse lookup all incoming TCP/IP connections, before allowing any data pass-through.
Just by adding ’skip_name_resolve’ under [mysqld] section in our my.cnf the database became super-fast.
Bear in mind tho — all your users that have hostnames for authentication, won’t work with that line! Only IP-based hosts will work.
