Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... Note This needs to be done only for ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
drop db_name Delete the database named db_name and all its tables. Caution Do not use this command used if the server was started with the --skip-grant-tables option. This is true even if you precede the password command with flush-privileges on the ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several tables can be used: setup_instruments indicates which instruments are available. An instrument ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
This is similar to the information available from the SHOW REPLICA STATUS statement, but represented in table form. Replicate_Do_Table, Replicate_Ignore_Table, Replicate_Wild_Do_Table, Replicate_Wild_Ignore_Table The names of any tables that were ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of matched rows * 2 The row pointer size is usually four bytes, but may grow in the future for really big tables.
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB tablespaces, use the --early-plugin-load option to load the keyring plugin. When you start the MySQL 8.4 server, it automatically detects ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
The following tables are separated by section, and summarize the MySQL Router options defined in a MySQL Router configuration file. Detailed information about each of these options, such as descriptions and allowed values, is documented below these ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-score.html
ML_SCORE Syntax mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['threshold', 'N'] ['topk', 'N'] ['remove_seen', ...
https://dev.mysql.com/doc/workbench/en/wb-basic-foreign-key.html
Select the table tool again and place another table on the canvas. First, click the invoice_item table; notice that a red border indicates that this table is selected. This creates a foreign key in the invoice_item table, the table on the ...Revert ...