Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-wait-by-bytes.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_wait_by_bytes and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-wait-by-latency.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-latest-file-io.html
These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections).
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
This section describes the performance considerations for backing up a database with MySQL Enterprise Backup. For an incremental backup, specify the --incremental or --incremental-with-redo-log-only option to mysqlbackup. Parallel Backup ...When ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-cloud.html
All mysqlbackup options compatible with single-file operations (including, for example, the incremental, compression, partial, and encryption options) can be used with cloud backups or restores. Note See Appendix B, Limitations of MySQL Enterprise ...Only single-file backups can be created on and restored from a cloud ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-performance.html
This section describes the performance considerations for restoring a database server with MySQL Enterprise Backup. For example, backup performance might be acceptable using mysqldump, but mysqldump typically takes much longer than MySQL Enterprise ...This subject is important because: The restore operation is the phase of the backup-restore cycle that tends to vary substantially between different backup ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/contributing.html
The most useful forms of feedback are bug reports, enhancements requests, and contributions of code. The rest of this chapter contains information about filing bug reports and enhancement requests, as well as how to submit code that you wish to ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
mysqlrouter Option Summaries mysqlrouter Option Descriptions MySQL Router accepts command line options that are passed into mysqlrouter to affect its behavior, or to bootstrap router based on an InnoDB Cluster. Bootstrapping command line options ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean-cmdline.html
The MySQL AI Installer can also be run in command-line mode, without invoking the installation GUI. Warning MySQL AI might not work or might have performance issues if installed on a system that does not satisfy the minimum requirements. User and ...Install Without Satisfying Minimum Requirements --skip-requirements: Install even if the system does not satisfy the minimum ...