Home | 簡體中文 | 繁體中文 | 雜文 | 知乎專欄 | Github | OSChina 博客 | 雲社區 | 雲棲社區 | Facebook | Linkedin | 視頻教程 | 打賞(Donations) | About
知乎專欄多維度架構

13.3. 查看錯誤代碼

		
mysql> \! perror 6
OS error code   6:  No such device or address
		
		

13.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes

max_allowed_packet=500M
			

13.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

連接在中途被中斷了的連接請求。在 max_connect_errors次失敗請求後,mysql阻止該主機進一步的連接,直到管理員執行命令 mysqladmin flush-hosts。

			
mysql> flush hosts;
			
			
set global max_connect_errors=1000;
			
max_connect_errors=10000