[mythtv-users] anyone using percona instead of mysql (stock)?
Jay Ashworth
jra at baylink.com
Tue Dec 20 14:46:34 UTC 2011
----- Original Message -----
> From: "Gary Buhrmaster" <gary.buhrmaster at gmail.com>
> I too have been running innodb for years at this point, and
> my recollection was that the 'select count(*)' on innodb
> resulted in a table scan (and an index lookup on myisam?),
> and that mythtv used that construct in numerous queries.
Well, SELECT COUNT(1) generally works fine, and doesn't touch the data at all,
in my experience.
Cheers,
-- jra
--
Jay R. Ashworth Baylink jra at baylink.com
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com 2000 Land Rover DII
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
More information about the mythtv-users
mailing list