paginate problem

[jalalmoslemi]

in phpmyadmin version 5.2.1 i have a table with more then 1 million record then when i open the table and press >> which means go to last page , go to end it goes near the last page and not the last one exactly , there is still more then 1K records witch haven't been included in the paginate simply phpmyadmin is ignoring them. but for small tables , this problem does not exist.

[liviuconcioiu]

Are you using InnoDB as engine? InnoDB gives an estimate count, not a real count (see https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html)

I also think this is a duplicate of #16962.

[williamdes]

I am closing this as a duplicate, let me know if that was a mistake