Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". It is good practice to start the bootstrap member first, and let it create the group. Creating ... This section explains the configuration settings required for MySQL Server instances that you want to use for Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
This section explains how to create a replication group with three MySQL Server instances on one physical machine. Create a directory named data, then in that directory create a subdirectory for each server instance, for example s1, s2 and s3, and ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Rolling Migration Upgrade In this method you remove members from the group, upgrade them and then create a second group using the upgraded members. create a new group with the upgraded members, see Chapter 20, Group Replication. Rolling Duplication ... Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with an older version in ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
A stored program may include handlers to be invoked when certain conditions occur within the program. The applicability of each handler depends on its location within the program definition and on the condition or conditions that it handles: A ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, ... If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating system. This is ... To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
To start the MySQL server use systemctl: $> systemctl start mysqld The database tables are automatically created for you, if they do not already exist. During installation, the initial database is created, and you are prompted for the MySQL root ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...