Bug #22958 Com_create_user missing within 5.0
Submitted: 3 Oct 2006 18:54 Modified: 11 Dec 2006 3:47
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0 OS:Any (All)
Assigned to: Magnus BlÄudd CPU Architecture:Any
Tags: com_create_user, create user, STATUS

[3 Oct 2006 18:54] Mark Leith
Description:
Now that we have CREATE USER within 5.0, we should also have the corresponding "Com_create_user" status variable as well. Currently we have Com_drop_user, without Com_create_user. 

Furthermore, when somebody issues a CREATE USER statement it is impossible to track this via the status variables, as not even Com_grant is increased. 

How to repeat:
SHOW GLOBAL STATUS LIKE 'Com_create_user';

Suggested fix:
Add a new Com_create_user status variable that is incremented for every CREATE USER statement.
[30 Oct 2006 14:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/14563

ChangeSet@1.2333, 2006-10-30 15:59:47+01:00, msvensson@shellback.(none) +1 -0
  Bug#22958 Com_create_user missing within 5.0
   - Add Com_create_user to SHOW STATUS command
[11 Dec 2006 3:47] Paul Dubois
Noted in 5.0.32, 5.1.15 changelogs.

The Com_create_user status variable was added (for counting CREATE
USER statements).