查看进程号
jps -l -v(jps -q只显示pid)
jstack获取此时的线程快照
jstack -l 1(pid) > 1.txt
将文件导出到本地
docker cp rms:/1.txt ./ sz 1.txt
查看使用的gc
sh-4.2# java -XX:+PrintCommandLineFlags -version
-XX:InitialHeapSize=125857536 -XX:MaxHeapSize=2013720576 -XX:+PrintCommandLineFlags -XX:+UseCompressedClassPointers -XX:+UseCompressedOops -XX:+UseParallelGC
openjdk version "1.8.0_332"
OpenJDK Runtime Environment (build 1.8.0_332-b09)
OpenJDK 64-Bit Server VM (build 25.332-b09, mixed mode)
查看mysql的查询频率
mysql> SHOW GLOBAL STATUS LIKE 'Com_______';
show variables where Variable_name="general_log";
set global general_log=on;
show variables where Variable_name="general_log_file";
该文件就是最近查询的sql记录
此处发现大量重复的sql调用缓存解决
查看那些客户端链接了
SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;
查看各分代
jmap -J-d64 -heap pid
