Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
Since there is currently no way using ndb_mgm or the mysql client to remove all data from a specific data node or node group, this means that the command succeeds only in the two following cases: After issuing CREATE NODEGROUP in the ndb_mgm client, ... In addition to the central configuration file, a cluster may also be controlled through a command-line interface available through the management client ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. When a new row is inserted into a partitioned table, it is these ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
Event collection provides access to information about synchronization calls (such as for mutexes) file and table I/O, table locks, and so forth for the server and for several storage engines. Performance Schema tables are considered local to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
(Row-based replication, however, simply replicates the value returned by the function or stored program, so its effect on table rows and data is the same on both the source and replica.) See Section 19.5.1.16, “Replication of Invoked Features”, ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
In older versions of MySQL, the monitoring tables were INFORMATION_SCHEMA tables (see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”). The INFORMATION_SCHEMA tables are deprecated; expect them to be removed in a future version of MySQL.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-process.html
The data and the structures of the InnoDB tables might have changed during this period; so, some of the following steps are for making sure those changes are captured in the backup. It blocks DDL operations (except for those on user-created ... The ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Pluggable authentication makes it possible for clients to ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-2-0.html
NDB Client Programs: When ndb_select_all failed to read all data from the table, it always tried to re-read it. Now when ndb_select_all is unsuccessful at reading all the table data, its behavior is as follows: When the result is non-empty, ... Bugs ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...