Search Results
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
The plugin created in this tutorial gets around this problem by using the fact that a naming convention is often used for foreign keys: tablename_primarykeyname. They are often created for existing databases, to clarify their purpose or document ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
ndbinfo is included with NDB Cluster support in the MySQL Server; no special compilation or configuration steps are required; the tables are created by the MySQL Server when it connects to the cluster. This database contains a number of tables, each ... ndbinfo is a database containing information specific to NDB ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-information-schema-plugins.html
It creates a simple INFORMATION_SCHEMA table named SIMPLE_I_S_TABLE that has two columns named NAME and VALUE. This section describes how to write a server-side INFORMATION_SCHEMA table plugin. To write an INFORMATION_SCHEMA table plugin, include ...For example code that implements such plugins, see the sql/sql_show.cc file of a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE option of the CREATE USER and ALTER USER statements. To establish policy for individual accounts, use the PASSWORD HISTORY and PASSWORD REUSE INTERVAL options of the CREATE USER ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #36259487) InnoDB: A schema mismatch was possible when a table was imported with a different sql_mode than when it was created, because strict mode influences the number of nullable columns in a table's secondary index. In certain rare cases, a ...This had an adverse effect on queries using joins on InnoDB ... C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. With row-based format, DML statements are handled based on the database where the modified table ...It is also important to note that the results vary ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. You can create tables with ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...