Mysql Sockets and WordPress

This is a real simple tweak and technically should have a performance increase (unix sockets are generally a lot faster), first check your /etc/my.conf that you have sockets defined, it should look something like:

socket=/var/lib/mysql/mysql.sock  

Now just update your wp-config.php file and change your db_host section

# define('DB_HOST', 'localhost');
define('DB_HOST', ':/var/lib/mysql/mysql.sock');  

Now go check out how much faster your MySQL queries are running.

comments powered by Disqus