灏忚眴缃

 鎵惧洖瀵嗙爜
 绔嬪嵆娉ㄥ唽
鎼滅储

mysqld-nt.exe 鍗燾pu楂樺鐞

[澶嶅埗閾炬帴]
鍙戣〃浜 2018-9-13 20:30:24 | 鏄剧ず鍏ㄩ儴妤煎眰 |闃呰妯″紡
mysqld-nt.exe 鍗燾pu楂樺鐞
                        濡傛灉鏈嶅姟鍣ㄧ殑mysqld-nt.exe 鍗燙PU寰堥珮
2012-03-01 13:20
濡傛灉鏈嶅姟鍣ㄧ殑mysqld-nt.exe鍗燙PU寰堥珮锛屼竴鑸槸鍥犱负MYSQL鐨勬暟鎹簱涓湁鏁版嵁杩涜閲囬泦锛屾垨鑰呮槸鏁版嵁搴撳嚭鐜伴棶棰樸傝瀵熷姙娉曟槸锛氫娇鐢╬hpmyadmin杩涜瑙傚療锛屽湪phpmyadmin 鈥滆繘绋嬧濅腑鏌ョ湅鍦ㄧ嚎鐨勬暟鎹簱锛岀偣鍑籏ill鍒犻櫎鍙枒鐨勮繘绋嬶紝濡傛灉鍒犻櫎浜嗗嚭閿欐暟鎹簱mysqld-nt.exe鎵鍗犵殑CPU浼氶┈涓婁笅闄嶃

鍙戠幇鏁版嵁搴撳悗鍙互杩涜淇锛屾垨鑰呯姝㈣鐢ㄦ埛浣跨敤璇ユ暟鎹簱銆備竴鑸珻PU杩囬珮鏄洜涓鸿鐢ㄦ埛鐢熸垚闈欐佹垨鑰呰繘琛岄噰闆嗐傝屾帶鍒剁▼搴忔睜鏃犳硶瑙e喅鏁版嵁搴揅PU杩囬珮鐨勯棶棰橈紝涓嶇煡閬撴湁浠涔堝ソ鍔炴硶鍙互鎺у埗鏌愪釜鏁版嵁搴撳崰鏁版嵁搴揅PU銆

UPdate:鍙戠幇璇ユ暟鎹簱鏈夐棶棰橈紝宸茬粡鍏抽棴璇ョ敤鎴凤紝涓鍒囨仮澶嶆甯搞

1.寮濮 = 杩愯cmd   
鍋囪浣犵殑mysql鍦―:\wamp\bin\mysql\mysql5.5.8\bin杈撳叆浠ヤ笅鍛戒护锛
1. d:
2. cd wamp
3. cd bin
4. cd mysql
5. cd mysql5.5.8
6. cd bin
灏变細杩涘叆mysql鎵鍦ㄧ▼搴
杈撳叆 mysql -uroot -padmin杩涘叆mysql鎺у埗鍙
杈撳叆  mysql> show processlist;
鏌ヨ鐜板湪mysql鍦ㄥ共浠涔堛
鎸夊悜涓婄澶 鍦ㄦ煡璇竴杈癸紝鐪嬪摢涓暟鎹簱鏌ヨ鐨勮鍙ユ瘮杈冮绻侊紒
涓鑸槸鐫$湢杩炴帴杩囧锛屼弗閲嶆秷鑰梞ysql鏈嶅姟鍣ㄨ祫婧(涓昏鏄痗pu, 鍐呭瓨)锛屽苟鍙兘瀵艰嚧mysql宕╂簝銆
mysql鐨勯厤缃甿y.ini鏂囦欢涓紝鏈変竴椤癸細
wait_timeout, 鍗冲彲璁剧疆鐫$湢杩炴帴瓒呮椂绉掓暟锛屽鏋滄煇涓繛鎺ヨ秴鏃讹紝浼氳mysql鑷劧缁堟銆
濡傝缃細銆
wait_timeout=100#鍗宠缃甿ysql杩炴帴鐫$湢鏃堕棿涓100绉掞紝浠讳綍sleep杩炴帴鐫$湢鏃堕棿鑻ヨ秴杩100绉掞紝灏嗕細琚玬ysql鏈嶅姟鑷劧缁堟锛岃姣旂紪鍐檚hell鑴氭湰鏇寸畝鍗曘
瀵逛簬姝e湪杩愯涓殑鐢熶骇鏈嶅姟鍣
浠oot鐢ㄦ埛鐧诲綍鍒癿ysql,鎵ц锛
set global wait_timeout=100
鍗冲彲銆

                                                                       


鍥炲

浣跨敤閬撳叿 涓炬姤

楂樼骇妯″紡
B Color Image Link Quote Code Smilies

鏈増绉垎瑙勫垯

QQ|Archiver|鎵嬫満鐗|灏忛粦灞|灏忚眴缃 ( 妗侷CP澶10003008鍙-3 )

GMT+8, 2019-3-24 08:52 , Processed in 0.103576 second(s), 22 queries .

广西网警虚拟岗亭
蹇熷洖澶 杩斿洖椤堕儴 杩斿洖鍒楄〃