Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | 51CTO学院 | CSDN程序员研修院 | OSChina 博客 | 腾讯云社区 | 阿里云栖社区 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏多维度架构

13.2. 查看错误代码

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

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

				max_allowed_packet=500M
			

13.2.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