Re: Huge temporary file

2008-08-25 Thread rajlist
In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]> spoke thus: > I'm at a loss as to why, other than that I must have hit > some threshold. If anyone can tell me what I need to change in my > configuration, I'd appreciate it. MySQL creates the tmp tables in memory if the size of the table mat

Re: Slow mysql connections

2008-08-13 Thread rajlist
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 yo