sh13661847134的博客

– 查询所有表大小selecttable_schema as ‘数据库’,table_name as ‘表名’,table_rows as ‘记录数’,truncate(data_length/1024/1024, 2) as ‘数据容量(MB)’,truncate(index_length/1024/1024, 2) as ‘索引容量(MB)’from information_schema.tablesorder by data_length desc, index_length desc

只读用户：1.使用现有的root用户登录到Mysql。mysql -uroot -p2.创建用户，并授权SELECT查询权限，授权远程访问权限，注意，命令中username/password指用户名密码，请自己指定。若要限制仅指定IP可以使用此用户访问Mysql，将%改为具IP即可。GRANT SElECT ON . TO ‘username’@’%’ IDENTIFIED BY “password”;此处创建的是和root一样权限的运维用户GRANT ALL PRIVILEGES ON . T