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
