Re: The Use database command is too slow

2008-02-02 Thread imad
It is a hosting solution, so users create databases for themselves if they want. On Feb 3, 2008 4:44 AM, Eric Bergen <[EMAIL PROTECTED]> wrote: > I think a better question is why do you have one database per user? > > -Eric > > > On 2/2/08, imad <[EMAIL PROT

Re: The Use database command is too slow

2008-02-02 Thread imad
hen you try to use the database. It may > take time for database with many tables. use mysql with -A or > --no-auto-rehash. > > shell> mysql -uroot -A > shell> mysql -uroot --skip-auto-rehash > > Saravanan > MySQL DBA > > > --- On Sat, 2/2/08, imad <

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