PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). (Prior to MySQL 8.0, the optimizer performs comparisons of SPATIAL index values using Cartesian calculations; the ...The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to use for comparisons, and uses calculations appropriate to the ...
https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html
In MySQL 8.0.21 and later, you can specify user credentials for distributed recovery on the START GROUP_REPLICATION statement using the USER, PASSWORD, and DEFAULT_AUTH options, as follows: USER: The replication user for distributed recovery. If you ... START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
The following example starts the server with three different key caches having sizes in a 3:1:1 ratio: $> mysqld --key_buffer_size=6M \ --hot_cache.key_buffer_size=2M \ --cold_cache.key_buffer_size=2M Structured variable values may be set and ... A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-list-add.html
Example mysql> SELECT @@sql_mode; +----------------------------------------+ | @@sql_mode | +----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES | +----------------------------------------+ mysql> SET @@sql_mode = ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version.html
This view provides the current sys schema and MySQL server versions. Note As of MySQL 8.0.18, this view is deprecated and subject to removal in a future MySQL version. For example, use the VERSION() function to retrieve the MySQL server version.
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/8.0/en/triggers.html
Important MySQL triggers activate only for changes made to tables by SQL statements. Triggers do not activate for changes to tables made by APIs that do not transmit SQL statements to the MySQL Server. Additional Resources You may find the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is unknown. You can determine the default storage engine on a MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. For MERGE, the text of a statement that refers to the view and the view ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...