Search Results
Oracle Enterprise Manager for MySQL Database User's Guide :: 6.11 InnoDB Bufferpool Activity Metrics
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-bufferpoolactivity-category.html
Created Per Sec The per second average number of InnoDB buffer pool pages created per second. Pages Created (Delta) The total number of pages created within the InnoDB buffer pool. Lists the InnoDB Bufferpool Activity metrics and provides a brief ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-savepoints.html
To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement SAVEPOINT name;. For example by issuing: session.setSavepoint() a transaction savepoint is created with an automatically generated name and a string is ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-savepoints.html
To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement SAVEPOINT name;. For example by issuing: session.setSavepoint() a transaction savepoint is created with an automatically generated name and a string is ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement SAVEPOINT name;. For example by issuing: session.setSavepoint() a transaction savepoint is created with an automatically generated name and a string is ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
show_create_table_skip_secondary_engine Command-Line Format --show-create-table-skip-secondary-engine[={OFF|ON}] System Variable show_create_table_skip_secondary_engine Scope Session Dynamic Yes SET_VAR Hint Applies Yes Type Boolean Default Value ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
To exclude a column, specify the NOT SECONDARY column attribute in an ALTER TABLE or CREATE TABLE statement, as shown below. mysql> ALTER TABLE tbl_name MODIFY column_name datatype NOT SECONDARY; mysql> CREATE TABLE tbl_name ( column_1 datatype, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": "table_1", "engine_attribute": { "dialect": {"format": "csv"}, "file": [{"uri": "oci://mybucket@mynamespace/data_files/data_files/data_file_?0.csv"}] } }] }]'; mysql> ... To use uniform resource identifiers (URI) for loading data with Lakehouse Auto Parallel Load, which is available as of MySQL 9.3.1, review the following examples for different ways to set them ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
You can create the following types of URIs: OCIFS Syntax: oci://bucket_name@namespace_name/object_path Example: oci://bucket_1@tenant_1/data_files/ PAR URI Syntax. Auto Parallel Load automatically gets the schema of the CSV files and creates the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. If the specified output table doesn't exist, then a new table is created. The ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the table is created on the MySQL Database Service instance. Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave ...