Gentoo 维护的 MySQL 5.0.92 有数据表不可见的 bug，表现为：
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
| xupeng@localhost [(none)] mysql> use test;
Database changed
xupeng@localhost [test] mysql> create table testing (type tinyint) engine=innodb;
Query OK, 0 rows affected (0.26 sec)
xupeng@localhost [test] mysql> show tables;
Empty set (0.00 sec)
xupeng@localhost [test] mysql> show tables from information_schema;
Empty set (0.00 sec)
xupeng@localhost [test] mysql> select table_name from information_schema.tables where table_schema='test';
+------------+
| table_name |
+------------+
| testing |
+------------+
1 row in set (0.00 sec)
xupeng@localhost [test] mysql> insert into testing values (1);
Query OK, 1 row affected (0.04 sec)
xupeng@localhost [test] mysql> select * from testing;
+------+
| type |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
|
如上，数据表可正常读写，但 show tables 看不到，此问题和客户端无关。
5.0.92 官方版本则无此 bug。