我遇到了一个奇怪的现象,我希望有人可以向我解释一下:
我有一些“静态”表格(它们每天更改一次)。
mysql> select 'appObjectGroups' as tbl, count(*) as num from appObjectGroups
union select 'appObjectDependencies' as tbl, count(*) as num from appObjectDependencies
union select 'appObjectUrls' as tbl, count(*) as num from appObjectUrls
union select 'appObjectValues' as tbl, count(*) as num from appObjectValues
union select 'appObjects;' as tbl, count(*) as num from appObjects;
+-------------------------+------+
| tbl | num |
+-------------------------+------+
| appObjectGroups | 1149 |
| appObjectDependencies | 6885 |
| appObjectUrls | 1162 |
| appObjectValues | 3795 |
| appObjects; | 5409 |
+-------------------------+------+
5 rows in set (0.00 sec)
mysql> select table_name as tbl, table_rows as num from information_schema.tables where table_schema='mySchema' and table_name like 'app%';
+-------------------------+------+
| tbl | num |
+-------------------------+------+
| appObjectGroups | 1141 |
| appObjectDependencies | 6153 |
| appObjectUrls | 1141 |
| appObjectValues | 3584 |
| appObjects | 6061 |
+-------------------------+------+
5 rows in set (0.01 sec)
那怎么会这样table_rows
报告与以下内容不同的内容count(*)
?
对我来说更重要的是:哪一个是正确的? :-)
引用自文档 https://dev.mysql.com/doc/refman/5.6/en/tables-table.html:
对于 InnoDB 表,行数只是粗略估算在 SQL 中使用
优化。 (如果 InnoDB 表已分区,也是如此。)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)