24 lines
933 B
SQL
24 lines
933 B
SQL
-- diagnostics.sql
|
|
|
|
-- This script collects key system information to help diagnose
|
|
-- and troubleshoot performance issues.
|
|
|
|
-- This data can help identify system bottlenecks,
|
|
-- debug problems, and guide optimization efforts.
|
|
|
|
-- example:
|
|
-- cat diagnostics.sql | mysql -h127.0.0.1 -P9030 -uroot |gzip > diagnostics.gz
|
|
|
|
show frontends\G;
|
|
show backends\G;
|
|
show variables\G;
|
|
admin show frontend config\G;
|
|
select * from information_schema.loads\G;
|
|
select * from information_schema.routine_load_jobs\G;
|
|
select * from information_schema.be_metrics\G;
|
|
select * from information_schema.be_bvars\G;
|
|
select * from information_schema.be_cloud_native_compactions\G;
|
|
select BE_ID, NAME, VALUE from information_schema.be_configs\G;
|
|
show proc '/compactions'\G;
|
|
select BE_ID, LOG from (select BE_ID, TIMESTAMP, LOG from information_schema.be_logs where LEVEL='W' or LEVEL='E' order by TIMESTAMP DESC limit 5000) t order by BE_ID, TIMESTAMP ASC;
|