Column #Rows for InnoDB tables shows an estimation

If you start the Data Explorer from the WP Data Access menu, you’ll see the list of tables in your WordPress database. The column #Rows shows the number of rows in the corresponding table. This number is a rough estimate of the number of rows (records) for InnoDB tables with an estimate row count over the “Max InnoDB row count” plugin parameter.

A warning sign will be shown for values concerning this issue. The “Max InnoDB row count” plugin parameter can be defined in the Plugin Back-end Settings. The default value is 100.000 which was changed in the example above for demonstration purposes. Setting this value too high might slow down your system. Please check the source for below for more technical information.

Note
You need to install WordPress plugin WP Data Access to start the Data Explorer.
The plugin can be downloaded from here

Source
MySQL 5.7 Reference Manual / INFORMATION_SCHEMA Tables / The INFORMATION_SCHEMA TABLES Table

Peter Schulz

Written by 

Lecturer at HAN University of Applied Sciences

Leave a Reply

Your email address will not be published. Required fields are marked *