Search Results
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. It is a fast way to generate random numbers on demand that is portable between ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
If possible, classify reports as “live” or as “statistical”, where data needed for statistical reports is created only from summary tables that are generated periodically from the live data. To fix any compression issues that occur with ...
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encrypted-innodb-options.html
MySQL Enterprise Backup supports encrypted InnoDB tablespaces and encrypted binary/relay logs. See Chapter 6, Working with Encrypted InnoDB Tablespaces and Section 8.4, “Working with Encrypted Binary and Relay Logs” on how mysqlbackup commands ...For details on how MySQL Server encrypts and decrypts these items, see InnoDB Data-at-Rest Encryption and Encrypting Binary Log Files and Relay Log ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-innodb.html
Note To avoid concurrency issues during backups of busy databases, you can use the --only-innodb option to back up only InnoDB tables and the associated data. If you use the compressed backup feature, the .ibd files are renamed in their compressed ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-issues-mysql-cluster.html
You can also back up NDB databases and tables using the ndb_mgm client START BACKUP command, and restore them using the ndb_restore program; however MySQL Cluster Manager is not aware of backups that it was not employed to create. You can back up ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-added.html
REORGANIZE PARTITION steps is to make use of the logical backup of the NDB tables' metadata, which is part of the cluster backup created by MySQL Cluster Manager. An alternative to generating and running the ALTER ONLINE TABLE ... Restore the ... A ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-requirements.html
To restore a backup created by MySQL Cluster Manager to a cluster with fewer data nodes, you need to restore first the logical backup of the metadata of the NDB tables using the mysqldump utility and then restore the table data using the ndb_restore ...In such cases data is not automatically distributed to the new nodes, and, following the restore, you must redistribute the data manually by issuing an ALTER ONLINE TABLE ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
The st_mysql_show_var structure has this definition: struct st_mysql_show_var { const char *name; char *value; enum enum_mysql_show_type type; }; The following table shows the permissible status variable type values and what the corresponding ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explanations-ml-explain-row.html
The column names must match the feature column names in the trained table. mysql> SELECT sys.ML_EXPLAIN_ROW(input_data, model_handle, [options]); In the following example, include the session variable previously created. mysql> CALL sys.ML_EXPLAIN ... ML_EXPLAIN_ROW explains predictions for one or more rows of unlabeled ...