巡 检 人:小麦苗([QQ:646634621] [微信公众号:DB宝] [提供OCP、OCM、高可用、MySQL和PostgreSQL最实用的培训]) 巡检时间:2023-04-06 14:45:16 版 本 号:v7.0.0 修改日期:2023-3-29
[转到页底]
● 数据库基本信息
now_date | user | CURRENT_USER1 | CONNECTION_ID | db_name | Server_version | tx_isolation | autocommit |
---|---|---|---|---|---|---|---|
2023-04-06 14:45:21 | 11 | 5.1.0 | REPEATABLE-READ1 |
● 前端实例配置信息
*************************** 1. row *************************** Name: 127.0.0.1_9010_1680064832570 IP: 127.0.0.1 EditLogPort: 9010 HttpPort: 8030 QueryPort: 9030 RpcPort: 9020 Role: LEADER ClusterId: 1723834094 Join: true Alive: true ReplayedJournalId: 206533 LastHeartbeat: 2023-04-06 14:45:20 IsHelper: true ErrMsg: StartTime: 2023-04-06 14:37:05 Version: 2.5.3-46bf084 |
● 后端实例配置信息
*************************** 1. row *************************** BackendId: 11001 IP: 127.0.0.1 HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2023-04-06 14:37:04 LastHeartbeat: 2023-04-06 14:45:20 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 88 DataUsedCapacity: 34.443 KB AvailCapacity: 497.213 GB TotalCapacity: 1019.104 GB UsedPct: 51.21 % MaxDiskUsedPct: 51.21 % ErrMsg: Version: 2.5.3-46bf084 Status: {"lastSuccessReportTabletsTime":"2023-04-06 14:45:05"} DataTotalCapacity: 497.213 GB DataUsedPct: 0.00 % CpuCores: 16 NumRunningQueries: 0 MemUsedPct: 0.27 % CpuUsedPct: 0.2 % |
● broker配置信息
*************************** 1. row *************************** Name: broker_name IP: 127.0.0.1 Port: 8000 Alive: true LastStartTime: 2023-04-06 14:43:45 LastUpdateTime: 2023-04-06 14:45:20 ErrMsg: |
● 版本信息
VARIABLE_NAME | VARIABLE_VALUE |
---|---|
version_comment | StarRocks version 2.5.3 |
● 当前数据库实例的所有数据库及其容量大小
SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | table_rows | data_size_mb | index_size_mb | all_size_mb | max_size_mb | free_size_mb |
---|---|---|---|---|---|---|---|---|
lhrdb | utf8 | utf8_general_ci | 12288 | 0.01 | ||||
example_db | utf8 | utf8_general_ci | 0 | 0 | ||||
information_schema | utf8 | utf8_general_ci | ||||||
sbtest | utf8 | utf8_general_ci | ||||||
_statistics_ | utf8 | utf8_general_ci | 24 | 0.01 | ||||
db1 | utf8 | utf8_general_ci | 3 | 0 |
● 数据库对象
db_name | ob_type | sums |
---|---|---|
information_schema | TABLE | 27 |
example_db | TABLE | 1 |
db1 | TABLE | 1 |
lhrdb | TABLE | 1 |
_statistics_ | TABLE | 3 |
● 查看数据库的运行状态
-------------- mysql Ver 8.0.15 for Win64 on x86_64 (MySQL Community Server - GPL) Connection id: 11 Current database: 'root'@'192.168.27.52' Current user: 'root'@'192.168.27.52' SSL: Not in use Using delimiter: ; Server version: 5.1.0 StarRocks version 2.5.3 Protocol version: 10 Connection: 172.18.0.14 via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 9030 -------------- |
● 占用空间最大的前10张大表
db_name | table_name | TABLE_TYPE | ENGINE | CREATE_TIME | UPDATE_TIME | TABLE_COLLATION | table_rows | tb_size_mb | index_size_mb | all_size_mb | free_size_mb |
---|---|---|---|---|---|---|---|---|---|---|---|
information_schema | referential_constraints | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | tables | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | key_column_usage | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | session_variables | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | routines | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | global_variables | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | columns | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | schemata | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
information_schema | table_privileges | BASE TABLE | MEMORY | 2023-04-06 14:37:03 | utf8_general_ci | ||||||
db1 | sr_on_mac | BASE TABLE | StarRocks | 2023-03-29 15:17:52 | 2023-03-29 15:17:52 | utf8_general_ci | 3 | 0 |
● 所有存储引擎列表
ENGINE | SUPPORT | COMMENT | TRANSACTIONS | XA | SAVEPOINTS |
---|
● 存储引擎和DB的数量关系
ENGINE | counts |
---|---|
StarRocks | 6 |
MEMORY | 27 |
TABLE_SCHEMA | ENGINE | counts |
---|---|---|
information_schema | MEMORY | 27 |
_statistics_ | StarRocks | 3 |
db1 | StarRocks | 1 |
example_db | StarRocks | 1 |
lhrdb | StarRocks | 1 |
● 查询所有用户
*************************** 1. row *************************** UserIdentity: 'root'@'%' Grants: GRANT NODE, ADMIN ON *.* TO 'root'@'%' |
● 查询MySQL支持的所有字符集
CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | DESCRIPTION | MAXLEN |
---|---|---|---|
utf8 | utf8_general_ci | UTF-8 Unicode | 3 |
● 一些重要的参数
VARIABLE_NAME | VARIABLE_VALUE |
---|---|
autocommit | true |
lower_case_table_names | 0 |
query_cache_size | 1048576 |
query_cache_type | 0 |
transaction_isolation | REPEATABLE-READ |
tx_isolation | REPEATABLE-READ |
● 查看当前连接到数据库的用户信息
*************************** 1. row *************************** Id: 8 User: root Host: 127.0.0.1:40532 Db: Command: Sleep ConnectionStartTime: 2023-04-06 14:43:43 Time: 97 State: EOF Info: show broker IsPending: false *************************** 2. row *************************** Id: 11 User: root Host: 192.168.27.52:59567 Db: Command: Query ConnectionStartTime: 2023-04-06 14:45:14 Time: 0 State: OK Info: show processlist IsPending: false |
● 自增ID的使用情况(前20条)
table_schema | table_name | engine | Auto_increment |
---|