Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Advisor is implemented as a stored procedure named heatwave_advisor, which resides in the MySQL sys schema. Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
Running Queries 10 Running Queries The Workspace tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and MySQL HeatWave queries. To run a query using the Query Editor: Connect to a DB System. Select the Workspace tab in the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-examples.html
Examples of using Connector/J are located throughout this document. This section provides a summary and links to these examples. Example 7.1, “Connector/J: Obtaining a connection from the DriverManager” Example 7.2, “Connector/J: Using ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
mysql_firewall_database: Database from which MySQL Enterprise Firewall plugin sources its tables and stored procedures. Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and Variables Removed in ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-example.html
Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume also that the ...
https://dev.mysql.com/doc/refman/8.4/en/case.html
[ELSE statement_list] END CASE The CASE statement for stored programs implements a complex conditional construct. (The indentation used here in the ELSE clause is for purposes of clarity only, and is not otherwise significant.) DELIMITER | CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
This helps the MySQL upgrade procedure detect and upgrade tables containing old temporal columns. When an InnoDB table is stored in its own .ibd file, the first 3 pages of the .ibd file contain header information rather than table or index data.
https://dev.mysql.com/doc/refman/8.4/en/conditions-and-parameters.html
If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller. If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
When the thread stack is too small, this limits the complexity of the SQL statements the server can handle, the recursion depth of stored procedures, and other memory-consuming actions. This section describes aspects of how the MySQL server manages ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...