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. Setting this value too high might slow down your system. Please check the source below for more technical information.

Source

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

Leave a Reply

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