Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. You can use this routine for generating and running SQL queries only for databases and tables that you have access to. The routine automatically detects these errors, and ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-32-u1.html
(WL #15441) Arithmetic operators are now supported with variable-length encoded string columns. MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML adds support for multivariate endogenous forecasting ...
https://dev.mysql.com/doc/refman/9.7/en/declare.html
The DECLARE statement is used to define various items local to a program: Local variables. Variable and condition declarations must appear before cursor or handler declarations. END compound statement and must be at its start, before any other ...
https://dev.mysql.com/doc/refman/9.7/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. If you have fixed-length columns that you access or ...
https://dev.mysql.com/doc/refman/9.7/en/file-permissions.html
If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, to give group access to all new directories, start mysqld_safe as follows: UMASK_DIR=504 # = 770 in ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
The number of threads that perform this work is configurable using the innodb_ft_sort_pll_degree variable. The innodb_ft_cache_size variable is used to configure the full-text index cache size (on a per-table basis), which affects how often the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log-buffer.html
The innodb_flush_log_at_trx_commit variable controls how the contents of the log buffer are written and flushed to disk. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer are ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. When using COMPACT row format and variable-length character sets, such as utf8mb4 or sjis, CHAR(N) columns occupy a variable amount of ... Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source-monitoring.html
Note The SHOW VARIABLES statement does not work with multiple replication channels. The information that was available through these variables has been migrated to the replication performance tables. Using a SHOW VARIABLES statement in a topology ...
https://dev.mysql.com/doc/refman/9.7/en/trigger-syntax.html
In the example, the trigger body is a simple SET that accumulates into a user variable the values inserted into the amount column. To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section ...