Search Results
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM and MEMORY tables. This is also done for any NOT NULL expression when used with only one table. For each table in a join, a simpler WHERE is ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ... REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
In this case, relationship lines between foreign keys in the table will automatically be drawn. This graphical representation makes the relationships between the tables much easier to understand. This means that MyISAM tables that are reverse ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
Possible values include: Iris Setosa Iris Versicolour Iris Virginica Data is stored in the MySQL database in the following schema and tables: ml_data schema: The schema containing training and test dataset tables. Prepare Datasets Create and use the ... This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. Plugins ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
Here are the privileges required by mysqlbackup: The minimum privileges for the MySQL user with which mysqlbackup connects to the server include: SELECT on all databases and tables, for table locks that protect the backups against inconsistency ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...To monitor a cloning operation on the donor MySQL server instance, use the clone stage events, as described in Monitoring Cloning Operations Using Performance Schema Stage ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...