mysql: getting system info
Posted by Paul Verreth Mon, 05 Feb 2007 16:00:00 GMT
Nederlandse versie van dit artikel
Shortlist of the most useful show command’s:
pager less; show databases; show tables; show create database|table database|table; show [full] processlist; (\G) show table status; show status; show engine innodb status; (\G) show privileges; show grants; show variables; show warnings; show error;
Attention:
Output from show table status:
For the innodb engine: InnoDB free: ... : free space in the tablespace.
