Its a known problem that changing the Storage Engine from MyISAM to InnoDB can cause some problems
[ 1
] if you have queries of this type:
SELECT COUNT(*) from table;
Luckily this query happens rarely and if, the query can be easily omitted or worked around by guesstimating the amount of rows in the table. For example with:
SHOW TABLE STATUS LIKE 'test';
But in some rare cases customer really needs these values for some reasons. To not exhaust the resources of the server with this query which can be fired …
