Search Results
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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup.compressed.html
You cannot use the --compress option for incremental backups created only with the redo log (i.e., with the --incremental-with-redo-log-only option). To save disk space, you can compress InnoDB backup data files by using the --compress option of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-performance-space-overview.html
An Incremental backup includes all changes to the data since the last backup. When it comes to formulating your backup strategy, performance and storage space are the key considerations. You want the backup to complete quickly, with as little CPU ...