Initial SQL Connection Slow
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:
Similar Posts:
- Wordpress: Count SQL Queries
- Fix your mail settings
- Wordpress: Importing large XML files
- HowTo print array values
- MySQL-Python needs MySQL 4.0
Socialize:
|
|











Leave your response!