Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
The following tables are separated by section, and summarize the MySQL Router options defined in a MySQL Router configuration file. Detailed information about each of these options, such as descriptions and allowed values, is documented below these ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...If not, ask your admin user to grant you the required ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse table. Once the S3 data is provided, the schema for the ...Note: To map and load data into Lakehouse, the Amazon S3 bucket in which the data is located and the DB System must be in the same ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. That is, you can include index declarations in the table definition. Inserts into a BLACKHOLE table do not store any data, but if statement ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. Is it possible for a trigger to update tables on a remote server? A.5.12. Information about triggers can be obtained by querying the INFORMATION_SCHEMA.TRIGGERS ...Where can I find the documentation for MySQL 8.4 triggers? ...
https://dev.mysql.com/doc/refman/8.4/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. --dns-srv-name=name Command-Line Format --dns-srv-name=name Type String Specifies the name of a DNS SRV record that determines the candidate hosts to use for ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...