Bug #40740 Unable to see creation time of databases
Submitted: 14 Nov 2008 12:59 Modified: 19 Nov 2008 11:39
Reporter: Johan Andersson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request) / R6 (Needs Assessment) / E6 (Needs Assessment)

[14 Nov 2008 12:59] Johan Andersson
Description:
It is impossible to see what time a database was created (creation_time).

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| abc                | 
| test               | 
+--------------------+
3 rows in set (0.00 sec)

or have a command:

show database status;

How to repeat:
not possible - missing func

Suggested fix:
Add func
[19 Nov 2008 11:39] Hartmut Holzgraefe
The I_S.TABLES table has `CREATE_TIME` and `UPDATE_TIME` columns providing this kind of information for tables, having the same information in I_S.SCHEMATA might be nice indeed ...
[18 May 2009 14:25] Johan Andersson
The only problem is that CREATE_TIME and UPDATE_TIME aren't set!

mysql> show create table t1;;
+-------+-------------------------------------------------------------------------------------------+
| Table | Create Table                                                                              |
+-------+-------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `a` int(11) DEFAULT NULL
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 | 
+-------+-------------------------------------------------------------------------------------------+

mysql> select create_time, update_time from information_schema.tables where table_name='t1';
+-------------+-------------+
| create_time | update_time |
+-------------+-------------+
| NULL        | NULL        | 
+-------------+-------------+
1 row in set (0.00 sec)