Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before ...When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
As noted in Section 19.5.1.31, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based or mixed format. Temporary tables are not replicated when using row-based or mixed format because there is no need. In ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine types. For example, in a typical scale-out scenario (see Section 19.4.5, “Using ...This ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
Figure 1.36 Comparing the SQL Editor interface for Workbench 5.2 and 6.0 Table Data Search You can select schemas, tables, or both to perform client-side searches for user specified strings and patterns. To access this new search feature, right ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
For each row in the table, MATCH() returns a relevance value; that is, a similarity measure between the search string and the text in that row in the columns named in the MATCH() list. The search must be performed using a full-text index scan rather ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
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/ndbapi/en/ndb-start-mysql-data-types.html
This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API applications. make_ndb_varchar(myVal, "NDB is way cool!!"); ...The MySQL TINYINT, ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER TABLE t1 ALTER INDEX i_idx VISIBLE; Information about whether an index is visible or invisible is available from the Information Schema STATISTICS table or SHOW INDEX output.
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest ...