Bug #58222 Add like-pattern match to enable/disable metrics counters

• Submitted: 16 Nov 2010 9:00
• Modified: 20 Dec 2013 12:57
• Reporter: Jimmy Yang
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.6
• OS: Any
• Assigned to: Jimmy Yang
• CPU Architecture: Any

[16 Nov 2010 9:00] Jimmy Yang

Description:
Dimitry had made a request to have like-pattern match to enable/disable metrics counters, so user do not supply exact counter name to enable/disable counters: 

 "set global innodb_enable_monitor_counter = '%lsn%';"

So we will process the "fuzzy" match for the counter name
 

How to repeat:
see above

[16 Nov 2010 9:53] MySQL Verification Team

Thank you for the bug report.

[24 Nov 2010 5:17] Jimmy Yang

This is to add the support of ability to use wildcard match to specify the monitor counter names when manipulate them. 

For example, to enable the wildcard match, user would need to start the monitor counter name with '%':

Turn on all monitors contain word 'lock':
 set  global innodb_enable_monitor_counter = "%lock%";

Turn on all monitors contain word 'lock' and 'removed':
 set  global innodb_enable_monitor_counter = "%lock%removed";

With this feature, user does not need to remember any exact name for the monitor counters.

[2 Dec 2010 5:54] Jimmy Yang

Instead of requiring user to supply string start with "%", we change the requirement to that user just need to supply at least one "%" character in the string to activate the wildcard match.

[22 Dec 2010 21:29] Bugs System

Pushed into mysql-trunk 5.6.1 (revid:[e-mail]-20101222212842-y0t3ibtd32wd9qaw) (version source revid:[e-mail]-20101222212842-y0t3ibtd32wd9qaw) (merge vers: 5.6.1) (pib:24)

[20 Dec 2013 12:57] Erlend Dahl

Fixed in 5.6.1.