Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. Options and variables for use on sources and replicas are covered separately, as are options and ...The server can be started with this default ID, but when binary logging is enabled, an informational message is issued if you did not set server_id explicitly to specify a server ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. Modifying system variables with SET GLOBAL is a runtime capability that can be done from clients run locally ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. This feature ensures that the replica stays connected to the most suitable source server at ...Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-cloud-service-configuration-s3api.html
MySQL Shell supports configuring AWS credentials in environment variables and in configuration files. For example, s3Profile takes precedence over the environment variable AWS_PROFILE, and the default profile in the configuration file. For example, ... MySQL Shell S3 support has been tested against the following S3-compatible storage services: Amazon Web Services S3 See Amazon Simple Storage Service Documentation for more ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
Events produced by the instrument have NULL for the TIMER_START, TIMER_END, and TIMER_WAIT timer values. This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. For ...row ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
Include a TIMESTAMP column in all tables that you want to be able to update. If you have a problem with these, change the columns to DATETIME. The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, ...For maximum portability, do not use a length specification in the column declaration (which is unsupported within MySQL in versions earlier than ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old primary. The ... Limit on ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
The old sublist contains less frequently used pages; these pages are candidates for eviction. Per second averages provided in InnoDB Standard Monitor output are based on the elapsed time since InnoDB Standard Monitor output was last printed. The ...