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 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]
