Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: users_lost METER: mysql.perf_schema METRIC_TYPE: ASYNC COUNTER ...row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. To change the table size, modify the performance_schema_setup_objects_size system variable at server startup. For object types listed in setup_objects, the ...This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For some MySQL installation methods, data directory initialization may be done for you ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-background-threads.html
Example mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background threads | +--------------------------------+ . Produces a result set indicating ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-consumer.html
Example Disable all statement consumers: mysql> CALL sys.ps_setup_disable_consumer('statement'); +----------------------+ | summary | +----------------------+ | Disabled 4 consumers | +----------------------+ . Disables Performance Schema consumers ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-instrument.html
Example Disable a specific instrument: mysql> CALL sys.ps_setup_disable_instrument('wait/lock/metadata/sql/mdl'); +-----------------------+ | summary | +-----------------------+ | Disabled 1 instrument | +-----------------------+ Disable all mutex ... Disables Performance Schema instruments with names that contain the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-thread.html
Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | Disabled 1 thread | +-------------------+ Disable the current connection: mysql> CALL ... Given a connection ID, disables Performance Schema instrumentation for the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-background-threads.html
Example mysql> CALL sys.ps_setup_enable_background_threads(); +-------------------------------+ | summary | +-------------------------------+ | Enabled 24 background threads | +-------------------------------+ . Produces a result set indicating how ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-consumer.html
Example Enable all statement consumers: mysql> CALL sys.ps_setup_enable_consumer('statement'); +---------------------+ | summary | +---------------------+ | Enabled 4 consumers | +---------------------+ . Enables Performance Schema consumers with ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-instrument.html
Example Enable a specific instrument: mysql> CALL sys.ps_setup_enable_instrument('wait/lock/metadata/sql/mdl'); +----------------------+ | summary | +----------------------+ | Enabled 1 instrument | +----------------------+ Enable all mutex ...