openstack Mysql 1040, 'Too many connections' 问题
[root@athController ~]# nova list
ERROR: An unexpected error prevented the server from fulfilling your request. (OperationalError) (1040, 'Too many connections') None None (HTTP 500)
解决办法：
key_buffer = 64M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 64M
log_error = /var/log/mysqld.log
expire_logs_days = 10
max_binlog_size = 100M
max_connections = 1000
[root@athController ~]# nova list
+--------------------------------------+---------------------------------------------------+--------+------------+-------------+-----------------------------------------+
| ID | Name | Status | Task State | Power State | Networks |
+--------------------------------------+---------------------------------------------------+--------+------------+-------------+-----------------------------------------+
| d4965275-f152-482c-9669-a54c90e0ec9b | 2222 | ACTIVE | - | Running | publics=10.14.22.21; private=10.14.8.21 |
| 966aee59-3b6c-44b5-bccb-ee671dd8b999 | 3-windows-cn-966aee59-3b6c-44b5-bccb-ee671dd8b999 | ACTIVE | - | Running | publics=10.14.22.5; private=10.14.8.6 |
| da60e9f7-009a-43c0-bf69-7999692d81ed | 333-da60e9f7-009a-43c0-bf69-7999692d81ed | ACTIVE | - | Running | publics=10.14.22.8; private=10.14.8.8 |
| b936d13d-d28a-45b7-880e-dfadac17f0b9 | 3333 | ACTIVE | - | Running | publics=10.14.22.11; private=10.14.8.11 |
| 08f5e6c2-d49a-4ded-a901-7bc21d474b2a | ASF | ACTIVE | - | Running | publics=10.14.22.9; private=10.14.8.9 |
本文转自 swq499809608 51CTO博客，原文链接:http://blog.51cto.com/swq499809608/1542315
