PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
SRID values must be unique, so if neither OR REPLACE nor IF NOT EXISTS is specified, an error occurs if an SRS definition with the given srid value already exists. srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' ...With CREATE OR REPLACE syntax, any existing SRS definition with the same SRID value is replaced, unless the SRID value is used by some column in an existing ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and files. If the _trace_ variable is enabled, an error is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. To change the set of key sequences permitted by a given input library, ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. When you store data ...The name of this file is the same as the name of the table with the extension ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-notes.html
Removing: After you have copied over the MySQL database files from the previous installation and have successfully started the new server, you should consider removing the old installation files to save disk space. Users: You may need (or want) to ... You should keep the following issues and notes in mind: Other MySQL installations: The installation procedure does not recognize MySQL installations by package managers such as ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
The ENUM type has these advantages: Compact data storage in situations where a column has a limited set of possible values. See Section 13.7, “Data Type Storage Requirements” for storage requirements for the ENUM type. The index value of the ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In the example just given, the buffer B1 used to join tables t1 and t2 must be a regular buffer. Then the BKA algorithm builds keys to access the table to be joined for all rows in the buffer and submits these keys in a batch to the database engine ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html
In the select list of a query, a quoted column alias can be specified using identifier or string quoting characters: SELECT 1 AS `one`, 2 AS 'two'; Elsewhere in the statement, quoted references to the alias must use identifier quoting or the ...This ... An alias can be used in a query select list to give a column a different ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). A global system variable might involve ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logging-management-commands.html
Table 25.54 Cluster log categories, with default threshold setting Category Default threshold (All data nodes) STARTUP 7 SHUTDOWN 7 STATISTICS 7 CHECKPOINT 7 NODERESTART 7 CONNECTION 8 ERROR 15 INFO 7 BACKUP 15 CONGESTION 7 SCHEMA 7 The STATISTICS ...In the listing that follows, node_id denotes either a storage node ID or the keyword ALL, which indicates that the command should be applied to all of the cluster's data ...