From: Martin Gainty
Date: June 1 2008 10:55pm
Subject: RE: Query Getting Slower
List-Archive: http://lists.mysql.com/mysql/213135
Message-Id: <BLU142-W30021E9CBA9C24223D63A7AEB80@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_a24c1441-4ab0-480b-a6af-84fabc413cb3_"

--_a24c1441-4ab0-480b-a6af-84fabc413cb3_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Hi Phil-


you can increment your query_cache_size
Information on generating performance metrics=20
mysql> show variables like 'query%';and tuning for your specific=20
configuration available at
http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html

e.g.
mysql>set global query_cache_size=3D50000000;

Martin

> I'd guess that you aren't running any OPTIMIZE TABLE=20
commands. Try running
> them daily or so.
>=20
> Phil
>=20

> On Sat, May 31, 2008 at 11:29 AM, sangprabv <sangprabv@stripped> wrote:
>=20

>> Hi,
>> I have a MySQL server with millions of records. And=20
it's getting slower
>> when we do query. Does anybody can share me how=20
to tune up my DB to get
>> faster?=20
TIA
>>
>>
>>=20
Willy
>>
>>
>> --
>> MySQL General Mailing=20
List
>> For list archives: http://lists.mysql.com/mysql
>>=20
To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dpchapman@stripped
>>
>=20

>=20
>=20
> --=20
> Help build our city at http://free-dc.myminicity.com !
>

Martin Gainty=20

______________________________________________=20
Disclaimer and confidentiality note=20
Everything in this e-mail and any attachments relates to the official busin=
ess of Sender. This transmission is of a confidential nature and Sender doe=
s not endorse distribution to any party other than intended recipient. Send=
er does not necessarily endorse content contained within this transmission.=
=20


> Date: Sun, 1 Jun 2008 18:13:21 -0400
> From: freedc.bok@stripped
> To: sangprabv@stripped
> Subject: Re: Query Getting Slower
> CC: mysql@stripped
>=20
> I'd guess that you aren't running any OPTIMIZE TABLE commands. Try runnin=
g
> them daily or so.
>=20
> Phil
>=20
> On Sat, May 31, 2008 at 11:29 AM, sangprabv <sangprabv@stripped> wrote:
>=20
> > 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=3Dpchapman@stripped.=
com
> >
>=20
>=20
>=20
> --=20
> Help build our city at http://free-dc.myminicity.com !

_________________________________________________________________
Change the world with e-mail. Join the i=92m Initiative from Microsoft.
http://im.live.com/Messenger/IM/Join/Default.aspx?source=3DEML_WL_ChangeWor=
ld=

--_a24c1441-4ab0-480b-a6af-84fabc413cb3_--