Search Results
https://dev.mysql.com/doc/refman/9.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.27, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.13, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.40, ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/mysql-enterprise-backup/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/glossary.html
For example, the mysqldump command produces a logical backup, because its output contains statements such as CREATE TABLE and INSERT that can re-create the data. These terms are commonly used in information about the MySQL Enterprise Backup product. Files with this extension are always included in backups produced by the mysqlbackup command of the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-conf-options.html
When inserting a new entry into a full cache, MySQL Router removes the longest unused entry. When started, MySQL Router reads a list of configuration files that together make up the configuration of the router. MySQL Router reads options from ...
https://dev.mysql.com/doc/mysql-router/9.7/en/router-read-write-splitting-statements.html
The following DML: CALL, INSERT, UPDATE, DELETE, REPLACE, IMPORT TABLE, LOAD DATA, LOAD XML, WITH...UPDATE/DELETE. The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-extension-createresult-return.html
The data can be either a dictionary, for a single result, or a list of dictionaries, for multiple results. Single Result Multiple Result Single Result The data dictionary for a single result must be a dictionary and include the following: ...