mysql table size etc

mysql table size etc

SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS,DATA_LENGTH,INDEX_LENGTH FROM information_schema.TABLES 
where DATA_LENGTH+INDEX_LENGTH >0 and TABLE_SCHEMA not in ('mysql','sys','information_schema');

select * from information_schema.TABLES limit 1;

SELECT CONCAT(TABLE_SCHEMA,'.',TABLE_NAME) TBL,TABLE_ROWS,DATA_LENGTH,INDEX_LENGTH,UPDATE_TIME FROM information_schema.TABLES where DATA_LENGTH+INDEX_LENGTH >0 and TABLE_SCHEMA not in ('mysql','sys','information_schema','performance_schema');

select CONCAT(TABLE_SCHEMA,'.',TABLE_NAME) TBL, COLUMN_NAME as col, DATA_TYPE as type from information_schema.columns where TABLE_SCHEMA not in ('mysql','sys','information_schema','performance_schema') limit 100;

select count(*) from information_schema.columns where TABLE_SCHEMA not in ('mysql','sys','information_schema','performance_schema')

TODO: GROUP BY COL 
=> 
if count(*)>ct_manually then:
    manually tick needed; or sampling
else:
    count (<max_count) or manually tick => do group table :
call build_col_rpt(col)

SELECT table_schema, table_name, engine, table_rows,update_time,avg_row_length FROM information_schema.tables
WHERE table_schema NOT IN ('mysql','sys','information_schema','performance_schema')
ORDER BY table_rows * avg_row_length DESC;