MySQL Manual
4 Database Administration
- 4.5 Database Administration Language Reference
- 4.5.7
SHOWSyntax- 4.5.7.1 Retrieving information about Database, Tables, Columns, and Indexes
- 4.5.7.2
SHOW TABLE STATUS - 4.5.7.3
SHOW STATUS - 4.5.7.4
SHOW VARIABLES - 4.5.7.5
SHOW [BDB] LOGS - 4.5.7.6
SHOW PROCESSLIST - 4.5.7.7
SHOW GRANTS - 4.5.7.8
SHOW CREATE TABLE - 4.5.7.9
SHOW WARNINGS | ERRORS - 4.5.7.10
SHOW TABLE TYPES - 4.5.7.11
SHOW PRIVILEGES
4.5.7.5 SHOW [BDB] LOGS
SHOW LOGS shows you status information about existing log
files. It currently only displays information about Berkeley DB log
files, so an alias for it is SHOW BDB LOGS.
Fileshows the full path to the log fileTypeshows the type of the log file (BDBfor Berkeley DB log files)Statusshows the status of the log file (FREEif the file can be removed, orIN USEif the file is needed by the transaction subsystem)
