Workaround for slow count(*) in InnoDB

from the Artful MySQL Tips List

It can be especially slow in MySQL 5.7.

A workaround: for table tblname with primary key PK till it's fixed, pick off the rows value from ...


As of MySQL version 5.7.18, there is a better workaround: add a FORCE INDEX clause to the SELECT COUNT(*) command.

Return to the Artful MySQL Tips page