Running "ANALYZE TABLE" on each table fixed the issue. I'm not sure this is default behaviour. Also, if CREATE TABLE is run when innodb_use_sys_stats_table=1 there's no need to run it.
Running "ANALYZE TABLE" on each table fixed the issue. I'm not sure this is default behaviour. use_sys_ stats_table= 1 there's no need to run it.
Also, if CREATE TABLE is run when innodb_