openstack Mysql 1040, 'Too many connections' 問題

標籤：mysql   nova   nova list   openstack   

[[email protected] ~]# 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

[[email protected] ~]# 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   |

本文出自 “歡迎評論，歡迎點贊” 部落格，轉載請與作者聯絡！