PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/merge-table-advantages.html
This makes MERGE indexes much slower on eq_ref searches, but not much slower on ref searches. A MERGE table structured this way could be much faster than using a single large table. If you know exactly what you are looking for, you can search in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
This section provides a simplified outline of the steps involved when NDB Cluster data nodes are started. This occurs either when the cluster started for the very first time, or when all data nodes are restarted using the --initial option. This ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication plugins. This includes removal of the mysql_old_password authentication plugin ...Also, secure_auth cannot be disabled, and old_passwords cannot be set ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
This enables the external user to be a proxy for the second user; that is, to assume the privileges of the second user: The external user is a “proxy user” (a user who can impersonate or become known as another user). In this case, employee_ext ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
In this case, gap locking is disabled for searches and index scans and is used only for foreign-key constraint checking and duplicate-key checking. In this case, InnoDB uses next-key locks for searches and index scans, which prevents phantom rows ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at https://dev.mysql.com/doc/. You can also use http://www.mysql.com/search/ to ...We try to keep the manual up to date by updating it frequently with solutions to newly found ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
EVENT_DEFINITION The text of the SQL statement making up the event's DO clause; in other words, the statement executed by this event. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-using-management-client.html
This identifier is saved in the cluster log, if it has not been configured otherwise. At this point in the backup process the cluster has received and processed the backup request. This can be overridden for one or more data nodes individually, or ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
For example, to include the /home/mydir/myopt.cnf file, use the following directive: !include /home/mydir/myopt.cnf To search the /home/mydir directory and read option files found there, use this directive: !includedir /home/mydir MySQL makes no ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
This section discusses these optimizations, particularly with regard to the challenges that NULL values present. This is done by pushing down an appropriate equality into the subquery's WHERE clause to make it more restrictive. The converted ...