Search Results
https://dev.mysql.com/doc/refman/9.7/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 9.7 is 128 MB, which ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-temporary-tablespace.html
The size of the pool never shrinks and tablespaces are added to the pool automatically as necessary. If no value is specified for innodb_temp_data_file_path, the default behavior is to create a single auto-extending data file named ibtmp1 in the ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-hashicorp-component.html
(Optional) HashiCorp Vault supports autocomplete options that make it easier to use. Variables which have been persisted (saved to mysqld-auto.cnf) must be removed from the server's configuration using RESET PERSIST. Note The ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-component.html
Variables that are persisted (saved to mysqld-auto.cnf) must be removed from the server's configuration using RESET PERSIST. Note component_keyring_kmip is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-apt-repo.html
Starting and Stopping the MySQL Server The MySQL server is started automatically after installation. Note Known issue: Currently, not all components required for running the MySQL NDB Cluster test suite are installed automatically when you install ... This section provides guidance on installing MySQL using the MySQL APT ...