Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL2 prevent from Rails migration

I am trying to run heroku rake db:seed for my Rails app in Heroku. It has a lot of queries involve. I got this error message:

rake aborted!
Mysql2::Error: User '222ad0ef2670fe' has exceeded the 'max_questions' resource 
(current value: 3600)

What does current value 3600 means? (queries/hours?) and how can I change it to, say, 10,000?

Thank you.

like image 593
AdamNYC Avatar asked Mar 16 '26 08:03

AdamNYC


1 Answers

The reason for the error is you have reached max number of queries per hour. In this case you can wait an hour if you're in developer mode or upgrade your plan.

View the corresponding FAQ

I'm getting an error message saying that I have exceeded the 'max_questions' resource for my database. What can I do?

The max_questions resource is defined by how many queries you may issue to your database in an hour. Our free plans start with 3,600 queries per hour and increase to 18,000 upon purchasing a paid plan with us. Larger plans have larger QPH limits. We recommend that you upgrade your database with us to lift this limitation off of your database

.

like image 62
Carlos Vásquez Polanco Avatar answered Mar 18 '26 21:03

Carlos Vásquez Polanco