Search Results
https://dev.mysql.com/doc/refman/9.7/en/group-replication-view-changes.html
Using these two different parts enables the view identifier to identify incremental group changes caused by members joining or leaving, and also to identify the situation where all members leave the group in a full group shutdown, so no information ... When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section 19.1.3, “Replication with Global Transaction ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-locking-reads.html
Note Locking reads are only possible when autocommit is disabled (either by beginning transaction with START TRANSACTION or by setting autocommit to 0. To implement reading and incrementing the counter, first perform a locking read of the counter ...
https://dev.mysql.com/doc/refman/9.7/en/memory-use.html
If an internal in-memory temporary table becomes too large (as determined by tmp_table_size and max_heap_table_size), MySQL automatically converts the table from in-memory to on-disk format, which uses the InnoDB storage engine. The Performance ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-pitr.html
(See Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”.) See also Section 9.5, “Point-in-Time (Incremental) Recovery”, for more information about the binary log, replication, and incremental recovery. Point-in-time ...
https://dev.mysql.com/doc/refman/9.7/en/order-by-optimization.html
To obtain memory for filesort operations, the optimizer allocates memory buffers incrementally as needed, up to the size indicated by the sort_buffer_size system variable. This section describes when MySQL can use an index to satisfy an ORDER BY ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-component-scheduler-tasks-table.html
TIMES_RUN A counter that increments by one every time the task runs successfully. TIMES_FAILED A counter that increments by one every time the execution of the task fails. The component_scheduler_tasks table contains a row for each scheduled task.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-host-cache-table.html
Any or all of them can fail, independently incrementing SUM_CONNECT_ERRORS, possibly beyond the value of max_connect_errors. Depending on the type of error, one of these columns is incremented: COUNT_AUTHENTICATION_ERRORS, COUNT_AUTH_PLUGIN_ERRORS, ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/9.7/en/recovery-from-backups.html
To restore the changes made since then, we must use the incremental backups; that is, the gbichot2-bin.000007 and gbichot2-bin.000008 binary log files. | mysql For more information about using mysqlbinlog to process binary log files, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/show-warnings.html
The sql_notes system variable controls whether note messages increment warning_count and whether the server stores them. In the mysql client, you can enable and disable automatic warnings display using the warnings and nowarning commands, ... SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
tc_log_page_waits Tc_log_page_waits ASYNC COUNTER For the memory-mapped implementation of the recovery log, this variable increments each time the server was not able to commit a transaction and had to wait for a free page in the log. external_lock ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics mysql.mle Metrics The maximum number of metric instruments which can be created is set by ...