PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
Selecting a Release Series When using the MySQL Yum repository, the latest LTS series (currently MySQL 8.4) is selected for installation by default. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is ...
https://dev.mysql.com/doc/refman/8.0/en/manual-info.html
INTO OUTFILE is shorthand for the form of SELECT statement that has an INTO OUTFILE clause following other parts of the statement. This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.43. Differences between ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
mysql> SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%wait/synch/mutex/innodb%'; +-------------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ... A mutex is a synchronization mechanism ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
In such cases, statistical information is not generated, which means a nonoptimal execution plan may be selected. Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb_optimized_node_selection: Determines how SQL node chooses cluster data node to use as transaction coordinator. ndb_use_exact_count: Forces NDB to use a count of records during SELECT COUNT(*) query planning to speed up this type of query. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ps-tables.html
NDB 8.0 provides information in the MySQL Performance Schema about threads and transaction memory usage; NDB 8.0.29 adds ndbcluster plugin threads, and NDB 8.0.30 adds instrumenting for transaction batch memory. These features are described in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
You can use the following query to obtain the needed records from the ndb_binlog_index table on the source: mysqlS'> SELECT -> @file:=SUBSTRING_INDEX(next_file, '/', -1), -> @pos:=next_position -> FROM mysql.ndb_binlog_index -> WHERE epoch = ... In ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
If there is a choice between multiple indexes, MySQL normally uses the index that finds the smallest number of rows (the most selective index). For example: SELECT MIN(key_part2),MAX(key_part2) FROM tbl_name WHERE key_part1=10; To sort or group a ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-issues.html
To use it, just add the keyword EXPLAIN to the front of your SELECT statement: mysql> EXPLAIN SELECT * FROM t1, t2 WHERE t1.i = t2.i; EXPLAIN is discussed in more detail in Section 15.8.2, “EXPLAIN Statement”. Use FORCE INDEX for the scanned ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%pam%'; +--------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------------+---------------+ | authentication_pam ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...