use mysql;
show table status like 'user'\G;
----------------------------------------
mysqladmin processlist
-----------------------------
show engines
show index from table
-----------------
cd /proc/21983/
cat io
cat status
------------------------
show events;
-----------------------
show engine innodb status
------------------------------------
select 1;
select version();
select user()
----------------------------------
select * from information_schema.innodb_trx\G
select * from information_schema.innodb_locks\G
select * from information_schema.innodb_lock_waits\G
-----------------------------------------------------
统计mysql数据库中 innodb引擎的表各自的表的大小，数据的大小，索引的大小，行数
SELECT table_schema,table_name, table_rows, \
ROUND((data_length+index_length)/1024/1024) AS total_mb, \
ROUND(data_length/1024/1024) AS data_mb, \
ROUND(index_length/1024/1024) AS index_mb \
FROM INFORMATION_SCHEMA.TABLES WHERE engine='InnoDB';
