I am running Resque on Heroku, and my database is ClearDB. I am getting this error:
我在Heroku上运行Resque,我的数据库是ClearDB。我得到了这个错误:
"Mysql2::Error: User 'bdb2aedbee2c38' has exceeded the 'max_user_connections' resource (current value: 10): SHOW FULL FIELDS FROM projects
"
“Mysql2::错误:用户的bdb2aedbee2c38”已经超过了“max_user_connections”的资源(当前值:10):显示来自项目的完整字段。
That error is coming from my Resque admin of my Heroku app.
这个错误来自我的Heroku应用的管理员Resque。
How can I figure out how many connections Resque is making to ClearDB?
我怎么知道Resque有多少连接到ClearDB?
How can I tell ClearDB to either allow more connections, or tell Resque to create less?
我如何告诉ClearDB允许更多的连接,或者告诉Resque创建更少的连接?
Does "current value: 10" refer to how many connections ClearDB is allowing, or is this how many current connections Resque is trying to make?
“当前值:10”是指ClearDB允许的连接数量,还是这是Resque尝试建立的当前连接数量?
Thanks!
谢谢!
1 个解决方案
#1
4
Your application server dynos or Resque workers are consuming more connections than your database plan provides.
您的应用服务器dynos或Resque工作人员消耗的连接比您的数据库计划提供的要多。
You have two options:
你有两个选择:
- Scale up your database by upgrading to a higher ClearDB plan (http://dashboard.heroku.com)
- 通过升级到更高的ClearDB计划来扩展数据库(http://dashboard.heroku.com)
- Scale down your application by reducing the number of dynos/workers (
heroku ps:scale
command) - 通过减少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.
第一个链接,当我谷歌你的插件链接到描述服务和定价层的页面。你在免费的,10连接层。
https://addons.heroku.com/cleardb
https://addons.heroku.com/cleardb
#1
4
Your application server dynos or Resque workers are consuming more connections than your database plan provides.
您的应用服务器dynos或Resque工作人员消耗的连接比您的数据库计划提供的要多。
You have two options:
你有两个选择:
- Scale up your database by upgrading to a higher ClearDB plan (http://dashboard.heroku.com)
- 通过升级到更高的ClearDB计划来扩展数据库(http://dashboard.heroku.com)
- Scale down your application by reducing the number of dynos/workers (
heroku ps:scale
command) - 通过减少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.
第一个链接,当我谷歌你的插件链接到描述服务和定价层的页面。你在免费的,10连接层。
https://addons.heroku.com/cleardb
https://addons.heroku.com/cleardb