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]

Reply via email to