Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks Table”. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema ... These views display which sessions are blocked waiting on metadata locks, and what is blocking ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
There are various ways to create different kinds of partial backup with MySQL Enterprise Backup: Including or excluding specific tables by their names. Each table is checked against the regular expression specified with the --include-tables or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-api.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. ArbitrationDelay: When asked to arbitrate, arbitrator waits this many milliseconds before voting. AutoReconnect: Specifies whether an API node should reconnect fully when ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab and adding or editing a foreign key is similar to adding or editing an index. The following figure shows an example of the Foreign Keys tab. Figure 8.16 The Foreign ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-triggers-tab.html
The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT. To add a new trigger, click the [+] icon ...