I've upgraded from Mysql 5.7 to 8 on Ubuntu 18.04
Made it by guide, very accurate, on a new empty server, checked all error/warning logs and fixed it. Everything works just fine with it.
I have 2 same Innodb tables, 1 was created and filled before updating and has right numbers of Rows / Size when querying:
SHOW TABLE STATUS FROM dbname;
Another table shows me 16Kb size and no rows, But its now ~8GB and 4.5 millions rows there. I tried to make Analyze Tablename
/ Update in Client (Heidisql).
I can't find anything in Google about problem like this. I choose table manually and check rows count, but when I'm using mysql visual clients like Phpmyadmin / HeidiSql it shows me no data in this table.
Best Answer
Check your settings for
information_schema_stats_expiry
. The default cache for schema stats is 86400s (1 day) so it's likely that you are just seeing cached information here. It's a session variable though, so you can just set it to zero for any situation where you want up-to-date information.