PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 10.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
Selecting a Release Series When using the MySQL Yum repository, the latest GA series (currently MySQL 5.7) 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/5.7/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 5.7, through release 5.7.44. Differences between ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/en/mysql-cluster-privilege-distribution.html
If some of the privilege tables are empty, you may see one or more No data - zero rows fetched, selected, or processed warnings when mysql_cluster_move_privileges returns. To verify that the conversion was successful, you can use the stored function ... NDB Cluster supports distribution of MySQL users and privileges across all SQL nodes in an NDB ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/mysql-nutshell.html
The table is created when the first SELECT statement is run against it. This includes SELECT, UPDATE, DELETE, CREATE TABLE, and other SQL statements. This change does not affect text file import or export operations performed with LOAD DATA or ...