Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Memory instrumentation can be enabled or disabled at startup, or dynamically at runtime by updating the ENABLED column of the relevant instruments in the setup_instruments table. The memory/performance_schema/ instruments are built in, always ... An ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata Locking”. Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
An instrument disabled in this table produces no events regardless of the contents of the other production-related setup tables. If you disable instruments, you might need to wait a while before events for them are displaced by newer events of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
To enable or disable this mutex, use the mutex_instances table instead. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
The server handles the file contents as follows: If the persisted_globals_load system variable is disabled, the server ignores the mysqld-auto.cnf file. If this issue occurs, start the server with the persisted_globals_load system variable disabled ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
If binary logging was previously disabled on the source using the --skip-log-bin option, you must restart the server without this option to enable it. If networking has been disabled, the replica cannot communicate with the source and replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slavebaseconfig.html
For example, if binary logging was disabled on the server and you want it enabled for your replica, a server restart is required to enable this. If you need to disable binary logging or replica update logging on a replica, you can do this by ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
This enables anyone to connect without a password and with all privileges, and disables account-management statements such as ALTER USER and SET PASSWORD. Because this is insecure, if the server is started with the --skip-grant-tables option, it ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Groups can be enabled or disabled to control whether threads are assignable to them. Each group can be enabled or disabled, affording administrators control over thread assignment. MySQL supports creation and management of resource groups, and ...