List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:June 2 2008 6:00am
Subject:Re: Query Getting Slower
View as plain text  
You haven't given your sql statement here?

On Mon, Jun 2, 2008 at 6:55 AM, Martin Gainty <mgainty@stripped> wrote:

>
> Hi Phil-
>
>
> you can increment your query_cache_size
> Information on generating performance metrics
> mysql> show variables like 'query%';and tuning for your specific
> configuration available at
> http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html
>
> e.g.
> mysql>set global query_cache_size=50000000;
>
> Martin
>
> > I'd guess that you aren't running any OPTIMIZE TABLE
> commands. Try running
> > them daily or so.
> >
> > Phil
> >
>
> > On Sat, May 31, 2008 at 11:29 AM, sangprabv <sangprabv@stripped> wrote:
> >
>
> >> Hi,
> >> I have a MySQL server with millions of records. And
> it's getting slower
> >> when we do query. Does anybody can share me how
> to tune up my DB to get
> >> faster?
> TIA
> >>
> >>
> >>
> Willy
> >>
> >>
> >> --
> >> MySQL General Mailing
> List
> >> For list archives: http://lists.mysql.com/mysql
> >>
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >>
> >
>
> >
> >
> > --
> > Help build our city at http://free-dc.myminicity.com !
> >
>
> Martin Gainty
>
> ______________________________________________
> Disclaimer and confidentiality note
> Everything in this e-mail and any attachments relates to the official
> business of Sender. This transmission is of a confidential nature and Sender
> does not endorse distribution to any party other than intended recipient.
> Sender does not necessarily endorse content contained within this
> transmission.
>
>
> > Date: Sun, 1 Jun 2008 18:13:21 -0400
> > From: freedc.bok@stripped
> > To: sangprabv@stripped
> > Subject: Re: Query Getting Slower
> > CC: mysql@stripped
> >
> > I'd guess that you aren't running any OPTIMIZE TABLE commands. Try
> running
> > them daily or so.
> >
> > Phil
> >
> > On Sat, May 31, 2008 at 11:29 AM, sangprabv <sangprabv@stripped> wrote:
> >
> > > Hi,
> > > I have a MySQL server with millions of records. And it's getting slower
> > > when we do query. Does anybody can share me how to tune up my DB to get
> > > faster? TIA
> > >
> > >
> > > Willy
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> > >
> >
> >
> >
> > --
> > Help build our city at http://free-dc.myminicity.com !
>
> _________________________________________________________________
> Change the world with e-mail. Join the i'm Initiative from Microsoft.
> http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld




-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Thread
Query Getting Slowersangprabv1 Jun
  • Re: Query Getting SlowerPhil2 Jun
    • RE: Query Getting SlowerMartin Gainty2 Jun
      • Re: Query Getting SlowerMoon's Father2 Jun
  • Re: Query Getting Slowermos2 Jun