Search Results
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
MySQL Enterprise Backup does not include temporary tables inside a backup. To avoid the issue, after the hot backup phase of a replica backup in which mysqlbackup copies all the InnoDB tables, it enters into a loop, in which the following happens: ... To backup a replica database, add the --replica-info option to your backup ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
mysql> CREATE MATERIALIZED VIEW airport_US AS SELECT airport.* FROM airport JOIN airport_geo ON airport.airport_id = airport_geo.airport_id WHERE airport_geo.country = 'UNITED STATES'; The materialized view retrieves information on U.S.-based ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
Include a TIMESTAMP column in all tables that you want to be able to update. Include a primary key in each MySQL table you want to use with Access. If you are using Connector/ODBC to link to a table that has a BIGINT column, the results are ... The ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
For InnoDB tables, minimum token size is defined by the innodb_ft_min_token_size configuration option, which has a default value of 3. For MyISAM tables, minimum token size is defined by ft_min_word_len, which has a default value of 4. Creating a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. In MySQL 8.4, it also waits for the completion of any ongoing DDL statements such as ALTER TABLE. The following function ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-transactions.html
That blocking lock request is for a row or table lock held by another transaction in an incompatible mode. data_lock_waits: This Performance Schema table indicates which transactions are waiting for a given lock, or for which lock a given ...Each ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is materialized ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates.html
COLUMNS_LISTING has the parent TABLES, which has the parent SCHEMATA, whose parent is the main dictionary. The following section has a table that helps you identify section requirements. This section provides an overview of creating and modifying ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Figure 3.12 Preferences: Modeling: Defaults The following tables show the object names and their default values. Figure 3.13 Preferences: Modeling: MySQL Model Default Target MySQL Version: [ version ] A limited subset of validation procedures and ... This section provides configuration options that affect the modeling functionality in MySQL Workbench (see the figure that ...