PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/manual-info.html
For example, in the following statement, IF EXISTS is optional: DROP TABLE [IF EXISTS] tbl_name When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars (“|”). Typographical and Syntax ... This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-api-definition.html
If no HostName is specified in a given [mysql] or [api] section of the config.ini file, then an SQL or API node may connect using the corresponding “slot” from any host which can establish a network connection to the management server host ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-configuration-overview.html
Each of the node parameter tables lists the parameters for a given type (ndbd, ndb_mgmd, mysqld, computer, tcp, or shm). All tables include the data type for the parameter, option, or variable, as well as its default, minimum, and maximum values as ...When performing a node restart or an initial node restart, all of the cluster's data nodes must be restarted in turn (also referred to as a rolling ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-cluster-replication.html
Although an NDB Cluster itself depends on the NDB storage engine for clustering functionality, it is not necessary to use NDB as the storage engine for the replica's copies of the replicated tables (see Replication from NDB to other storage engines). By comparing the values of these status variables before and after the execution of statements affecting replicated NDB tables, you can observe the corresponding actions taken on the NDB API level by the replica, which can be useful when monitoring or troubleshooting NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/option-files.html
To specify an alternative login path file name, set the MYSQL_TEST_LOGIN_FILE environment variable. On Windows, MySQL programs read startup options from the files shown in the following table, in the specified order (files listed first are read ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/8.0/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 ... Prior to MySQL 8.0.16, it is not possible to grant ...