2,187
edits
Difference between revisions of "Maintenance (MySQL)"
Jump to navigation
Jump to search
m
→SHOW etc: version
m (→SHOW etc: innodb) |
m (→SHOW etc: version) |
||
| Line 3: | Line 3: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
SHOW STATUS; # Shows general info | SHOW STATUS; # Shows general info | ||
SHOW VARIABLES LIKE "%version%"; # Show running MySQL version | |||
SHOW ENGINE INNODB STATUS \G # Show InnoDB database status | SHOW ENGINE INNODB STATUS \G # Show InnoDB database status | ||
SHOW DATABASES; # Show databases | SHOW DATABASES; # Show databases | ||