https://dev.mysql.com/keyring-udfs-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 server components and plugins to ...
https://dev.mysql.com/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. Reserved words are permitted as ...
https://dev.mysql.com/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 porting ...
https://dev.mysql.com/large-page-support.html
Normally, you put these in an rc file or equivalent startup file that is executed during the system boot sequence, so that the commands execute each time the system starts. Some hardware/operating system architectures support memory pages greater ...
https://dev.mysql.com/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/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/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/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 ...
https://dev.mysql.com/locking-issues.html
External locking occurs when the server and other programs lock MyISAM table files to coordinate among themselves which program can access the tables at which time. MySQL manages contention for table contents using locking: Internal locking is ...
https://dev.mysql.com/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
