今天在处理问题时遇到这个报错 InnoDB: Error: Fetch of persistent statistics requested for table "mytest"."pomstd" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats insttestd. InnoDB: Error: Table "mysql"."innodb_table_stats" not found. InnoDB: Recalculation of persistent statistics requested for table "mytest"."pomstd" but the required persistent statistics storage is not present or is corrupted. Using transient stats insttestd. 检查目录,没有找到这个文件 这是mysql5.6新增的性能分析文件,通常处理办法就是创建此文件: CREATE TABLE `innodb_table_stats` ( `database_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `n_rows` bigint(20) unsigned NOT NULL, `clustered_index_size` bigint(20) unsigned NOT NULL, `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL, PRIMARY KEY (`database_name`,`table_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0; CREATE TABLE `innodb_index_stats` ( `database_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `index_name` varchar(64) COLLATE utf8_bin NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `stat_name` varchar(64) COLLATE utf8_bin NOT NULL, `stat_value` bigint(20) unsigned NOT NULL, `sample_size` bigint(20) unsigned DEFAULT NULL, `stat_description` varchar(1024) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
mysql5.6在导入时报innodb_table_stats不存在
来源:这里教程网
时间:2026-03-01 11:12:04
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 对机械硬盘和SSD固态硬盘IOPS、吞吐量的压测对比
对机械硬盘和SSD固态硬盘IOPS、吞吐量的压测对比
26-03-01 - 3ds MAX教程:装饰镜的建模流程
3ds MAX教程:装饰镜的建模流程
26-03-01 - 给从库预热innodb buffer pool
给从库预热innodb buffer pool
26-03-01 - 诡异的”慢查询“
诡异的”慢查询“
26-03-01 - MySQL位图索引解决用户画像问题(简化创建流程)
MySQL位图索引解决用户画像问题(简化创建流程)
26-03-01 - MySQL插件调用
MySQL插件调用
26-03-01 - 3ds MAX实例教程:制作汽车轮胎并给轮胎建模
3ds MAX实例教程:制作汽车轮胎并给轮胎建模
26-03-01 - Grafana+Prometheus 监控 MySql服务
Grafana+Prometheus 监控 MySql服务
26-03-01 - 3D MAX教程:树屋室内效果图制作流程解析
3D MAX教程:树屋室内效果图制作流程解析
26-03-01 - MySQL 8.0能彻底解决困扰运维的复制延迟问题!
MySQL 8.0能彻底解决困扰运维的复制延迟问题!
26-03-01
