没有相关命令查看索引创建时间,最多在binlog等日志中查看可以在mysql.innodb_index_stats查看最后更新时间
ExplanationThe log identifier in the token log-entry-identifier is composed of three parts:A three-letter prefix that indicates which log file includes diagnostic details.A three-digit number that indicates on which database partition the log file re...
统计信息都是最新的,查询条件中包含了账期和账户ID,就针对这个SQL语句不确定账期和账户ID哪个放前面比较好
SQL2314W , 比如你在runstat 的时候,有人在insert数据,这个时候索引就会发生变动, 于是警告出现了