2台机器(各自有mysql)发现 一台机器访问另外一台 ost '*****' is blocked because of many connection errorsa(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机器上解决???)

解决方案 »

  1.   


    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 shutdown081215  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 complete081215 07:31:32  mysqld ended081215 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 shutdown081219  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 complete081219 02:23:06  mysqld ended081219 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 shutdown081219 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 complete081219 11:06:34  mysqld ended081219 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 shutdown090603  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 complete090603 06:18:38  mysqld ended090603 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 shutdown090603  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 complete090603 06:55:16  mysqld ended090603 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 shutdown090603  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 complete090603 09:45:37  mysqld ended090603 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 shutdown100510 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 complete100510 13:13:01  mysqld ended100510 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
      

  2.   

    /usr/libexec/mysqld: Disk is full writing './oddsmatrixo磁盘空间满了? 
      

  3.   

    不是空间 问题   du df 观察发现空间利用率并不高的 
      

  4.   

    我的当前环境 linux centos5  +mysql +apache+java
    半个月发现java的cpu占据总是99%
    与mysql跟定没有关系  (我重启mysql无数次 最好把mysql的数据库表减少到只留下结构)java耗内存 cpu是肯定,但是这个应用在当前的硬件下是没有问题的
    后来我用命令 du -sh /root
    突然发现这台机器的   /root的剩余空间只有1.3m  请问是否这个实在太小 ,这台机器的 交换空间是很大 的 有2g ,当前交换分区 利用率非常低我的问题
    1 原因是否与 /root的剩余空间太小有关
    2 如果解决  (是否一定要快大/root的剩余空间)
      

  5.   

    ERROR 1129 (00000): Host 'stage2b' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'---------------------
    这里有提示了,你有试了吗?
    在11上执行flush hosts试下嘛
      

  6.   

    或者增加参数"max_connect_errors"的值试下