Hi, when you connect using mysql auto-rehash is enabled as default. It will read and open the tables in the database when 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 <[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 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 list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]