https://dev.mysql.com/innodb-parameters.html
System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix. For example, to enable or disable the InnoDB adaptive hash index, you can use --innodb-adaptive-hash-index or ...
https://dev.mysql.com/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
https://dev.mysql.com/ipv6-support.html
For example, this command connects over IPv6 to the MySQL server on the local host: shell> mysql -h ::1 To use this capability, two things must be true: Your system must be configured to support IPv6. Support for IPv6 in MySQL includes these ...
https://dev.mysql.com/ipv6-system-support.html
As a simple test to determine whether that is true, try this command: shell> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ... Before MySQL Server can accept IPv6 connections, the ...
https://dev.mysql.com/known-issues.html
(The same is true for the relay logs on a slave server.) mysqlbinlog does not delete temporary files left after a LOAD DATA statement. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see ...
https://dev.mysql.com/large-page-support.html
Some hardware/operating system architectures support memory pages greater than the default (usually 4KB). The actual implementation of this support depends on the underlying hardware and operating system. Applications that perform a lot of memory ...
https://dev.mysql.com/load-data.html
(This is true regardless of whether OPTIONALLY is specified; OPTIONALLY has no effect on input interpretation.) Occurrences of the ENCLOSED BY character preceded by the ESCAPED BY character are interpreted as part of the current field value. INTO ...
https://dev.mysql.com/lock-tables.html
In previous versions of MySQL, it affected locking behavior, but this is no longer true. LOCK TABLES tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE } UNLOCK TABLES MySQL ...
https://dev.mysql.com/locking-functions.html
While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error ...
https://dev.mysql.com/locking-service-udf-interface.html
The same is not true of the user-defined functions (UDFs) that map onto calls to the service routines: The UDFs must be installed before use. This section describes how to use the locking service user-defined function (UDF) interface. To use the C ...
