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