Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
This topic shows the different ways to export query results to Parquet files. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, "dialect": begin-object ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
To view the MySQL HeatWave query history including query start time, end time, and wait time in the scheduling queue, as discussed in Section 5.4.11, “Auto Scheduling”. CONNECTION_ID The connection ID of the client that issued the query.
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-shape-dependent-system-variables.html
User-Configurable Shape-Dependent System Variables 19.6 User-Configurable Shape-Dependent System Variables Shape-dependent global system variables are linked to, and tuned for, a specific MySQL shape. Note: innodb_buffer_pool_instances , ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic shows the different ways to export query results as an ND-JSON file. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.