Conceptually, what I'd like to do is join two tables on a hostid for a
result like this non-join version where hostid in the 'IN' come from the
other table.
mysql> explain select avg(load5min) from kstatHostData_20050513 where
hostid IN (250, 400) and localdate > '2005-06-06 13:00:00'\G
I recently migrated a myisam database to a dual processor AMD Opteron
(see specs below) host and found that tables would sporadically lock and
not release and so all subsequent inserts would be blocked. In this
state, I was unable to nicely restart the server. It would simply give
up. Repairing
