Re: processhit results

[Ken Green]

Sorry for the delay (due to work emergencies). Here are the tests I ran.

Test Plan:
==========
All tests will be run as root user.
Test #1 will use MySQL Query Browser (MSQBrow) to get results.
Test #2 will use my 3rd party software (3rdParty) to get results.
Test #3 will use my 3rd party software (3rdParty) to get results but with MySQL Query Browser open in the background.
Protocol:
1. I'll use mysql prompt to run Sleep(60)
2. Using test software as noted above, do the following:
A. Run SHOW GRANTS command
B. Run SHOW PROCESSLIST command

Test Results:
=============
Test #1 - MSQBrow (copied from HTML Export):
--------------------------------------------
A. Grants for root@localhost
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*9CFBBC772F3F6C106020035386DA5BBBF1249A11' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `information\_schema`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `mysql`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `crfq`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `research`.* TO 'root'@'localhost' WITH GRANT OPTION

B. Id User Host db Command Time State Info
32 root localhost:50962 Query 26 User sleep select sleep(60)
33 root localhost:50977 Sleep 101 (null)
35 root localhost:50979 Query 0 show processlist
36 root localhost:50980 Sleep 5 (null)

Test #2 - 3rdParty:
-------------------
A. GRANTS_FOR
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*9CFBBC772F3F6C106020035386DA5BBBF1249A11' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `information\_schema`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `mysql`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `crfq`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `research`.* TO 'root'@'localhost' WITH GRANT OPTION

B. ID USER HOST DB COMMAND TIME STATE INFO
16 root localhost:50775 Query 48 User sleep SELECT Sleep(60)
17 root localhost:50776 research Query 0 .NULL. SHOW PROCESSLIST

Test #3 - 3rdParty but with MSQBrow open in the background:
-----------------------------------------------------------
A. GRANTS_FOR
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*9CFBBC772F3F6C106020035386DA5BBBF1249A11' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `information\_schema`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `mysql`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `crfq`.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `research`.* TO 'root'@'localhost' WITH GRANT OPTION

B. ID USER HOST DB COMMAND TIME STATE INFO
16 root localhost:50775 Query 67 User sleep SELECT Sleep(120)
18 root localhost:50819 Sleep 60 .NULL.
20 root localhost:50821 Sleep 59 .NULL.
21 root localhost:50822 Sleep 4 .NULL.
22 root localhost:50837 research Query 0 .NULL. show processlist

(I didn't notice the redundancies in GRANTS until this test but decided no to delete them until this test was done.)

Thanks,
Ken