Is there any way of viewing an account's remaining resources that are allocated to it? I setup an account that's allowed 7200 queries an hour. At any point, could I then run a query to find out how many remaining queries it's allowed?
MySQL must be storing this information somewhere as
FLUSH USER_RESOURCES; will reset the counters however, I tried a few variants such as
SHOW USER_RESOURCES and they don't seem to display anything. I've also hunted around information_schema and mysql tables.
Is it just not possible to retrieve that information?