如何捕获问题sql解决过度cpu消耗问题

《如何捕获问题sql解决过度cpu消耗问题》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、如何捕获问题SQL解决过度CPU消耗问题如何捕获问题SQL解决过度CPU消耗问题问题描述:开发人员报告系统运行缓慢，影响用户访问.1.登陆数据库主机使用vmstat检查，发现CPU资源已经耗尽，大量任务位于运行队列:bash-2.03$vmstat3procsmemorypagediskfaultscpurbwswapfreeremfpipofrdesrs6s9s1sdinsycsussyid0005504232146411200000000110429496719600-84-5-14513100536807215183605669102200010030117918279597301

2、310053773281522464817190220001002766801925779640130005382400152477667682000000000357085343316973013400537361615205121271078022000100383895843623964013600536939215184961079240550000002920857326399730132005364912151622463578000000000335879443119973012900535864815117121891236000000000336610365313595

3、501290053545281511304120119400000004032358864291196401280053468481507704998230000000303189904830749640125005341248150470480843022000610356395143314955013300533274415011127979800000001032188805290297301290053253841497368107643022000140318482972879964012600536314415143208175300000000025337409216497

4、30136005355624151051216956678600000010300286002810964013010535144815029362675801821000000003126781229009640129005347256149956815591322200001022258076194198201160053381921495400177116200000001019477781163997302.使用Top命令观察进程CPU耗用,发现没有明显过高CPU使用的进程$toplastpid:28313;loadaverages:99.90,117.54,125.7123:2

5、8:38296processes:186sleeping,99running,2zombie,9oncpuCPUstates:0.0%idle,96.5%user,3.5%kernel,0.0%iowait,0.0%swapMemory:4096Mreal,1404Mfree,2185Mswapinuse,5114MswapfreePIDUSERNAMETHRPRINICESIZERESSTATETIMECPUCOMMAND27082oracle8i13301328M1309Mrun0:171.29%oracle26719oracle8i15501327M1306Msleep0:291.

6、11%oracle28103oracle8i13501327M1304Mrun0:061.10%oracle28161oracle8i12501327M1305Mrun0:041.10%oracle26199oracle8i14501328M1309Mrun0:421.10%oracle26892oracle8i13301328M1310Mrun0:241.09%oracle27805oracle8i14501327M1306Mcpu/10:101.04%oracle23800oracle8i12301327M1306Mrun1:281.03%oracle25197oracle8i134

7、01328M1309Mrun0:571.03%oracle21593oracle8i13301327M1306Mrun2:121.01%oracle27616oracle8i14501329M1311Mrun0:141.01%oracle27821oracle8i14301327M1306Mrun0:101.00%oracle26517oracle8i13301328M1309Mrun0:330.97%oracle25785orac