Bug #77928 Finding Index Creation Date & Time
Submitted: 4 Aug 2015 7:01
Reporter: Sripriya Venkataraman Email Updates:
Status: Open Impact on me:
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: Index Creation Date & Time

[4 Aug 2015 7:01] Sripriya Venkataraman
Mysql Gurus, 

The "show create table" shows the list of indexes and the fields bounded to the table, but I do not seem to find a way/query which tells the exact date and time the index has been created on a table. 

"show indexes from tablename" -> shows only the indexes existing on a table, but not their created date/time.

I think it is a desired and more useful feature to be added which helps us find the exact date/time the index has been created on a table.


How to repeat:
show indexes from tablename

- Does not show the time and date the indexes have been created.