MySQL Bugs: #16469: "Registry Monitor"

Bug #16469	"Registry Monitor"
Submitted:	13 Jan 2006 0:17	Modified:	25 Sep 2006 14:00
Reporter:	Thomas GODART	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S5 (Performance)
Version:	1.1.18	OS:	Windows (Windows XP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	Generic

Description:
Is this a joke ? :

"14.79671634	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.30	NOTFOUND		
14.79673702	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.29	NOTFOUND		
14.79675741	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.28	NOTFOUND		
14.79677669	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.27	NOTFOUND		
14.79679652	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.26	NOTFOUND		
14.79681552	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.25	NOTFOUND		
14.79683479	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.24	NOTFOUND		
14.79685351	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.23	NOTFOUND		
14.79687223	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.22	NOTFOUND		
14.79689095	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.21	NOTFOUND		
14.79691022	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.20	NOTFOUND		
14.79692894	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.19	NOTFOUND		
14.79694738	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.18	NOTFOUND		
14.79696637	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.17	NOTFOUND		
14.79698537	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.16	NOTFOUND		
14.79700996	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.15	NOTFOUND		
14.79702979	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.14	NOTFOUND		
14.79704879	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.13	NOTFOUND		
14.79706750	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.12	NOTFOUND		
14.79708706	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.11	NOTFOUND		
14.79710578	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.10	NOTFOUND		
14.79712477	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.9	NOTFOUND		
14.79714321	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.8	NOTFOUND		
14.79716221	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.7	NOTFOUND		
14.79718149	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.6	NOTFOUND		
14.79719992	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.5	NOTFOUND		
14.79721864	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.4	NOTFOUND		
14.79723736	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.3	NOTFOUND		
14.79725552	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.2	NOTFOUND		
14.79727396	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.1	NOTFOUND		
14.79729239	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 10.0	NOTFOUND		
14.79731083	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 9.30	NOTFOUND		
14.79732899	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 9.29	NOTFOUND"

(...)

"14.80185470	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.6	NOTFOUND		
14.80187342	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.5	NOTFOUND		
14.80189158	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.4	NOTFOUND		
14.80190946	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.3	NOTFOUND		
14.80192762	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.2	NOTFOUND		
14.80194606	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.1	NOTFOUND		
14.80196422	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 2.0	NOTFOUND		
14.80198237	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.30	NOTFOUND		
14.80200389	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.29	NOTFOUND		
14.80202204	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.28	NOTFOUND		
14.80204020	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.27	NOTFOUND		
14.80205920	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.26	NOTFOUND		
14.80207736	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.25	NOTFOUND		
14.80209524	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.24	NOTFOUND		
14.80211368	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.23	NOTFOUND		
14.80213239	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.22	NOTFOUND		
14.80215055	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.21	NOTFOUND		
14.80216871	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.20	NOTFOUND		
14.80218715	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.19	NOTFOUND		
14.80220559	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.18	NOTFOUND		
14.80222375	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.17	NOTFOUND		
14.80224191	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.16	NOTFOUND		
14.80226034	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.15	NOTFOUND		
14.80227822	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.14	NOTFOUND		
14.80229666	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.13	NOTFOUND		
14.80231510	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.12	NOTFOUND		
14.80233326	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.11	NOTFOUND		
14.80235170	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.10	NOTFOUND		
14.80236957	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.9	NOTFOUND		
14.80238745	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.8	NOTFOUND		
14.80240561	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.7	NOTFOUND		
14.80242377	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.6	NOTFOUND		
14.80244193	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.5	NOTFOUND		
14.80245981	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.4	NOTFOUND		
14.80247797	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.3	NOTFOUND		
14.80249585	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.2	NOTFOUND		
14.80262659	MySQLQueryBrows:3844	OpenKey	HKLM\SOFTWARE\MySQL AB\MySQL Administrator 1.1	SUCCESS	Access: 0xF003F"

How to repeat:
With a "Registry Monitor", like the one from SysInternals. When the Query Browser starts.

Suggested fix:
-No comment-

I was able to reproduce this using RegMon32.  While this is not really a bug, I'm marking it as verified as its unoptimal to make so many unecessary reg reads.

Yeah I noticed this when trying to debug why MySQL QB can't find Adminstrator and vice versa.  This horrible looping code is also trying to load the keys for writing, so access is denied when running QB or Admin as normal user.  However, the keys are readable and this code only has to read!  To workaround one has to manually give permission to users for full control (write) over the key in the registry, which I have done, and now the tools find each other.