PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgm.html
Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ...The ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...If you are unfamiliar with the LDML rules used to ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Any partition-level MAX_ROWS setting for p must be the same as the table-level MAX_ROWS value set for nt. The setting for any partition-level MIN_ROWS setting for p must also be the same any table-level MIN_ROWS value set for nt. EXCHANGE PARTITION ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. | ...This is generally useful when a search ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
In addition, the table is compressed periodically at a user-configurable rate; see mysql.gtid_executed Table Compression, for more information. For example, the values stored by the gtid_executed and gtid_purged system variables are GTID sets. The ...If a client transaction is not written to the binary log (for example, because the transaction was filtered out, or the transaction was read-only), it is not assigned a GTID on the server of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. Note Comparison behavior for database and table names in INFORMATION_SCHEMA queries might differ from what you expect. 1) Try to use constant lookup values for ...Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more ...The ENGINE (storage engine) value can be determined by ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
DATE_FORMAT() returns a string with a character set and collation given by character_set_connection and collation_connection so that it can return month and weekday names containing non-ASCII characters. This means, for example, that “zero” ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
InnoDB performs row-level locking in such a way that when it searches or scans a table index, it sets shared or exclusive locks on the index records it encounters. A SPATIAL index contains minimum bounding rectangle (MBR) values, so InnoDB enforces ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...