Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
[mysqld] # # Disable other storage engines # disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" # # Replication configuration parameters # server_id=2 gtid_mode=ON enforce_gtid_consistency=ON # # Group Replication configuration # ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the same single host. This section explains how to create a replication group with three MySQL Server instances on one ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
For instructions to set up SSL for distributed recovery connections and create a replication user that requires SSL, see Section 20.6.3, “Securing Distributed Recovery Connections” Important By default, users created in MySQL 8 use Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
MySQL implements compression with the help of the well-known zlib library, which implements the LZ77 compression algorithm. One technique MySQL uses is to maintain some system information in the B-tree node in uncompressed form, thus facilitating ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
mysql> SELECT index_id, name, table_id, space from INFORMATION_SCHEMA.INNODB_INDEXES WHERE index_id=457; +----------+------+----------+-------+ | index_id | name | table_id | space | +----------+------+----------+-------+ | 457 | idx | 327 | 283 | ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
type is a MySQL scalar data type (that is, it cannot be an object or array). JSON_TABLE() extracts data as JSON then coerces it to the column type, using the regular automatic type conversion applying to JSON data in MySQL. type can be any valid ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
Both files should be readable only by the appropriate user that runs the server, typically mysql. The manifest file must be named mysqld.my and added to the same directory where mysqld is installed. It contains the path to the file where the server ... The component_keyring_file keyring component stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
When the MySQL server halts or restarts, the data in MEMORY tables is lost. The tables themselves continue to exist because their definitions are stored in the MySQL data dictionary, but they are empty when the server restarts. However, the two ...