4 ms·
I cannot wait for the SELECT COUNT() improvements for innodb, I hope Percona backports them into 5.6 For SELECT COUNT (*) queries, where a table's committe
by ck2 13y ago
I cannot wait for the SELECT COUNT() improvements for innodb, I hope Percona backports them into 5.6
For SELECT COUNT (*) queries, where a table's committed record count is changed by transaction deltas,
there is now a single handler call to the storage engine to return the record count to the optimizer instead of one call for each record.
This change generally improves SELECT COUNT (*) query performance and reduces in-memory table scan cost, as each record is no longer returned to the optimizer.
- gmuslera 13y agoIt seem to imply creating new structures in files. You will need the upgrade_mysql or similar script for doing so, odds are low that it will happen keeping the same version number. There are also too many things in this version that are incompatible changes that requires upgrading the db, doing a small patch to upgrade individual feature could complicate things when comes the time to upgrade to 5.7+.