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/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, ...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/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/8.0/en/views.html
The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Views are stored queries that when invoked produce a result set. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/8.0/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-local-connections.html
As an administrator, connect to the server and create an account for a local user who can connect from the ::1 local IPv6 host address: mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass'; For the permitted syntax of IPv6 addresses in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-transporter-errors.html
This section lists error codes, names, and messages that are written to the cluster log in the event of transporter errors. 0x00 TE_NO_ERROR No error 0x01 TE_ERROR_CLOSING_SOCKET Error found during closing of socket 0x02 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-oci-marketplace-deploy.html
See To create a Linux instance for information on how to complete the fields. /etc/my.cnf.d/perf-tuning.cnf is created by /usr/bin/mkcnf based on the selected OCI shape. To deploy MySQL EE on Oracle Cloud Infrastructure, do the following: Open the ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
A global system variable might involve sensitive data such that it should be settable only by a user with direct access to the server host. For example, put these lines in your server my.cnf file: [mysqld] ... SET PERSIST and SET PERSIST_ONLY enable ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
The scope of a prepared statement is the session within which it is created, which as several implications: A prepared statement created in one session is not available to other sessions. A prepared statement created within a stored program ...