PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/keyring-component-installation.html
Note Only one keyring component or plugin should be enabled at a time. Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions here. To use a keyring plugin instead, ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-functions-general-purpose.html
That is, the value of the CURRENT_USER() function at the time of key manipulation must have the same value as when the key was stored in the keyring. MySQL Server supports a keyring service that enables internal components and plugins to store ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-plugin-installation.html
Note Only one keyring component or plugin should be enabled at a time. Keyring service consumers require that a keyring component or plugin be installed: To use a keyring plugin, begin with the instructions here. (Also, for general information ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/known-issues.html
The default value of max_sort_length is 1024 and can be changed at server startup time or at runtime. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging ...
https://dev.mysql.com/doc/refman/9.7/en/legacy-hashing-component.html
Note Exploits for the MD5 and SHA-1 algorithms have become known. You may wish to consider using another one-way encryption algorithm instead, such as the SHA2() function. The legacy hashing component calclulates an MD5 and SHA-1 checksum for the ...
https://dev.mysql.com/doc/refman/9.7/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you need only a specified ...
https://dev.mysql.com/doc/refman/9.7/en/loading-tables.html
When you want to add new records one at a time, the INSERT statement is useful. Suppose that your pet records can be described as shown here. You could create a text file pet.txt containing one record per line, with values separated by tabs, and ...
https://dev.mysql.com/doc/refman/9.7/en/lock-instance-for-backup.html
WITH READ LOCK; LOCK INSTANCE FOR BACKUP; UNLOCK INSTANCE; UNLOCK TABLES; The lock_wait_timeout setting defines the amount of time that a LOCK INSTANCE FOR BACKUP statement waits to acquire a lock before giving up. LOCK INSTANCE FOR BACKUP UNLOCK ...
https://dev.mysql.com/doc/refman/9.7/en/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...