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/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password. (The server ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
For example, you can specify options to reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log, and so on. mysql> source ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
If cas_column and expire_time_column fields of the innodb_memcached.containers table are set to NULL, the following error is returned when attempting to load the memcached plugin: InnoDB_Memcached: column 6 in the entry for config table 'containers' ...If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(You can consider the function execution timestamp and random number seed as implicit inputs that are identical on the source and replica.) The FOUND_ROWS() and ROW_COUNT() functions are not replicated reliably using statement-based replication. To ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. The incremental backups are smaller and take less time to produce. The tradeoff is that, at recovery time, you cannot restore your data just by ...For ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 9.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
An error occurs if the table exists, if there is no default database, or if the database does not exist. IF NOT EXISTS Prevents an error from occurring if the table exists. Column Data Types and Attributes There is a hard limit of 4096 columns per ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
Most optimizations cannot deal with predicates that may be turned on and off at query execution time, so they assume any trigcond(X) to be an unknown function and ignore it. IS NULL condition makes query execution slightly more complicated (and some ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. For example, to remove ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...