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]
