PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) WEIGHT_STRING() Return the weight string for a string XOR Logical XOR YEAR() Return the year YEARWEEK() Return the year and ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-locking.html
Gap locks in InnoDB are “purely inhibitive”, which means that their only purpose is to prevent other transactions from inserting to the gap. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
ndb_recv_thread_cpu_mask Command-Line Format --ndb-recv-thread-cpu-mask=mask System Variable ndb_recv_thread_cpu_mask Scope Global Dynamic Yes SET_VAR Hint Applies No Type Bitmap Default Value [empty] CPU mask for locking receiver threads to ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html
On 32-bit platforms, the supported range of values for this function is the same as for the TIMESTAMP type (see Section 13.2.1, “Date and Time Data Type Syntax”, for range information). On 64-bit platforms, the maximum supported value is ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-system-variables.html
This section lists the system variables that are specific to the Group Replication plugin. The name of each Group Replication system variable is prefixed with group_replication_. Note InnoDB Cluster uses Group Replication, but the default values of ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; ETAG(col [, col[, ...]]) Computes a 128-bit hash for each row, given a comma-separated list of one or more column values. In this case, the GROUPING() return value represents a bitmask combined ...
https://dev.mysql.com/doc/refman/9.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-syntax.html
M indicates the number of bits per value, from 1 to 64. p represents the precision in bits, but MySQL uses this value only to determine whether to use FLOAT or DOUBLE for the resulting data type. For integer data types, M indicates the minimum ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...