Mysql
From Igor personal wiki
show databases;
show tables;
SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';
Engines[edit]
show engines;
Engines configuration in my.cnf
plugin_dir=/usr/lib64/mysql/plugin/ ignore-builtin-innodb plugin-load="innodb=ha_innodb_plugin.so;federated=ha_federated.so;blackhole=ha_blackhole.so;archive=ha_archive.so" federated
Enabling mysql loging all SQL requests on fly
SET GLOBAL general_log_file = "sql.log"; SET global log_output = 'file'; SET global general_log = 1;
disabling after
SET global general_log = 0;