In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> spoke thus:
> Hi all,
>
> Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
> has 16Gb ram. Previously it was using only 6GB ram. The details are as
> follows. DNS looks fine.
Is it that the database you are connecting to has too many tables or
columns and the mysql client spends some time making the autocomplete
list? Try connecting with "-A" option.
If that does not help, from your client box, do the following
"
strace -o mysql.strace -T mysql -u root -h host -p
"
(disconnect immediately after getting a connection)
This will record you all the syscalls mysql client has made along with the
ime spent in each syscall (-T option) in the mysql.strace file (-o
option). Review that file to see which syscall takes the maximum amount
of time.
--
raj shekhar
facts: http://rajshekhar.net
opinions: http://rajshekhar.net/blog
I've never made anyone's life easier and you know it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
