Filed Under: General

Initial SQL Connection Slow

12 May 2008 No Comment Tags: , , ,

Currently the first time I am connecting to my SQL database the loading time is very long. After that the loading speed is normal.

I will post possible solutions to make the initial connection faster here:
- HostNameLookups defined at httpd.conf is ON, set it to off
- Add skip-name-resolve to your my.cnf so that your SQL database is sending out a reverse IP lookup (more info here: Dotscr.org

To make sure that SQL is running with “skip-name-resolve” execute the following code via SSH:
mysqladmin variables







Like our posts? Then subscribe via Mail:

Email:  

Similar Posts:

Socialize:

delicious stumbleupon

Leave your response!

Be nice. Keep it clean. Stay on topic. No spam.

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> <pre lang="" line="">

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.com.