Bug #31719 Incorporate the changes for SHOW TABLE_STATS, INDEX_STATS and USER_STATS
Submitted: 19 Oct 2007 14:55 Modified: 19 Oct 2007 15:13
Reporter: Mark Callaghan Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: INDEX, show, statistics, table, user

[19 Oct 2007 14:55] Mark Callaghan
The Google MySQL patches at http://code.google.com/p/google-mysql-tools/wiki/Mysql5Patches contain support for new SQL statements: SHOW TABLE_STATISTICS, SHOW USER_STATISTICS and SHOW INDEX_STATISTICS. These report resource usage at the table, index and account level. They are invaluable for tracking changes in the database workload (as long as you have more than one account and one table).

Support for this feature should be trivial to add and makes MySQL easier to manage.

When will you add this to MySQL?

How to repeat:

Suggested fix:
Add support for these SQL statements.
[19 Oct 2007 14:57] Mark Callaghan
The statements are described at http://code.google.com/p/google-mysql-tools/wiki/UserTableMonitoring
[19 Oct 2007 15:13] MySQL Verification Team
Thank you for bug report feature request.
[10 Dec 2007 21:21] fredrik rovik
This is simply a very much needed functionality that is essential
[4 Aug 2008 17:06] Sean Chighizola
I agree, these are necessary tools for a DBA to utilize and am eager to see them integrated.
[6 Aug 2008 19:07] Amr Hamdy
This is a too much needed feature ... I hope that it can be officially supported in MySQL 5.x versions too.