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 Email Updates:
Status: Closed Impact on me:
None 
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.