Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connection-control.html
This capability provides a deterrent that slows down brute force attacks against MySQL user accounts. The INFORMATION_SCHEMA.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS table, enabled by the CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin, provides ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-list.html
The app_task_list routine returns a paginated list of asynchronous tasks associated with an application user. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_list( IN ...task_type ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-brief.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status_brief( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36)); Following are app_task_status_brief parameters: app_user_id ... The app_task_status_brief routine returns the brief status of an application task, including a subset of information about the task and its last log ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-list.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status_list( IN 'app_user_id' VARCHAR(255), IN 'task_type' VARCHAR(90), IN offset INT UNSIGNED, IN limit INT UNSIGNED); Following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36)); Following are app_task parameters: app_user_id (VARCHAR(255)): specifies ... The app_task routine returns information about a single application ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload-syntax.html
mysql> CALL sys.HEATWAVE_UNLOAD_all ([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ["only_user_loaded_tables",{true|false}] ["output",{"normal"|"silent"}] } } Auto Unload Syntax for MySQL 8.3.0-u2 and Earlier ...This adds an include list to exactly specify the tables to unload, which eliminates the need to include a database and exclude unnecessary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
Some key benefits of using MySQL HeatWave GenAI are described below: The natural-language processing (NLP) capabilities of the LLMs let non-technical users have human-like conversations with the system in natural language. The cost of running ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
QUERY_TEXT The RAPID engine query or MySQL HeatWave AutoML query run by the user. For MySQL HeatWave AutoML, this contains the arguments the user passed to the MySQL HeatWave AutoML routine call. The rpd_query_stats table stores query compilation ...