Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-regression-prepare.html
This topic describes how to prepare the data to use for a regression machine learning model. The regression use-case is to predict house prices based on the size of the house, the address of the house, and the state the house is located in. To ...
https://dev.mysql.com/doc/x-devapi-userguide/en/method-chaining.html
MySQL Shell JavaScript Code // New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = employees.select(['name', 'age']). X DevAPI supports a number ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-ioglobalbywaitbylatency-category.html
Event Name The IO event name Max Latency The maximum single wait time of timed occurrences of the IO event. Table 6.36 Sys Schema IO Global By Wait By Latency Metrics NameDescriptionAverage Latency The average wait time per timed occurrence of the ... Lists the Sys Schema IO Global By Wait By Latency metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Server version 8.0.19-commercial Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 7 sec Threads: 3 Questions: 8 Slow queries: 0 Opens: 146 Flush tables: 3 Open tables: 63 Queries per second avg: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
The combined log file size (innodb_log_file_size * innodb_log_files_in_group) cannot exceed the maximum value, which is slightly less than 512GB. Normally, InnoDB is initialized when the MySQL server is started for the first time. If a tablespace ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-configuring-options.html
connectTimeout 10 float greater than 0 The time in seconds to wait before the connection of any session not using AdminAPI times out. dba.connectTimeout 5 float greater than 0 The time in seconds to wait before the connection of any session using ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
--connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 43200 The maximum number of seconds before connection timeout. --shutdown-timeout=value Command-Line Format --shutdown-timeout=seconds Type Numeric ...You ...
https://dev.mysql.com/doc/x-devapi-userguide/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For example, a CHAR(255) column can exceed 768 bytes if the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-priority-queue.html
If a query does raise an out of memory error, the scheduler runs the query a second time in isolation. The scheduling mechanism prioritizes short-running queries but considers wait time in the queue so that costlier queries are eventually scheduled ... MySQL HeatWave uses a workload-aware, priority-based, automated scheduling mechanism to schedule concurrently issued queries for ...