-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).
Any advice would be appreciated!
--
Aaron Turner
http
-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
Those who would give up essential