Bug #69449 mysql.hosts has been removed since 5.6.7

• Submitted: 12 Jun 2013 12:43
• Modified: 12 Jun 2013 13:33
• Reporter: Cyril Scetbon
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6.7+
• OS: Any
• CPU Architecture: Any

[12 Jun 2013 12:43] Cyril Scetbon

Description:
http://dev.mysql.com/doc/refman/5.6/en/hosts-table.html says this table has been added in 5.6.3, but it has also been removed in 5.6.7 and it should be added in this page or the page should be removed ...

How to repeat:
n/a

Suggested fix:
n/a

[12 Jun 2013 13:24] MySQL Verification Team

Hello Cyril,

Thank you for your report.
But this is not a bug because the the manual page explains about the table "hosts" in Performance Schema(http://dev.mysql.com/doc/refman/5.6/en/hosts-table.html) and not about table the obsolete mysql.host table( http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-7.html ).

Below test case confirms this.. 

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.6.12-debug-log |
+------------------+
1 row in set (0.00 sec)

mysql> select database();
+--------------------+
| database()         |
+--------------------+
| performance_schema |
+--------------------+
1 row in set (0.00 sec)

mysql> show tables like 'hosts';
+--------------------------------------+
| Tables_in_performance_schema (hosts) |
+--------------------------------------+
| hosts                                |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> desc hosts;
+---------------------+------------+------+-----+---------+-------+
| Field               | Type       | Null | Key | Default | Extra |
+---------------------+------------+------+-----+---------+-------+
| HOST                | char(60)   | YES  |     | NULL    |       |
| CURRENT_CONNECTIONS | bigint(20) | NO   |     | NULL    |       |
| TOTAL_CONNECTIONS   | bigint(20) | NO   |     | NULL    |       |
+---------------------+------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select database();
+------------+
| database() |
+------------+
| mysql      |
+------------+
1 row in set (0.00 sec)

mysql> show tables like 'host%';
Empty set (0.00 sec)

mysql>

[12 Jun 2013 13:33] Cyril Scetbon

yes, you're right. I didn't notice the plural 's' at the end of table names…
I've already checked that host table disappeared but I thought your documentation was obsolete. Sorry for this misunderstanding

Regards