-- 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;