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/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
To summarize, MySQL Group Replication guarantees that the database service is continuously available. To summarize, MySQL Group Replication provides a highly available, highly elastic, dependable MySQL service. Tip To deploy multiple instances of ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The import server uses /tmp/mysql-files as the directory named by its secure_file_priv ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open files. To do so, encode the -c memcached option in the daemon_memcached_option configuration parameter in the MySQL ... This ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
As of MySQL 8.0.17, to enable detection of lock-acquisition deadlocks and enforcement that runtime execution is free of them, MySQL supports LOCK_ORDER tooling. The MySQL server is a multithreaded application that uses numerous internal locking and ...Within the server, the set of lock-related objects changes with implementation of new features and code refactoring for performance ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. Use the ...The ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
(For more information, see Section 12.8.5, “The binary Collation Compared to _bin Collations”.) Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information ... A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. This chapter provides a tutorial introduction to MySQL by ...If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it ...