Re: Trivial query takes over 10 seconds

[Nathan Cheng]

From that other reply, looks like the related mysql bug isn't getting fixed any time soon. So how about a workaround?

How fast is the query if you don't use a sub-query? e.g.

SELECT device.* FROM device INNER JOIN device_ip USING( device_id ) GROUP BY device.device_id HAVING COUNT(device.device_id) > 1);