PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--server-id-bits=N Command-Line Format --server-id-bits=# Type Numeric Default Value 32 Minimum Value 7 Maximum Value 32 Use only the first N bits of the server_id to identify the server. If the binary log was written by a mysqld with server-id-bits ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
Although an individual BIT column is not 4-byte aligned, NDB reserves 4 bytes (32 bits) per row for the first 1-32 bits needed for BIT columns, then another 4 bytes for bits 33-64, and so on. InnoDB Table Storage Requirements NDB Table Storage ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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, beginning with MySQL 8.0.28, the ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-enterprise-monitor.html
For information about MySQL Enterprise Monitor behavior, see the MySQL Enterprise Monitor manual: https://dev.mysql.com/doc/mysql-monitor/en/. Important MySQL Enterprise Monitor will be end of life and deprecated with obsolescence as of January 1, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Such implicit casts are now performed between temporal types (DATE, DATETIME, TIMESTAMP, TIME) and numeric types (SMALLINT, TINYINT, MEDIUMINT, INT/INTEGER, BIGINT; DECIMAL/NUMERIC; FLOAT, DOUBLE, REAL; BIT) whenever they are compared using any of ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/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 ...