Hi everybody: Im using mysql version 4 max and red hat 7.2.When i connect to mysql database ,it take long time to connect since my connection to this database become huge.When i check the process,it show me waiting for Authentication.How to Improve it to make it faster to get the connection.
What is awaiting Authentication ? please post you connection script so we can see what to improve.
I usually do this to make a connection:
$db = mysql_connect("localhost", "root", "password"); mysql_select_db("databasename",$db);