Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
Each client can autodetect which character set to use based on the operating system setting, such as the value of the LANG or LC_ALL locale environment variable on Unix systems or the code page setting on Windows systems. C applications can use ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
Group Replication members can also be configured to use the clone plugin as an option for distributed recovery, in which case joining members automatically choose the most efficient way to retrieve group data from existing group members. When you ...
https://dev.mysql.com/doc/refman/8.4/en/concurrent-inserts.html
By default, the variable is set to AUTO (or 1) and concurrent inserts are handled as just described. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. The results of a ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes the items typically found in the data directory, with cross references for additional information: Data directory ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Also notice that when the main process of a container (mysqld in the case of a MySQL Server container) is stopped, the Docker container stops automatically. Warning The MySQL Docker images maintained by the MySQL team are built specifically for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
A member that has left a group makes three auto-rejoin attempts by default, so the process of rejoining the group can still take place without operator intervention. The minimum setting for the XCom message cache size in MySQL 8.4 is 128 MB, which ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
row *************************** SPACE: 26 NAME: test/t1 FLAG: 0 ROW_FORMAT: Compact or Redundant PAGE_SIZE: 16384 ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single FS_BLOCK_SIZE: 4096 FILE_SIZE: 98304 ALLOCATED_SIZE: 65536 AUTOEXTEND_SIZE: 0 SERVER_VERSION: 8.4.0 ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
The autocommit setting is turned on, so that the transaction is guaranteed to be a single statement, and the single statement making up the transaction is a “non-locking” SELECT statement. For information about START TRANSACTION and autocommit, ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. Because of the asynchronous nature of automatic statistics recalculation, which occurs in ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...