Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-verify-package.html
After downloading the MySQL package and before attempting to install it, ensure that the package is intact and has not been tampered with. There are two methods of integrity checking for MySQL Linux Generic Binary packages: MD5 Checksum and ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-document-ids.html
If an _id is provided when a document is created, it is honored; if no _id is provided, one is automatically assigned to the document. This section describes what a document ID is and how to work with it. Every document has a unique identifier ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
If an _id is provided when a document is created, it is honored; if no _id is provided, one is automatically assigned to the document. This section describes what a document ID is and how to work with it. Every document has a unique identifier ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing does evaluate past SQL statements that access a table that has been dropped and recreated. Rather than drop the suggested indexes, make them invisible first, and then drop them later after confirmation that there is no impact to ... Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
An estimate of the index creation time and the estimated performance gain of the top 5 queries of each create index recommendation. To run Autopilot Indexing for OLTP workloads, the user must have the following MySQL privileges: The PROCESS ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
If not, ask your admin user to grant you the required privileges. When the secondary engine creates the ACE statistics model, the ACE_MODEL column is updated in the performance schema table rpd_tables. As of MySQL 9.3.0, you can use the ANALYZE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
If not, ask your admin user to grant you the required privileges. mysql> SELECT COLUMN_NAME, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 't1' AND EXTRA LIKE '%NOT SECONDARY%'; +-------------+---------------+ | COLUMN_NAME | EXTRA | ... In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT SECONDARY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
You can define the encoding type while creating the table or later modify it using ALTER TABLE statement. Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined ...