SHOW PLUGINS;
SELECT PLUGIN_NAME as Name,PLUGIN_VERSION as Version, PLUGIN_STATUS as Status FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_TYPE='STORAGE ENGINE';
SELECT table_schema "Data Base Name",sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema ;
SHOW ENGINE INNODB STATUS;
show status;
SELECT COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS;
show engines;
select host, user, password from mysql.user;
show grants for cactiuser;
SHOW VARIABLES like 'version%';
pager less -n -i -S
status;
pager stdout
tee /tmp/test.txt;