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
