Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
Comment Information about the index not described in its own column, such as disabled if the index is disabled. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/8.4/en/system-variables-controlling-tracing.html
The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET ...
https://dev.mysql.com/doc/refman/8.4/en/using-gdb-on-mysqld.html
In this case, you should set the following environment variable in the shell before starting gdb: LD_ASSUME_KERNEL=2.4.1 export LD_ASSUME_KERNEL When running mysqld under gdb, you should disable the stack trace with --skip-stack-trace to be able to ... On most systems you can also start mysqld from gdb to get more information if mysqld ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-sha2-cache-plugin.html
It is possible to disable the mysqlx_cache_cleaner plugin by starting the MySQL server with the option --mysqlx_cache_cleaner=0. If you do this, the X Plugin authentication cache is disabled, and therefore SSL must always be used for X Protocol ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
When detached XA transactions are disabled (xa_detach_on_prepare set to OFF), an XA transaction remains connected until it is committed or rolled back by the originating connection. Disabling detached XA transactions is not recommended for a MySQL ... An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37065301) Microsoft Windows: Disabled windows compiler warnings C26445 and C26821 in cmake/msvc_cppcheck.cmake. (Bug #35037114) InnoDB: Common prefix compression for redo log inserts (MLOG_REC_INSERT) was disabled but is now enabled when the ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
--no-locking Disables all locking during backup (see The Backup Process for details). --free-os-buffers[=NUMBER] Command-Line Format --free-os-buffers[=NUMBER] Type Integer Default Value 2 Valid Values 012345 Default: Automatic syncing disabled.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-cloud-options.html
These options are for using cloud storage for single-file operations. See Section 4.3.1.3, “Backing Up to Cloud Storage”, and Section 5.2, “Restoring a Backup from Cloud Storage to a MySQL Server”, for more information and instructions on ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
--compress-level=LEVEL Command-Line Format --compress-level=LEVEL Type Numeric Default Value 1 Minimum Value 0 Maximum Value 9 Specifies the level of compression, ranging from “0” to “9”: “0 ”disables compression; “1” is fastest ...