Re: The Use database command is too slow

2008-02-02 Thread imad
gt; mysql -uroot -A > > > shell> mysql -uroot --skip-auto-rehash > > > > > > Saravanan > > > MySQL DBA > > > > > > > > > --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > > > > > > From: imad <[EM

Re: The Use database command is too slow

2008-02-02 Thread Eric Bergen
gt; --no-auto-rehash. > > > > shell> mysql -uroot -A > > shell> mysql -uroot --skip-auto-rehash > > > > Saravanan > > MySQL DBA > > > > > > --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > > > > From: imad &

Re: The Use database command is too slow

2008-02-02 Thread imad
[EMAIL PROTECTED]> wrote: > > > From: imad <[EMAIL PROTECTED]> > > Subject: The Use database command is too slow > > To: mysql@lists.mysql.com > > Date: Saturday, February 2, 2008, 6:14 AM > > > Hello, > > > > I have like 50K databases on my serv

Re: The Use database command is too slow

2008-02-02 Thread Saravanan
p-auto-rehash Saravanan MySQL DBA --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > From: imad <[EMAIL PROTECTED]> > Subject: The Use database command is too slow > To: mysql@lists.mysql.com > Date: Saturday, February 2, 2008, 6:14 AM > Hello, > > I have l

The Use database command is too slow

2008-02-02 Thread imad
Hello, I have like 50K databases on my server, one for every user. I am experience delay in the command 'use database' which is issued by every user when he connects to the database. Can anyone here tell me what is my problem and how can I speed it up. thanks -- MySQL General Mailing List For