openstack Mysql 1040, 'Too many connections' 问题

  1. 云栖社区>
  2. 博客>
  3. 正文

openstack Mysql 1040, 'Too many connections' 问题

科技小能手 2017-11-12 02:36:00 浏览906
展开阅读全文

[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


网友评论

登录后评论
0/500
评论