MySQL Workbench displays the wrong table rows size

Question

MySQL Workbench is not displaying the right table row size. Please see the screenshot, and take a look at "Table rows".

MySQL Workbench shows at "Table rows" 0. This is clearly wrong. See Action output:

09:21:37    SELECT * FROM mydb.mytable  280672 row(s) returned  0.031 sec / 24.969 sec

The question: why is Mysql Workbench displaying the wrong table row size?

I assume that the big table size is the cause for the problem.

Answer 1

I had already tried Julian's answer and it didn't do anything to update the rows, probably because my table was about 8 million rows. In the end I had to remove the limit and select all the rows - this will show a rows returned count. This isn't ideal for obvious reasons, and is almost definitely a Workbench bug, but it seems it's currently the only way to accurately verify that a database has all its rows in Workbench.

Answer 2

I solved this by clicking on the "Analyze Table" button, screenshot:

It updated the table details info, screenshot: