PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
If this happens, the attempt to add back the excluded member from the group results in an error with the message This member has more executed transactions than those present in the group. For example, in the above scenario of 5 servers where 3 ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
It might work, but chances are that the operations race and then the act of joining the group ends up in an error or a time out. The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Note that with the MyISAM storage engine disabled, when you are upgrading a MySQL instance to a release where mysql_upgrade is still used (before MySQL 8.0.16), mysql_upgrade might fail with an ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, sufficient for the data transfer to complete. In this case, if your connect_timeout value is set to only a few ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
Rebuild the Failed Member to Rejoin as a New Member Sometimes, the steps outlined above in Restoring a Failed Member cannot be carried out because, for example, the binary log or relay log is corrupted, or it is just missing from the backup. Connect ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
group_replication_components_stop_timeout Command-Line Format --group-replication-components-stop-timeout=# Introduced 5.7.17 System Variable group_replication_components_stop_timeout Scope Global Dynamic Yes Type Integer Default Value 31536000 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. Memory summary tables do not contain timing information because memory events are not ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
A - character between two other characters forms a range that matches all characters from the first character to the second. Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. For example, to remove ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you must to update my.cnf as shown in the following ...