I think a better question is why do you have one database per user? -Eric
On 2/2/08, imad <[EMAIL PROTECTED]> wrote: > I am not connecting through MySQL. I am connecting through PHP. How > can I speed it up? > > > > > On Feb 3, 2008 12:20 AM, Saravanan <[EMAIL PROTECTED]> wrote: > > 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] > > -- high performance mysql consulting. http://provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]