'*****' is blocked because of many connection errors

lilinew 2010-05-10 08:16:31
2台机器（各自有mysql）

发现 一台机器访问另外一台 ost '*****' is blocked because of many connection errors

a（11 ） 11 上建立了22的访问帐号a/a
b （22）

22机器上 mysql -h192...11 -ua -pa
结果提示错误如下
ERROR 1129 (00000): Host 'stage2b' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

不知道如何才鞥你解决这个问题 （我已经重启22 还是出现相同的错误 如何在11机器上解决？？？）
...全文
1031 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
vinsonshen 2010-05-12
  • 打赏
  • 举报
 回复
或者增加参数"max_connect_errors"的值试下
vinsonshen 2010-05-12
  • 打赏
  • 举报
 回复
ERROR 1129 (00000): Host 'stage2b' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

---------------------
这里有提示了,你有试了吗?


在11上执行flush hosts试下嘛
lilinew 2010-05-12
  • 打赏
  • 举报
 回复
我的当前环境 linux centos5 +mysql +apache+java
半个月发现java的cpu占据总是99%
与mysql跟定没有关系 （我重启mysql无数次 最好把mysql的数据库表减少到只留下结构）

java耗内存 cpu是肯定，但是这个应用在当前的硬件下是没有问题的
后来我用命令 du -sh /root
突然发现这台机器的 /root的剩余空间只有1.3m

请问是否这个实在太小 ，这台机器的 交换空间是很大 的 有2g ，当前交换分区 利用率非常低

我的问题
1 原因是否与 /root的剩余空间太小有关
2 如果解决 （是否一定要快大/root的剩余空间）
lilinew 2010-05-11
  • 打赏
  • 举报
 回复
不是空间 问题 du df 观察发现空间利用率并不高的
lilinew 2010-05-11
  • 打赏
  • 举报
 回复
后来重启db解决问题了

现在犹豫是否要 整理磁盘空间 ？？
iihero_ 2010-05-10
  • 打赏
  • 举报
 回复
/usr/libexec/mysqld: Disk is full writing './oddsmatrixo

磁盘空间满了？
lilinew 2010-05-10
  • 打赏
  • 举报
 回复
没有其他的
ACMAIN_CHM 2010-05-10
  • 打赏
  • 举报
 回复
有没有普通日志？
lilinew 2010-05-10
  • 打赏
  • 举报
 回复

081120 21:07:54 [ERROR] /usr/libexec/mysqld: Disk is full writing './oddsmatrixo ddsdb/PopularMatch.MYD' (Errcode: 28). Waiting for someone to free space... Retr y in 60 secs
081120 21:17:54 [ERROR] /usr/libexec/mysqld: Disk is full writing './oddsmatrixo ddsdb/PopularMatch.MYD' (Errcode: 28). Waiting for someone to free space... Retr y in 60 secs
081120 21:27:54 [ERROR] /usr/libexec/081215 7:31:13 [Note] /usr/libexec/mysqld: Normal shutdown

081215 7:31:13 InnoDB: Starting shutdown...
081215 7:31:32 InnoDB: Shutdown completed; log sequence number 3 705146694
081215 7:31:32 [Note] /usr/libexec/mysqld: Shutdown complete

081215 07:31:32 mysqld ended

081215 07:31:33 mysqld started
081215 7:31:56 InnoDB: Started; log sequence number 3 705146694
081215 7:31:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
081219 2:22:44 [Note] /usr/libexec/mysqld: Normal shutdown

081219 2:22:44 InnoDB: Starting shutdown...
081219 2:23:06 InnoDB: Shutdown completed; log sequence number 3 2413017480
081219 2:23:06 [Note] /usr/libexec/mysqld: Shutdown complete

081219 02:23:06 mysqld ended

081219 02:24:15 mysqld started
081219 2:24:22 InnoDB: Started; log sequence number 3 2413017480
081219 2:24:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
081219 11:06:11 [Note] /usr/libexec/mysqld: Normal shutdown

081219 11:06:13 InnoDB: Starting shutdown...
081219 11:06:33 InnoDB: Shutdown completed; log sequence number 3 2967738344
081219 11:06:33 [Note] /usr/libexec/mysqld: Shutdown complete

081219 11:06:34 mysqld ended

081219 11:10:42 mysqld started
081219 11:14:50 InnoDB: Started; log sequence number 3 2967738344
081219 11:14:52 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
090603 5:18:05 [Note] /usr/libexec/mysqld: Normal shutdown

090603 5:18:06 InnoDB: Starting shutdown...
090603 5:18:38 InnoDB: Shutdown completed; log sequence number 23 759835569
090603 5:18:38 [Note] /usr/libexec/mysqld: Shutdown complete

090603 06:18:38 mysqld ended

090603 06:21:31 mysqld started
090603 6:21:55 InnoDB: Started; log sequence number 23 759835569
090603 6:21:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
090603 6:55:13 [Note] /usr/libexec/mysqld: Normal shutdown

090603 6:55:13 InnoDB: Starting shutdown...
090603 6:55:16 InnoDB: Shutdown completed; log sequence number 23 947066176
090603 6:55:16 [Note] /usr/libexec/mysqld: Shutdown complete

090603 06:55:16 mysqld ended

090603 06:57:35 mysqld started
090603 6:58:56 InnoDB: Started; log sequence number 23 947066176
090603 6:58:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
090603 9:45:34 [Note] /usr/libexec/mysqld: Normal shutdown

090603 9:45:34 InnoDB: Starting shutdown...
090603 9:45:37 InnoDB: Shutdown completed; log sequence number 23 1061855427
090603 9:45:37 [Note] /usr/libexec/mysqld: Shutdown complete

090603 09:45:37 mysqld ended

090603 09:46:39 mysqld started
090603 9:46:43 InnoDB: Started; log sequence number 23 1061855427
090603 9:46:44 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
100510 13:12:39 [Note] /usr/libexec/mysqld: Normal shutdown

100510 13:12:40 InnoDB: Starting shutdown...
100510 13:13:00 InnoDB: Shutdown completed; log sequence number 53 3150213167
100510 13:13:00 [Note] /usr/libexec/mysqld: Shutdown complete

100510 13:13:01 mysqld ended

100510 13:13:21 mysqld started
100510 13:13:23 InnoDB: Started; log sequence number 53 3150213167
100510 13:13:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
ACMAIN_CHM 2010-05-10
  • 打赏
  • 举报
 回复
看一下日志？
微软内部资料-SQL性能优化3
Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...
远程连接服务器数据库报错：Host ‘XXXXXX’ is blocked because of many connection errors
 使用Navicat for mysql连接公司的服务器数据库，报错：Host ‘XXXXXX’ is blocked because of many connection errors 二、出现错误原因  同意ip在短时间内产生太多（超过mysql数据库max_connection_errors的...
解决MySql Host is blocked because of many connection errors 方法
错误：Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'   原因： 　同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库...
解决：mysql is blocked because of many connection errors；
问题：在启动一个jar包项目的时候出现SQL报错原因：是同一IP的connection errors超出默认的最大值了。解决方法1最简单的方法重启mysql服务即可。解决方法2：最简单的方法通过命令行进行mysql控制台。解决方法3：修改...
“blocked because of many connection errors”问题解决
SQLSTATE[HY000] [1129] Host 'xx.xx.xx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 注：'xx.xx.xx.xx'是IP地址 提示比较清楚，就是connection errors太多导致...
MySQL

56,677

社区成员

56,708

社区内容

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章