PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
For full-text indexes, the PAGE_NO column is unused and set to -1 (FIL_NULL) because the full-text index is laid out in several B-trees (auxiliary tables). The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html
For techniques to organize database operations to avoid deadlocks, see Section 14.7.5, “Deadlocks in InnoDB”. At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-security.html
For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. By default, contents of audit log files produced by the audit log plugin are not ...
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... If clients encounter Too many connections errors when attempting to ...
https://dev.mysql.com/doc/refman/5.7/en/views.html
Additional Resources You may find the MySQL User Forums helpful when working with views. Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some ...There are some restrictions on the use of views; see Section 23.9, “Restrictions on ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The purge operation can write disk blocks for a series of index values more efficiently than if each value were written to disk immediately. During this time, disk I/O is increased, which can cause a significant slowdown for disk-bound queries. The ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
For example, before upgrading from MySQL 5.6 to 5.7, use mysqladmin from MySQL 5.6 as follows: C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, invoke mysqladmin with ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
To use CHANGE MASTER TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). When this is true for all replicas, they can be reconfigured to the new setup. During this procedure, do not forget to ...The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary ...