å¦ä½å®æ¶æ¥çmysqlå½åè¿æ¥æ°?
1ãæ¥çå½åææè¿æ¥ç详ç»èµæ:
./mysqladmin -uadmin -p -h10.140.1.1 processlist
2ãåªæ¥çå½åè¿æ¥æ°(Threadså°±æ¯è¿æ¥æ°.):
./mysqladmin -uadmin -p -h10.140.1.1 status
ãæ¥çå½åææè¿æ¥ç详ç»èµæ:
mysqladmin -uroot -proot processlist
D:\MySQL\bin>mysqladmin -uroot -proot processlist
+-----+------+----------------+---------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+----------------+---------+---------+------+-------+------------------+
| 591 | root | localhost:3544 | bbs | Sleep | 25 | | |
| 701 | root | localhost:3761 | | uery | 0 | | show processlist |
+-----+------+----------------+---------+---------+------+-------+------------------+
2ãåªæ¥çå½åè¿æ¥æ°(Threadså°±æ¯è¿æ¥æ°.):
mysqladmin -uroot -proot status
D:\MySQL\bin>mysqladmin -uroot -proot status
Uptime: 2102 Threads: 3 Questions: 15531 Slow queries: 0 Opens: 0 Flush tab
les: 1 Open tables: 61 Queries per second avg: 7.389
3ãä¿®æ¹mysqlæ大è¿æ¥æ°ï¼
æå¼my.iniï¼ä¿®æ¹max_connections=100(é»è®¤ä¸º100)ã
ä»å¤©æä¸å°mysqlæå¡å¨çªç¶è¿æ¥æ°æ´å¢ï¼å¹¶ä¸çå¾
è¿ç¨å
¨é¨è¢«é...å 为é®é¢è§£å³ä¸å½ï¼å¯¼è´è¢«éª...OTL
æ»ç»ï¼ä»¥åè¦å¿«éå®ä½é误ï¼å¸ç½®è§£å³æ¹æ¡
ç»å½å°mysql客æ·ç«¯åï¼ä½¿ç¨statuså½ä»¤ä¹è½è·å¾threadè¿æ¥æ°ä»¥åå½åè¿æ¥çid
æè
ç¨
show full processlist
çä¸ä¸ææè¿æ¥è¿ç¨ï¼æ³¨ææ¥çè¿ç¨çå¾
æ¶é´ä»¥åæå¤ç¶æ æ¯å¦locked
å¦æè¿ç¨è¿å¤ï¼å°±æè¿ç¨æå°ä¸æ¥ï¼ç¶åæ¥ç
mysql -e 'show full processlist;' > 111
æ¥æ¾élockedçè¿ç¨ï¼ä¸è¬å°±æ¯å½åæ§è¡ä¸å¡æ»ï¼å¯¼è´åé¢çè¿ç¨æéçåå ã
å¦å¤ï¼ä¿®æ¹mysqlæ大è¿æ¥æ°çæ¹æ³ï¼
ç¼è¾MySQL(åPHPæé
ä¹æä½³ç»å)é
ç½®æ件ã
my.cnf æè
æ¯ my.ini
å¨[MySQL(åPHPæé
ä¹æä½³ç»å)d]é
置段添å ï¼
max_connections = 1000
ä¿åï¼éå¯MySQL(åPHPæé
ä¹æä½³ç»å)æå¡ã
ç¶åç¨å½ä»¤ï¼
MySQL(åPHPæé
ä¹æä½³ç»å)admin -uroot -p variables
è¾å
¥rootæ°æ®åºè´¦å·çå¯ç åå¯çå°
| max_connections | 1000 |
æ¥çMySQLè¿æ¥æ°åå½åç¨æ·Mysqlè¿æ¥æ°
å
ç¨ç®¡çå身份è¿å
¥mysqlæ示符ã
#mysql -uroot -pxxxx
mysql> show processlist; å¯ä»¥æ¾ç¤ºå100æ¡è¿æ¥ä¿¡æ¯ show full processlist; å¯ä»¥æ¾ç¤ºå
¨é¨ãé便说ä¸ï¼å¦æç¨æ®éè´¦å·ç»å½ï¼å°±åªæ¾ç¤ºè¿ç¨æ·çã注æå½ä»¤åæåå·ã
å¦ææ们æ³æ¥çè¿å°æå¡å¨è®¾ç½®ã #vi /etc/my.cnf
set-variable=max_user_connections=30 è¿ä¸ªå°±æ¯åç¨æ·çè¿æ¥æ°
set-variable=max_connections=800 è¿ä¸ªæ¯å
¨å±çéå¶è¿æ¥æ°
温馨提示:答案为网友推荐,仅供参考