MySQL self-use script (not updated regularly)

Query the trace information for the specified SQL

Mysql-uUSER -PPWD -HHOST"\INS_TC_PRD; Set session Optimizer_trace='enabled=on'1638400SQL  Select * from Information_schema.optimizer_trace\g; " > Trace_log.log

To view the usage of a tablespace

Select table_name,        (Data_length + / 1024x768 / 1024x768  as TOTAL_MB,          from  where table_schema='Database' ; // do not write is all

View MySQL Database status

Mysqladmin-p3306-uroot-p-h127.0.0.1-r-i1Extended-status |awk-F"|" "begin{count=0;}"'{if ($ ~/variable_name/&& ((++count)%20 = = 1)) {\Print"----------|---------|---MySQL Command Status--|-----Innodb Row Operation-----|--Buffer Pool Read--"; \ print"---time---|---QPS---|select insert update delete|   Read inserted updated deleted| Logical Physical";\ } \ Else if($2~/queries/) {queries=$3;} \ Else if($2~/com_select/) {com_select=$3;} \ Else if($2~/com_insert/) {com_insert=$3;} \ Else if($2~/com_update/) {com_update=$3;} \ Else if($2~/com_delete/) {com_delete=$3;} \ Else if($2~/innodb_rows_read/) {innodb_rows_read=$3;} \ Else if($2~/innodb_rows_deleted/) {innodb_rows_deleted=$3;} \ Else if($2~/innodb_rows_inserted/) {innodb_rows_inserted=$3;} \ Else if($2~/innodb_rows_updated/) {innodb_rows_updated=$3;} \ Else if($2~/innodb_buffer_pool_read_requests/) {innodb_lor=$3;} \ Else if($2~/innodb_buffer_pool_reads/) {innodb_phr=$3;} \ Else if($2~/uptime/&& Count >=2) {\ printf ("%s |%9d", Strftime ("%h:%m:%s"), queries); \ printf ("|%6d%6d%6d%6d", com_select,com_insert,com_update,com_delete); \ printf ("|%8d%6d%7d%7d", innodb_rows_read,innodb_rows_inserted,innodb_rows_updated,innodb_rows_deleted); \ printf ("|%10d%11d\n", innodb_lor,innodb_phr); \}}';

Turn from

1. http://blog.itpub.net/29510932/viewspace-1812475/

MySQL self-use script (not updated regularly)