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/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
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/file-permissions.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld ...If this is unsuitable, create the error file manually with the desired access mode prior to executing ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
All servers therefore receive the same set of transactions in the same order, and a global total order is established for the transactions. The replication group is a set of servers that each have their own entire copy of the data (a shared-nothing ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. In cases where you have additional software safeguards, ultra-reliable hardware, or ...Because of the many possibilities depending on the capabilities of your CPU, network, and storage devices, this aspect is the most complicated to provide concrete guidelines ...MySQL includes components such as the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-turning-off.html
Oracle recommends InnoDB as the preferred storage engine for typical database applications, from single-user wikis and blogs running on a local system, to high-end applications pushing the limits of performance. In MySQL 5.7, InnoDB is the default ...The --skip-innodb option is deprecated and has no effect, and its use results in a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. The creator of a routine is the account used to execute the ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...MySQL offers a variety of backup strategies from which you can choose the methods that best suit the requirements for your ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
This is useful when you want to store a “possibly wrong” value which the user has specified (for example, in a web form) in the database for future processing. The date and time data types for representing temporal values are DATE, TIME, ...