Search Results
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
When the limit determined by tmp_table_size is reached, MySQL automatically converts the in-memory internal temporary table to an InnoDB on-disk internal temporary table. When using the MEMORY storage engine for in-memory temporary tables ... In ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
You cannot use the --compress option together with the --incremental-with-redo-log-only option. Explicitly specifying a value other than punch-hole for the option through a configuration file or command line automatically enables the --compress ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
For restoring a single-file backup (including incremental, compressed, encrypted, and cloud backups): When using copy-back-and-apply-log to restore a single-file backup, use --backup-dir to supply a temporary folder to store the temporary data of ...