[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.

-- 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