Once I make even one request to any link on my site, the site bricks and I’m confronted with the error that I’ve exceeded my max queries per hour. This is just a site that check the existence of a resource, if absent, incrementally gets the id of the last record, assigns this id to itself and inserts into the table. There is simply no way one request can attain 5000 counts as I don’t even have up to 600 rows of data. I now observe this message also appears in the phpmyadmin, which means that also is capped!!! Isn’t this absurd??!
Anyway, that’s beside the point. I tried running this query
SELECT HOUR(time) 'hr', COUNT(DISTINCT id) FROM schema.table WHERE time BETWEEN '2016-01-23 00:00:00' AND '2016-01-24 00:00:00' GROUP BY hr;
So I can at least, debug the source of the astronomic surge in requests and then I’m slammed with a "ER_TABLEACCESS_DENIED_ERROR " which means I’m constricted from profiling what function or part of my code could be making so many calls (to not just 1, but 5000).
Can the admin kindly enable this feature for me, even for a few minutes to catch a glimpse of what causes the rise count or offer a solution as my entire work is stranded and frozen on your site? Many thanks in advance.