Bug #72130 | Create new sysvar like performance-schema-setup-actors-fill-default-value | ||
---|---|---|---|
Submitted: | 26 Mar 2014 5:15 | Modified: | 9 Mar 2015 10:08 |
Reporter: | Tsubasa Tanaka (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Performance Schema | Severity: | S4 (Feature request) |
Version: | 5.6.16 | OS: | Any |
Assigned to: | Marc ALFF | CPU Architecture: | Any |
Tags: | feature request, performance_schema, setup_actors |
[26 Mar 2014 5:15]
Tsubasa Tanaka
[26 Mar 2014 5:16]
Tsubasa Tanaka
Patch for create new sysvar based on 5.6.16. (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Contribution: mysql-5.6.16_performance_schema_setup_actors_fill_default_value.patch (application/octet-stream, text), 1.83 KiB.
[6 Mar 2015 10:24]
MySQL Verification Team
Hello tanaka-san, Thank you for the feature request and contribution. Thanks, Umesh
[6 Mar 2015 10:25]
MySQL Verification Team
// 5.6.25 bin/mysql -uroot -p -S /tmp/mysql_ushastry.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.25-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT * FROM performance_schema.setup_actors; +------+------+------+ | HOST | USER | ROLE | +------+------+------+ | % | % | % | +------+------+------+ 1 row in set (0.01 sec)
[9 Mar 2015 10:08]
Tsubasa Tanaka
Hi Umesh-san, Thank you for verifying. In some cases, I want to use performance_schema like "SHOW PROFILES". (It was deprecated as of 5.6.7, http://dev.mysql.com/doc/refman/5.6/en/show-profiles.html) My expected use-case is, * All threads'es "instrumented" are "NO" from startup. * When I want to use p_s as profiler, I turn my connetion's "instrumentd" to "YES". * This operation is same as "SET profiling=1" as of 5.5. * If I can this, my profiling doesn't have effect for any other (including background) running-threads. * After profiling, I can finish my profiling-thread by just closing my console This can provide similar behaviors to 5.5's profiling, it's good for me. Regards,