Hi Raj, In which path the trace file would be created. regards anandkl
On 8/13/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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] > >
