Search Results
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued when the server is started with --collation-server set equal to the name of a user-defined collation. Warning User-defined ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The bootstrap should only be done by a single server, the one that starts the group and only once. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. For the purpose of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-members.html
The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are members of the group. At that point, servers exchange some of their metadata to synchronize themselves and continue ...The information in the table is updated whenever there is a view change, for example when the configuration of the group is dynamically changed when a new member ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-tuning-recovery.html
As the joining member is connecting to different servers and not to the same one repeatedly, it can assume that the problem that affects server A does not affect server B. Once the server joining the group has made one attempt to connect to each of ... Several aspects of Group Replication's distributed recovery process can be configured to suit your ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
Note Before MySQL 8.4, a server would not join a group if it was running a lower MySQL Server version than the lowest group member's version. For example, an 8.4.0 server could join a group consisting of S1 (8.4.1) and S2 (8.4.2). While you are in ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
It means that the server always knows whether a view is updatable. Notes MySQL permits different sql_mode settings to tell the server the type of SQL syntax to support. However, an additional consequence is that comments prior to SELECT are stripped ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-in-core-file.html
To generate core files with buffer pool pages, start the server with the --core-file and --innodb-buffer-pool-in-core-file=ON options. mysql> SET GLOBAL innodb_buffer_pool_in_core_file=OFF; If the innodb_buffer_pool_in_core_file variable is disabled ... A core file records the status and memory image of a running ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
On dedicated servers, up to 80% of physical memory is often assigned to the buffer pool. Ideally, you set the size of the buffer pool to as large a value as practical, leaving enough memory for other processes on the server to run without excessive ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Because the statistics in the INNODB_CMP_PER_INDEX table are expensive to collect, you must enable the configuration option innodb_cmp_per_index_enabled before querying that table, and you might restrict such testing to a development server or a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. A server restart might fail if the data file is not found at the expected path. There are different reasons for creating ...