Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-restrictions.html
If you save event information in another table, you should not assume that the original events remain available later. The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
A value of Performance_schema_mutex_classes_lost greater than 0 can happen in two cases: To save a few bytes of memory, you start the server with --performance_schema_max_mutex_classes=N, where N is less than the default value. Names for these ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
To view events from the log, send mysqlbinlog output into a paging program: $> mysqlbinlog binlog_files | more Alternatively, save the output in a file and view the file in a text editor: $> mysqlbinlog binlog_files > tmpfile $> ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory allocation. You may be able to its improve performance by setting ...
https://dev.mysql.com/doc/refman/8.4/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. We need to obtain as much information as possible from you to be able to track down ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, cloning or copying of the data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary. The following sections contain information about mysqld options and server variables that are used in replication and for controlling ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-interface.html
In the event of source failure, all transactions committed on the source have been replicated to the replica (saved to its relay log). When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
It also saves the value, causing it to carry over to subsequent server restarts. Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges ...