From: Date: June 6 2003 6:32pm
Subject: Speeding up "copy to tmp table"
List-Archive: http://lists.mysql.com/mysql/141952
Message-Id: <8190686B6BD0AE4DA8A983E273B3656E011EFB32@harrison.er.erealty.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;	boundary="----_=_NextPart_001_01C32C49.36497030"

------_=_NextPart_001_01C32C49.36497030
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

What steps can be taken to speed up queries that show state=3D"copy to =
tmp
table" in show processlist?  I am running MySql on a dual Xeon system
running Windows 2000 server with 10 10K rpm drives in 5 raid 0 arrays
and plenty of ram that isn't being utilized. =20
=20
Sam

------_=_NextPart_001_01C32C49.36497030--