[mythtv-users] anyone using percona instead of mysql (stock)?
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.
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