mysqli_real_connect() often takes around 5 seconds,even on developing environment

Question

mysqli_real_connect($connection, $url['host'], $url['user'], $url['pass'], substr($url['path'], 1), $url['port'], NULL, MYSQLI_CLIENT_FOUND_ROWS);

What's the reason that it can take much time to make a connection?

Now about 3 out of 8 connections will hang for 5 seconds or even more.

Answer 1

I think your mysql server is overloaded. you can try raising your 'max_connections' in my.cnf . also check your logs for any helpfull information.