Bug #22958 Com_create_user missing within 5.0
Submitted: 3 Oct 2006 20:54 Modified: 11 Dec 2006 4:47
Reporter: Mark Leith
Status: Closed
Category:Server: General Severity:S3 (Non-critical)
Version:5.0 OS:Any (All)
Assigned to: Magnus Svensson Target Version:
Tags: STATUS, create user, com_create_user

[3 Oct 2006 20: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 15: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 4: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).