PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The default settings represent a combination of high reliability and the fewest surprises for database applications. For example, default settings avoid uncommitted data on the database side, or stale data returned for memcached get requests. You ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 21.6.6, “NDB Cluster Single User Mode”). For example, if you put the cluster in single user mode, you can sometimes see data ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For SET or ENUM values, the cast operation causes the underlying numeric value to be used. mysql> SELECT student_name, MIN(test_score), MAX(test_score) FROM student GROUP BY student_name; For MAX(), MySQL currently compares ENUM and SET columns by ... This section describes aggregate functions that operate on sets of ...If you use an aggregate function in a statement ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. A candidate object is contained in a target object if ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
When using a raw disk partition, ensure that the user ID that runs the MySQL server has read and write privileges for that partition. For example, if running the server as the mysql user, the partition must be readable and writeable by mysql. To do ... The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change buffer, and undo ...It ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
Any missing columns are set to their default values, just as happens for INSERT. There are no user-visible effects other than a possible difference in how the storage engine increments Handler_xxx status variables. REPLACE [LOW_PRIORITY | DELAYED] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/security.html
The security is related to the grants for individual users, but you may also wish to restrict MySQL so that it is available only locally on the MySQL server host, or to a limited set of other hosts. These include choosing good passwords, not ...For ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: If the MySQL server cannot find the mysql privileges database or other critical files, it displays these ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...