From: Martin Gainty
Date: July 16 2009 2:29pm
Subject: RE: Slow query Performance
List-Archive: http://lists.mysql.com/mysql/218215
Message-Id: <BLU142-W15E61D0EB149EBCF38CD2FAE210@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_4e9e422f-7cc5-4482-84bd-2a22da48d61a_"

--_4e9e422f-7cc5-4482-84bd-2a22da48d61a_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


when my.ini has query-cache-type =3D 1 setting
the query results are placed in cache on first read
second and consequent reads reference resultset from cache

http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Qu=
ery-Cache.htm

Martin Gainty=20
Confucius say "Big Dog in door prevents newspaper from being stolen"
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
 pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
 ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
.




> Date: Thu=2C 16 Jul 2009 10:08:03 -0400
> From: don_read@stripped
> To: dsteplight@stripped
> CC: mysql@stripped
> Subject: Re: Slow query Performance
>=20
> On Wed=2C 15 Jul 2009 23:53:05 -0400 Darryle Steplight said:
>=20
> > Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
> >=20
> > On Wed=2C Jul 15=2C 2009 at 6:44 PM=2C Tachu=AE<tachu1+mysql@stripped>=
 wrote:
> > > I'm having random query slowness that i can only reproduce once. My m=
ain
> > > question is that the query runs faster the second time around but i d=
ont
> > > have ...
>=20
> <snipage>
>=20
> > >=20
> >=20
> > --=20
> > A: It reverses the normal flow of conversation.
> > Q: What's wrong with top-posting?
> > A: Top-posting.
> > Q: What's the biggest scourge on plain text email discussions?
> >=20
>=20
> Anybody else see the irony here?
>=20
> --=20
> Don Read                                        don_read@stripped
>      It's always darkest before the dawn. So if you are going to
>      steal the neighbor's newspaper=2C that's the time to do it.
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20

_________________________________________________________________
Insert movie times and more without leaving Hotmail=AE.=20
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=3DTXT_TAGLM_WL_HM_Tut=
orial_QuickAdd_062009=

--_4e9e422f-7cc5-4482-84bd-2a22da48d61a_--