Re: Long time for client to connect; not for script.

2014-11-11 Thread Hartmut Holzgraefe
On 10.11.2014 17:57, Ken D'Ambrosio wrote: > Can someone help explain something to me? When I use "mysql" to connect > to my server, it can take upwards of 15 seconds. Are you connecting to a database with many tables? In that case "mysql -A ..." (--no-auto-rehash) may make a difference. This w

Long time for client to connect; not for script.

2014-11-10 Thread Ken D'Ambrosio
Can someone help explain something to me? When I use "mysql" to connect to my server, it can take upwards of 15 seconds. When I use any of the Ruby scripts I've written, it's so fast it's not even obvious it's querying a remote host. Any idea what might cause this disparity? (My initial sus