Search Results
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features to be supported or ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-general.html
Important If you attempt to use NDB Cluster Replication with --binlog-format=STATEMENT, replication fails to work properly because the ndb_binlog_index table on the source cluster and the epoch column of the ndb_apply_status table on the replica ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-issues.html
Use ANALYZE TABLE tbl_name to update the key distributions for the scanned table. Use FORCE INDEX for the scanned table to tell MySQL that table scans are very expensive compared to using the given index: SELECT * FROM t1, t2 FORCE INDEX ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
On Windows, MySQL programs read startup options from the files shown in the following table, in the specified order (files listed first are read first, files read later take precedence). On Unix and Unix-like systems, MySQL programs read startup ...
https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/9.7/en/partial-revokes.html
For example, it is possible to permit an account to modify any table except those in the mysql system schema. The result indicates that u1 has global SELECT and INSERT privileges, except that INSERT cannot be exercised for tables in the world schema. That is, access by u1 to world tables is read ... It is possible to grant privileges that apply globally ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-functions.html
The units indicator depends on the size of the byte-count argument as shown in the following table. The units indicator depends on the size of the time-value argument as shown in the following table. The thread ID return value is a value of the type ... MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-authentication-system-variables.html
When a MySQL account authenticates using LDAP, MySQL server attempts to establish a TCP connection with the LDAP server, which it uses to send an LDAP bind request over the connection. The following table shows the permitted level values and their ...The file name should be given as an absolute path ...
https://dev.mysql.com/doc/refman/9.7/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...