Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Having it disabled (default as of MySQL 8.4) helps ensure stability even if it may lower performance. The algorithm works for some types of workloads but not others, so you might disable this feature if you observe periodic drops in performance. Set ... Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
You can enable or disable log writer threads using the innodb_log_writer_threads variable. Dedicated log writer threads can improve performance on high-concurrency systems, but for low-concurrency systems, disabling dedicated log writer threads ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
You can also disable or enable the nonunique indexes for a MyISAM table by using the following statements rather than myisamchk. These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-examples.html
For problem areas that are ruled out, disable the corresponding instruments. For example, if analysis shows that the issue is not related to file I/O in a particular storage engine, disable the file I/O instruments for that engine. The Performance ...
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 ...