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/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
If you want the association to take effect each time the server starts, one way to accomplish this is to use an option file: Include variable settings that configure your key caches, and an init_file system variable that names a file containing ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-failure-detection.html
If a member does not receive messages from another member for 5 seconds, it suspects that the member has failed, and lists the status of that member as UNREACHABLE in its own Performance Schema table replication_group_members. If a suspicion lasts ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
If a key to be copied already exists in the destination keystore, an error occurs and the destination keystore is restored to its premigration state. A migration server reports errors to the console (the standard error output). If an error occurs ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-compared.html
Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. MySQL Server offers a number of choices in storage engines. They see NDB as a possible alternative or ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<cache>(expr) The expression (such as a scalar subquery) is executed once and the resulting value is saved in memory for later use. For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
In this case, the second SELECT statement in the preceding scenario would execute before the UPDATE statement, and would not wait for the first SELECT to finish. But because only one session can write to a table at any one time, for best performance ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...