# login mysql -h [host] -P [port] -u [user_name] -p
# 查看索引 show index form [table_name];
# 查看建表命令 show create table [table_name];
# 查询表数据大小 SELECT TABLE_NAME AS 'Table', ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS 'Total Size (MB)', ROUND(DATA_LENGTH / 1024 / 1024, 2) AS 'Data Size (MB)', ROUND(INDEX_LENGTH / 1024 / 1024, 2) AS 'Index Size (MB)' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'airpay_is_card_center_vn_db';
# set json UPDATE metric_slo_record_tab SET extra_data = JSON_SET(extra_data, '$.cyclical_error_flag', true) WHERE id = 1;
// 查询 DB 数据大小 SELECT table_schema AS db, ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS used_mb FROM information_schema.tables WHERE table_schema = 'shopee_payment_module_limit_tw_db' GROUP BY table_schema;