1 of 1

SHOW USER_STATISTICS

View statistics on user activity. This statement displays metrics like CPU time and rows read for each user account.

Syntax

SHOW USER_STATISTICS

Description

The SHOW USER_STATISTICS statement is part of the feature. It was effectively replaced by the generic statement. The table holds statistics about user activity. You can use this table to find out such things as which user is causing the most load and which users are being abusive. You can also use this table to measure how close to capacity the server may be.

The SHOW USER_STATISTICS statement is part of the feature. The table holds statistics about user activity. You can use this table to find out such things as which user is causing the most load and which users are being abusive. You can also use this table to measure how close to capacity the server may be.

The system variable must be set to 1 to activate this feature. See the and table for more information.

Example

_{This page is licensed: CC BY-SA / Gnu FDL}