Mysql

From Igor personal wiki
Jump to: navigation, search

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;



Building_mysql_slave_minimum_downtime

Building_mysql_cluster