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/stored-routines-privileges.html
This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted automatically to the creator of a routine if necessary (and dropped from ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
Alternatively, if mysqld is not running, symlinking can be accomplished manually using ln -s from the command line. This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have write ...For files used by tables for other storage engines, you may get strange problems if you try to use symbolic ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
Objects in this schema include: Views that summarize Performance Schema data into more easily understandable form. You can drop the sys schema manually after initialization if it is unneeded. To permit this behavior to be suppressed, mysql_upgrade ... MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. You can use OPTIMIZE TABLE to analyze the table and pack it into a smaller format (for a reason to use OPTIMIZE TABLE, see ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
Searches for ligatures also match uppercase ligatures when using the gb18030_unicode_520_ci collation. Use this collation if you need to ensure that ligatures are sorted correctly. In MySQL, the gb18030 character set corresponds to the “Chinese ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. InnoDB performs row-level locking ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
Phone numbers can be given in very different formats: +7-12345-67 +7-12-345-67 +7 12 345 67 +7 (12) 345 67 +71234567 The problem raised by dealing with these kinds of values is that the varying permissible formats make searching for a specific phone ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
In this case, the MySQL distribution need not have been compiled using OpenSSL as long as the openssl command is available. Automatic SSL and RSA File Generation Manual SSL and RSA File Generation Using mysql_ssl_rsa_setup SSL and RSA File ...For ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
The location of this default directory is the same as for the keyring_file_data system variable. See the description of that variable for details, as well as for considerations to take into account if you create the directory manually. The location ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin ...