Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-escape-string.html
mysql_escape_string() does not have arguments that enable it to respect the current character set or the quoting context.
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/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.10, “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/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/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits frequently used data to be accessed directly from memory, which speeds up processing. On dedicated servers, up to 80% of ...
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/refman/8.4/en/mysql-cluster-options-variables.html
ndb_conflict_role can take any one of the values PRIMARY, SECONDARY, PASS, or NULL (the default). row *************************** id: 1 select_type: SIMPLE table: d type: ALL possible_keys: PRIMARY key: NULL key_len: NULL ref: NULL rows: 9 Extra: ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
The value can be NULL if the row refers to the union result of other rows. If this column is NULL (or undefined in JSON-formatted output), there are no relevant indexes. If key is NULL, MySQL found no index to use for executing the query more ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. This option ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...