Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory guidelines.
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-download.html
To download the latest MySQL Enterprise Edition for Linux x86-64 generic binary package, perform the following steps. If you already have the latest package, you can skip this procedure. On the Oracle Software Delivery Cloud page: Select Release ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
external_table_storage_engine Command-Line Format --external_table_storage_engine=text System Variable external_table_storage_engine Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String Default Value LAKEHOUSE Determines which ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
(The default group_concat_max_len setting is 1024 bytes.) mysql> SET SESSION group_concat_max_len = 1000000; mysql> SELECT GROUP_CONCAT(log->>"$.sql" SEPARATOR ' ') FROM sys.heatwave_advisor_report WHERE type = "sql" ORDER BY id; Usage Notes Auto ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Columns with the following data types: BINARY VARBINARY TINYBLOB BLOB MEDIUMBLOB LONGBLOB JSON TEXT TINYTEXT MEDIUMTEXT LONGTEXT Autopilot Indexing does not make recommendations for the following: The creation of primary keys. Autopilot Indexing ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
To view the current MySQL HeatWave query history, query the performance_schema.rpd_query_stats table: mysql> SELECT query_id, LEFT(query_text,160) FROM performance_schema.rpd_query_stats; *************************** 1. row ... Auto Query Time ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
CAST() from and to all the MySQL HeatWave supported numeric, temporal, string and text data types. CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() operates on the ENUM index rather than the ENUM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Select the Encoding Type By default, when tables are loaded into MySQL HeatWave, CHAR, VARCHAR, and TEXT type columns are encoded using variable-length encoding. This topic describes how to encode string columns to improve the performance of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
Text segments: that were retrieved from the vector store and used as context to prepare responses for your queries. This topic describes how to view a chat session details. It contains the following sections: Before You Begin View Details What's ...