MySQL Schema
SHOW DATABASES;
SHOW TABLES;
DESCRIBE myTable;
SHOW INDEXES FROM myTable;
mysqlshow
mysqlshow myDatabase
mysqlshow myDatabase myTable
Show Database Creation Date
There is currently (Oct-2023) no way to retrieve the database creation time. However, you can retrieve the creation time of the first table...
SELECT table_schema "Database",
MAX(create_time)
FROM information_schema.tables
WHERE table_type='BASE TABLE'
AND table_schema NOT IN('information_schema', 'mysql', 'performance_schema', 'sys')
GROUP BY table_schema;
Show Database Size
Use this query to show how large each database is...
SELECT table_schema "DB Name",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size MB",
ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size GB"
FROM information_schema.tables
GROUP BY table_schema;