Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...
https://dev.mysql.com/doc/refman/8.4/en/workbench.html
The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. MySQL Workbench provides a graphical tool for working with MySQL servers and ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
As a result, temporary table field references from previous executions were not cleared, leading to attempts to insert duplicate keys into temporary tables triggering the error Can't write; duplicate key in table. Note These release notes were ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
However, subsequent apply-log operations on the backups will take more time to complete, as the unused pages are inserted back into the tables during the operations. These options limit the resources used by the backup process, in order to minimize ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-update.html
There are two types of operations to bring your backup data up-to-date: Apply-log Operation After a backup job was first completed, the backup data might not be in a consistent state, because data could have been inserted, updated, or deleted while ...During a backup, mysqlbackup also copies the accumulated InnoDB log to a file called ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
For best backup performance and minimal impact on database processing: Do not run long INSERT, UPDATE, or DELETE queries at the time of the backup run. This section describes the performance considerations for backing up a database with MySQL ...