发表于 2009-1-5 19:48
| 
娣卞湷璁ぉ mysql 鏈嶅姟鍣ㄩ敊璇垎鏋愭枃妗
鍙戝竷: 2008-7-01 09:36 | 浣滆: admin | 鏌ョ湅: 3娆
娣卞湷璁ぉ mysql 鏈嶅姟鍣ㄩ敊璇垎鏋愭枃妗
鐑
銆愬瓧浣擄細灏 澶с
娣卞湷璁ぉ mysql 鏈嶅姟鍣ㄩ敊璇垎鏋愭枃妗
浣滆咃細涓嶈 鏂囩珷鏉ユ簮锛氱綉缁 鐐瑰嚮鏁帮細1141 鏇存柊鏃堕棿锛2007-1-21 
1.鏁呴殰鐘舵佹弿杩
鑷繁鍦ㄥ仛鍘嬪姏娴嬭瘯鍑虹幇濡備笅鐜拌薄:
MySql-uroot-p
Enterpassword:
ERROR1135:Cantcreateanewthread(errno11).Ifyouarenotoutofavailablememory,
youcanconsultthemanualforapossibleOS-dependentbug
[@rhas31]$perror11
Systemerror:11=Resourcetemporarilyunavailable
MySql鍛戒护琛屾棤娉曡繛鎺ユ暟鎹簱
ps-efw|grepMySql|wc
89113354204625
MySql骞跺彂杩炴帴鏁伴噺杈冨ぇ,鏈890涓.
[root@var]#free
totalusedfreesharedbufferscached
Mem:2061584204356818016013864293192
-/+buffers/cache:1736512325072
Swap:20402123466601693552
铏氭嫙鍐呭瓨宸茬粡浣跨敤浜嗙害350M
鏁版嵁搴撻敊璇棩蹇楁病鏈夊紓甯哥殑閿欒璁板綍.
05031512:01:33MySqldstarted
/app/mysql-4.0.23a/libexec/mysqld:readyforconnections.
Version:4.0.23asocket:/tmp/mysql.sockport:3306Sourcedistribution
05032311:58:10mysqldstarted
/app/mysql-4.0.23a/libexec/mysqld:readyforconnections.
Version:4.0.23asocket:/tmp/mysql.sockport:3306Sourcedistribution
05032313:10:53mysqldstarted
/app/mysql-4.0.23a/libexec/mysqld:readyforconnections.
Version:4.0.23asocket:/tmp/mysql.sockport:3306Sourcedistribution
05032313:10:54/app/mysql-4.0.23a/libexec/mysqld:Cantopenfile:ujoin.MYI.(errno:
145)
top鍛戒护鏄剧ず姝ｅ父,mysql鍦ㄦ甯歌繍琛,浣嗙▼搴忓憳鍙嶆槧绋嬪簭鎵ц鎱.
2.鏁呴殰鍘熷洜鍒嗘瀽
搴斾负鏃犳硶鐢ㄥ懡浠よ杩炴帴涓婃暟鎹簱,鎵浠ユ棤娉曞緱鐭ュ綋鏃秙ql璇彞鐨勬墽琛屾儏鍐.
鍒濇鍒嗘瀽鏄湁閮ㄥ垎sql璇彞鏁堢巼涓嶉珮鎵鑷.
鍏充簬mysql杩炴帴鏃剁殑鎶ラ敊淇℃伅,鎴戜滑鏇剧粡鍦╰urbolinuxHAmysql鏁版嵁搴撳仛鍘嬪姏娴嬭瘯鐨勬椂鍊欓亣鍒拌繃,
鍚庢潵璺焧urbolinux鑱旂郴,鍗囩骇glibc鍚庤В鍐崇殑.
*WedApr212004Yangxiaoxin
-2.2.5-18
-Thread:modifiedPTHREAD_THREADS_MAXandSTACK_SIZEforhuawei
鍒濇鍒嗘瀽,姝ゆ閿欒涓巊libc鐨勭増鏈篃鏈夊叧绯.
3.鏁呴殰澶勭悊杩囩▼
ps-efw|grepmysql|awk{print$2}>/tmp/1.txt
鍚庝娇鐢╧ill鍛戒护灏唌ysql鏉姝.
鍐嶆墜宸ユ墽琛屽惎鍔ㄦ搷浣滃悗,鏁版嵁搴撴湇鍔″櫒鎭㈠姝ｅ父
4.鏁呴殰澶勭悊缁撴灉
灏唌ysql鏈澶ц繛鎺ユ暟璋冨皬鍒800
鍗囩骇glibc鐩稿叧杞欢鍖呭埌鏈鏂扮殑绋冲畾鐗
[root@i386rpm]#ls
glibc-2.3.2-95.30.i386.rpmglibc-debuginfo-2.3.2-95.30.i386.rpm
glibc-headers-2.3.2-95.30.i386.rpm
glibc-common-2.3.2-95.30.i386.rpmglibc-debuginfo-common-2.3.2-95.30.i386.rpm
glibc-profile-2.3.2-95.30.i386.rpm
glibc-debug-2.3.2-95.30.i386.rpmglibc-devel-2.3.2-95.30.i386.rpm
glibc-utils-2.3.2-95.30.i386.rpm
[root@i386rpm]#rpm-Fvh*.rpm
Preparing...###########################################[100%]
1:glibc-common###########################################[17%]
2:glibc###########################################[33%]
Stoppingsshd:[OK]
sleep:relocationerror:/lib/i686/librt.so.1:symbol__pthread_clock_settime,version
GLIBC_PRIVATEnotdefinedinfilelibpthread.so.0withlinktimereference
Startingsshd:[OK]
3:glibc-headers###########################################[50%]
4:glibc-devel###########################################[67%]
5:glibc-profile###########################################[83%]
6:glibc-utils###########################################[100%]
[璐ｄ换缂栬緫:鐢佃剳鎶宸
