Search Results
https://dev.mysql.com/doc/refman/8.4/en/ldml-rules.html
MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and ...This ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first two columns, the first three columns, and so on. If this column is short, reasonably unique, and indexed, ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-backups.html
This section discusses making backups and restoring from them using NDB Cluster replication. We assume that the replication servers have already been configured as covered previously (see Section 25.7.5, “Preparing the NDB Cluster for ...This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to low. The configuration descriptions occur in order of increasing functionality and ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-table-options.html
The only type of statement that can update both an included and an ignored table and still be replicated successfully is a DML statement that has been logged with binlog_format=ROW. The replica checks for and evaluates table options only if either ...First, as a preliminary condition, the replica checks whether statement-based replication is ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
All other information is transferred as text, and can be read by anyone who is able to watch the connection. If the connection between the client and the server goes through an untrusted network, and you are concerned about this, you can use the ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-17.html
It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-cluster-user-accounts.html
Note If the primary InnoDB Cluster was set up by a MySQL Shell version before MySQL Shell 8.0.20, the cluster.setupAdminAccount() command might have been used with the update option to update the privileges of the InnoDB Cluster server configuration ...Each of the user accounts must exist on all of the member servers in the InnoDB Cluster, with the same user name and the same ... Configuring InnoDB Cluster Administrator Accounts Manually Internal User Accounts Created by ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-autocompletion.html
functions: candidate MySQL library (runtime) functions whose names are also keywords. Whether explicit candidate names returned in the result should be filtered using the prefix which is being auto-completed. For example whenever you load a schema, ...The Section 3.1, “MySQL Shell Commands” can be autocompleted in any of the language ...