PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
The statement information part of the diagnostics area contains these items: NUMBER: An integer indicating the number of condition areas that have information. ROW_COUNT: An integer indicating the number of rows affected by the statement. SQL ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
Use the smallest integer data type for the AUTO_INCREMENT column that is large enough to hold the maximum sequence value you require. See Section 13.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT” for the ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
In addition to enabling fast lookup of related information, foreign keys help to enforce referential integrity, by preventing any of these pointers from becoming invalid as data is inserted, updated, and deleted. See Also child table, FOREIGN KEY ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
Because the InnoDB memcached plugin is tightly integrated with a single memcached daemon, and the in-memory caching mechanism is handled by MySQL and the InnoDB buffer pool, this column is rarely needed. Because the InnoDB memcached plugin is ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
Lock acquisition calls take an integer timeout value that indicates how many seconds to wait to acquire locks before giving up. lock_timeout: An integer number of seconds to wait to acquire the locks before giving up. The final argument is an ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
INET_ATON(expr) Given the dotted-quad representation of an IPv4 network address as a string, returns an integer that represents the numeric value of the address in network byte order (big endian). Because numeric-format IPv6 addresses require more ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-print-backup-file.html
--control-directory-number Command-Line Format --control-directory-number=# Introduced 8.0.24-ndb-8.0.24 Type Integer Default Value 0 Control file directory number. --fragment-id Command-Line Format --fragment-id=# Introduced 8.0.24-ndb-8.0.24 Type ...This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-waiter.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...