MAX QUERIES PER HOUR exceeded

Community support
#21

Yes, mysqli is a query,
INSERT, UPDATE, SELECT, DELETE are queries.

#22

Thanks. I dont use 12000 queries to select 12000 messagers from database. My system is based on conversation-modal. It selects maximum 50 messages when user requests messages for the frist time. Select 50 messages is only one query. After that real time chat may make about 5 queries to database per a request. If we send 1000 messages it will make about 1500 reequests(Its how my systems based with core features).

So, if we send 1000 messages we will only have 7500 queries. But from the beginning there were only 12,000 messages. (From january). And any user doesnot use this app because it automatically redirects to the coming soon page.

#23

It selects maximum 50 messages when user requests messages for the frist time.

What else it selects? The message time, user ID, etc as well?

#24

Yes. It selects all the colomns except id colomn

#25

Are you retrieving each row separately (separate functions) or all at once (mysqli_fetch_all())?

#26

I retrieve them at once. Just one query to select all the colomns.

Like : "SELECT x,y,z FROM mydatabase WHERE a=0
 "

In simple words its just one query

#27

Please consider using SELECT * FROM ...

I don’t know how MySQL treats each query: if it decompose it into basic commands or something else.

#28

I’ll try it.
But until last friday i hadnt got this problem, even i had about 11,000 rows in that table. I checked my website’s messaging system with sending about 500 messages on thursday. I didnt get any problem. But now i have this.

#29

Probably the admins change the policy of the database. I am not sure. If this is the case, it won’t be reverted soon


In any case: this has nothing to do with domain pointing.

#30

I have no idea what to do.
I’ll check my scripts again

#31

You see 15000 queries per hour, but actually in our systems, it is 5000 queries per hour.
If you really need more, consider upgrading to not worry anymore about the limitations!

#32

Even i didn’t run any query in this hour database server shows that “#1226 - User ‘id1033491_hello_user’ has exceeded the ‘max_queries_per_hour’ resource (current value: 15000)”

WITHOUT EXECUTING ANY QUERY

#33

When you are accessing the database through Database Manager those links are still queries and are treated properly.

#34

I found the solution. Error was in my side

Thank you all.
@NGiNX
@ckhawand

#35

You’re welcome :blush:

1 Like
#36