d tweak to solve
this specific issue. Server is a dual-quad core w/ 4GB of RAM,
although it's not dedicated to MySQL (webserver and some other
database centric background jobs run). Table1 however is on a
dedicated RAID1 disk pair and is getting regular inserts/deletes (it's
a log table).
g-subqueries.html
>
> If you have further questions after doing that, show the table structures,
> the query, and the explain output.
>
--
Aaron Turner
http://synfin.net/ Twitter: @synfinatic
http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows
