Aikesheng Open Source Community

Aug 2, 2019 · Databases

How to Retrieve Table Row Count in MySQL 8.0 – Methods, Deprecation of sql_calc_found_rows and Performance Comparison

The article explains five ways to obtain a table's row count in MySQL, discusses the deprecation of the sql_calc_found_rows feature in MySQL 8.0, compares the performance of the old and new approaches using EXPLAIN JSON, and recommends using the standard COUNT(*) query for accurate results.