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/encrypted-connection-protocols-ciphers.html
To determine the value of tls_version at runtime, use this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'tls_version'; +---------------+-----------------------+ | Variable_name | Value | +---------------+-----------------------+ | tls_version | ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL server. To tell mysqld ...You can either tell mysqld not to open so many files at once or increase the number of file descriptors available to ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
If the option is given without a value, the timeout is set to 300 seconds. To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form ...However, in most ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
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/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/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...But for some questions, the only information that matters is whether there is a match, not the number of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
If a row does not exceed the maximum row length, all of it is stored locally within the page. If a row exceeds the maximum row length, variable-length columns are chosen for external off-page storage until the row fits within the maximum row length ...(These segments are different from the rollback segment, which actually contains many tablespace segments.) When a segment grows inside the tablespace, InnoDB allocates the first 32 pages to it one at a ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ...Type The ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
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). The second user is a ...The ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
If this happens, the attempt to add back the excluded member from the group results in an error with the message This member has more executed transactions than those present in the group. For example, in the above scenario of 5 servers where 3 ...