Bug #80986 innodb complains about innodb_table_stats even if persistent stats disabled
Submitted: 7 Apr 2016 5:29
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7.13 OS:Any
Assigned to: CPU Architecture:Any

[7 Apr 2016 5:29] Shane Bester
error log outputs:

Version: '5.7.13'  socket: ''  port: 3306  MySQL Community Server (GPL)
[ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
[ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.

even when server is started with --innodb-stats-persistent=0

How to repeat:
#start server with --innodb-stats-persistent=0


drop table if exists t;
create table t(a int,key(a))engine=innodb;
alter table t add column b int;

Suggested fix:
if we disabled persistent stats, don't look for `mysql`.`innodb_table_stats`
[7 Apr 2016 5:30] MySQL Verification Team
the table does not really exist on my system (it was dropped),  but innodb shouldn't look for it as persistent stats are disabled.