Bug #12138 Process ID and port growing in MySQL query browser
Submitted: 24 Jul 2005 10:34 Modified: 24 Jul 2005 16:40
Reporter: [ name withheld ] (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.9 OS:Windows (windows 2000 sp4)
Assigned to: CPU Architecture:Any

[24 Jul 2005 10:34] [ name withheld ]
Description:
When refreshing a "show full processlist" with MySQL query Browser process connection and port keeps increasing with each refresh.

How to repeat:
Start MySQL (5.0.9 max nt), start MySQL Query Browser (1.1.9) and connect as root without selecting a db.
Issue a "show full processlist", get:
1, 'root', 'localhost:1780', '', 'Sleep', 7, '', ''
2, 'root', 'localhost:1781', '', 'Query', 0, '', 'show full processlist'

then hit the refresh button:

1, 'root', 'localhost:1780', '', 'Sleep', 162, '', ''
3, 'root', 'localhost:1782', '', 'Query', 0, '', 'show full processlist'

hit the refresh button again:

1, 'root', 'localhost:1780', '', 'Sleep', 178, '', ''
4, 'root', 'localhost:1783', '', 'Query', 0, '', 'show full processlist'

You'll see that the id and port of the second connection keeps growing
The same doesn't happen issuing again and again the same query from the command line client
[24 Jul 2005 16:40] MySQL Verification Team
That behavior is by design, QB opens a new connection for every query
send to the server.
[24 Jul 2005 16:59] [ name withheld ]
Why? One connection per tab or script is fine but why for query?