Bug #44016 performance_schema_enabled=0 at server startup has no effect

• Submitted: 1 Apr 2009 17:14
• Modified: 14 Jan 2010 18:03
• Reporter: Paul Dubois
• Status: Closed
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: mysql-6.0-perf
• OS: Any
• Assigned to: Marc Alff
• CPU Architecture: Any
• Triage: Triaged: D3 (Medium)

[1 Apr 2009 17:14] Paul Dubois

Description:
Setting performance_schema_enabled=0 at server startup does not disable Performance Schema:

mysql> show variables like 'perf%enabled';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| performance_schema_enabled | ON    | 
+----------------------------+-------+

Furthermore, there is no warning at startup that setting the variable has no effect.

How to repeat:
Put these lines in an option file and start the server:

[mysqld]
performance_schema_enabled=0

Then check SHOW VARIABLES.

[1 Apr 2009 21:41] Miguel Solorzano

Thank you for the bug report. Verified as described:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.11-alpha-debug-perfschema Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like 'perf%enabled';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| performance_schema_enabled | ON    | 
+----------------------------+-------+
1 row in set (0.01 sec)

[28 May 2009 22:00] Marc Alff

Fixed by WL#4876 Parse options before initializing mysys

[14 Jan 2010 10:01] Marc Alff

Merged in:
- mysql-next-mr (Celosia / 5.5.99-m3)
- mysql-6.0-codebase (6.0.14)

[14 Jan 2010 18:03] Paul Dubois

Not in any released version. No changelog entry needed.