Resque Mysql2 ::错误：用户已超出'max_user_connections'资源（当前值：10） [英] Resque Mysql2::Error: User has exceeded the 'max_user_connections' resource (current value: 10)

问题描述

我在Heroku上运行Resque，而我的数据库是ClearDB。我得到这个错误：
$ b

Mysql2 ::错误：用户'bdb2aedbee2c38'已超过'max_user_connections'资源（当前值：10）：SHOW FULL FIELDS FROM projects

该错误来自我的Heroku应用程序的Resque管理员。

如何判断Resque对ClearDB的连接数？

如何告诉ClearDB或者允许更多的连接，或者告诉Resque创建更少？

当前值：10是指ClearDB允许的连接数量，或者是多少个当前连接Resque试图做出什么？

谢谢！

解决方案

服务器dynos或Resque工作人员消耗的连接数量超出数据库计划提供的数量。

您有两种选择：

• 通过升级到更高的ClearDB计划来扩展数据库（ http://dashboard.heroku.com ）


• 通过减少dynos / workers的数量来缩小应用程序（ heroku ps：scale 命令）
>

当我将你的插件链接到描述服务的页面时，第一个链接d定价层次。您位于免费的10个连接层。

https： //addons.heroku.com/cleardb

I am running Resque on Heroku, and my database is ClearDB. I am getting this error:

"Mysql2::Error: User 'bdb2aedbee2c38' has exceeded the 'max_user_connections' resource (current value: 10): SHOW FULL FIELDS FROM projects"

That error is coming from my Resque admin of my Heroku app.

How can I figure out how many connections Resque is making to ClearDB?

How can I tell ClearDB to either allow more connections, or tell Resque to create less?

Does "current value: 10" refer to how many connections ClearDB is allowing, or is this how many current connections Resque is trying to make?

Thanks!

解决方案

Your application server dynos or Resque workers are consuming more connections than your database plan provides.

You have two options:

• Scale up your database by upgrading to a higher ClearDB plan (http://dashboard.heroku.com)
• Scale down your application by reducing the number of dynos/workers (heroku ps:scale command)

The first link when I googled your addons links to the page describing the service and pricing tiers. You are on the free, 10 connection tier.

https://addons.heroku.com/cleardb

这篇关于Resque Mysql2 ::错误：用户已超出'max_user_connections'资源（当前值：10）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！