SIDEBAR
»
S
I
D
E
B
A
R
«
Speed up MySQL connection
August 28th, 2009 by Mojtaba

If you want to run a MySQL server on you local network, you can disable name resolve feature in order to get faster connection (Up to 10x faster). Remember that after disabling name resolve you have to enter your server IP address each time you want to use it.

Ok, follow me if you want faster connection:

  1. Open your MySQL config file. /etc/my.cnf
  2. Find [mysqld] and insert following string below it
    • skip-name-resolve

Here is an example
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-name-resolve


Leave a Reply


XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>




»  Substance:WordPress   »  Style:Ahren Ahimsa
© 2010 Mojtabacazi.com . All right reserved