如何计算用户问题? [英] How to count user questions?

问题描述

我正在使用ClearDB Mysql并收到以下错误:用户XXXX已超出'max_questions'资源(当前值:18000)]

I'm using ClearDB Mysql and got the following error: User XXXX has exceeded the 'max_questions' resource (current value: 18000)]

我知道要检查我们可以做的max_questions:select user, max_questions from mysql.user;

I know to check the max_questions we can do: select user, max_questions from mysql.user;

我如何计算用户提出的问题数量?

How can I count the number of questions a user has made?

谢谢.

推荐答案

您的错误消息告诉您.您每小时可以执行18,000个问题".您已达到限制，因此限制就是完成的次数.

Your error message tells you. You can perform 18,000 "questions" an hour. You've reached the limit, therefore the limit is the number done.

更一般地说，您可以使用显示状态命令:

More generically you can use the SHOW STATUS command:

SHOW SESSION STATUS LIKE 'Questions'

这是根据文档，显示...

This, according to the documentation, shows...

服务器执行的语句数.从MySQL 5.1.31开始， 这仅包括客户端发送到服务器的语句，而没有 不再包含在存储程序中执行的语句，这与 查询变量.

The number of statements executed by the server. As of MySQL 5.1.31, this includes only statements sent to the server by clients and no longer includes statements executed within stored programs, unlike the Queries variable.

这篇关于如何计算用户问题?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！