Willem Bison a écrit :
>
> When we increase the number of connections our 3.22.25 server 'hangs':
>
> mysql> show status;
> No connection. Trying to reconnect...
> ERROR 1129: Host 'xxx is blocked because of many connection er
> rors. Unblock with 'mysqladmin flush-hosts'
> ERROR: Can't connect to the server
>
> This happens when we increase MaxClients on the Apache webserver from 200 to
> 220 resulting in more queries to the db-server. After a few hours the
> db-server hangs with the above error. DB and apache server run on different
> machines.
> Apache talks with mysql through PHP 4.0.41/ZendOptimizer/Cache.
> The max connections on the db-server is set to 400.
> Linux.
>
> More info (after restarting mysql):
> mysql> show status;
> +--------------------------+----------+
> | Variable_name | Value |
> +--------------------------+----------+
> | Aborted_clients | 0 |
> | Aborted_connects | 671 |
> | Created_tmp_tables | 31067 |
> | Delayed_insert_threads | 0 |
> | Delayed_writes | 0 |
> | Delayed_errors | 0 |
> | Flush_commands | 1 |
> | Handler_delete | 221 |
> | Handler_read_first | 23 |
> | Handler_read_key | 1413111 |
> | Handler_read_next | 26516553 |
> | Handler_read_rnd | 4318261 |
> | Handler_update | 85123 |
> | Handler_write | 182257 |
> | Key_blocks_used | 15641 |
> | Key_read_requests | 6039569 |
> | Key_reads | 50309 |
> | Key_write_requests | 3213 |
> | Key_writes | 3005 |
> | Max_used_connections | 222 |
> | Not_flushed_key_blocks | 0 |
> | Not_flushed_delayed_rows | 0 |
> | Open_tables | 63 |
> | Open_files | 6 |
> | Open_streams | 0 |
> | Opened_tables | 6547 |
> | Questions | 361413 |
> | Running_threads | 220 |
> | Slow_queries | 6 |
> | Uptime | 2048 |
> +--------------------------+----------+
> 30 rows in set (0.00 sec)
>
> Anyone have a clue whats going on ?
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi,
I had the same problem.
MySQL blocked all connections from our web server frontend when
Apache was restarted at midnight (log files rotation).
I "solved" it with :
set-variable = max_connect_errors=2000000000
in my.cnf
You should also run 'mysqladmin flush-hosts' periodically (with cron).
Hope this help
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php