• MySQL数据库常用操作命令

    calendar 2023-05-09 · 2 分钟 阅读 · MySQL

    查询数据库有哪些用户 1use mysql; 2select host,user from user; 查询进程列表 1show full processlist 查看数据库及表容量⼤⼩并排序查看所有数据库容量⼤⼩ 1SELECT 2 table_schema AS '数据库', 3 sum(table_rows) AS '记录数', 4 sum( 5 TRUNCATE (data_length / 1024 / 1024, 2) 6 ) AS '数据容量(MB)', 7 sum( 8 TRUNCATE (index_length / 1024 / 1024, 2) 9 ) AS …


    阅读更多

  • Clickhouse常用查询语句

    calendar 2023-03-09 · 2 分钟 阅读 · Clickhouse

    连接 Clickhouse 1./clickhouse-client --host xxx.xxx.xxx.xxx --port 9000 --user 'yyy' --password 'zzzzz' 查询库表信息 1use databases; 2select * from table; 3show create table; 查询数据库数据量大小 1##按照数据量倒序 2SELECT database, formatReadableSize(on_disk) FROM (SELECT database, sum(bytes_on_disk) AS on_disk FROM …


    阅读更多