MySQL管理——监视用户活动、限制使用资源

mysql> SHOW PROCESSLIST;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User            | Host      | db   | Command | Time | State                  | Info             |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
|  4 | event_scheduler | localhost | NULL | Daemon  | 2379 | Waiting on empty queue | NULL             |
|  8 | root            | localhost | NULL | Query   |    0 | starting               | SHOW PROCESSLIST |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)

mysql可以限制用户单次查询的数据量吗，比如每次最大只可以查5条数据
ALTER USER 'root'@'%'
    WITH MAX_QUERIES_PER_HOUR 100
        MAX_UPDATES_PER_HOUR 20
        MAX_CONNECTIONS_PER_HOUR 0
        MAX_USER_CONNECTIONS 10;

ALTER USER 'root'@'%' WITH MAX_CONNECTIONS_PER_HOUR 0;