For MySQL PI to function properly, there are configurations required on monitored MySQL instances.
The configuration changes can be done by changing the MySQL options file (known as my.cnf or my.ini) to add or change prerequisite parameters. These changes will take effect only after the MySQL service restarts and will be permanent.
To make a permanent change using the config file
The lines below should be copied and added directly to your MySQL config file. This name and location of this file depends on the operating system used:
These changes should be added in the MySQL options file that is initialized during the MySQL server startup (known as my.cnf or my.ini). The lines below are in the format for this file.
Note: The default for performance_schema_max_digest_length is 200 on MySQL 5.6.
#Make sure the following Performance schema consumers are set performance-schema-consumer-events-waits-current=ON performance-schema-consumer-events-waits-history=ON performance-schema-consumer-statements-digest=ON performance-schema-consumer-thread-instrumentation=ON performance-schema-consumer-events-statements-current=ON performance-schema-consumer-events-statements-history=ON performance-schema-consumer-statements-digest=ON performance-schema-consumer-events-statements-history-long=ON #Make sure the following Performance schema instruments are on performance_schema = ON performance_schema_instrument = 'statement/%=on' performance_schema_instrument = 'wait/%=on' #Make sure the following server variables are configured more than a default (which is too low) #To gather more digests (Nomalized) performance_schema_digests_size=10000 performance_schema_events_waits_history_size = 100 performance_schema_events_waits_history_long_size=10000 performance_schema_events_statements_history_size = 1000 performance_schema_events_statements_history_long_size=20000 #To see larger digest text (Normalized) max_digest_length=1024 performance_schema_max_digest_length=1024 #To see larger SQL text performance_schema_max_sql_text_length=1024
The attached Getting Started with MySQL PI document provides an is intended as a summary of the requirements and procedures needed for implementing Performance Investigation with MySQL. For more detailed information, please refer to the Foglight for MySQL Cartridge Guide.
If a MySQL 8 server is unable to restart after updating the my.ini file on Windows, refer to Knowledgebase article 333598.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책