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/replication-bugs.html
If you have a repeatable test case that demonstrates the bug, please enter it into our bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. In this case, the replication SQL thread stops and waits for you ... When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
INTO OUTFILE do not overwrite existing files and are writable by everyone. With this privilege, you can read any file into a database table. This could be abused, for example, by using LOAD DATA to load /etc/passwd into a table, which then can be ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
When using compressed tables, the reported Innodb_buffer_pool_pages_data value may be larger than Innodb_buffer_pool_pages_total (Bug #59550) Innodb_buffer_pool_read_ahead The number of pages read into the InnoDB buffer pool by the read-ahead ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
For binary or case-sensitive collations, lettercase is taken into account when assigning values to the column. For example, you can retrieve numeric values from a SET column like this: mysql> SELECT set_col+0 FROM tbl_name; If a number is stored ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
In the third and final phase, the sorted entries are inserted into the B-tree. Prior to the introduction of sorted index builds, index entries were inserted into the B-tree one record at a time using insert APIs. This method involved opening a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
Results from queries can be retrieved into local variables using SELECT ... INTO var_list or by opening a cursor and using FETCH ... System variables and user-defined variables can be used in stored programs, just as they can be used outside ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT CHAR(77,121,83,81,'76'); -> 'MySQL' mysql> SELECT CHAR(77,77.3,'77.3'); -> 'MMM' CHAR() arguments larger than 255 are converted into multiple result bytes. A newline is added after each 76 characters of encoded output to divide long ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
This is done by pushing down an appropriate equality into the subquery's WHERE clause to make it more restrictive. To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
To load the time zone tables from the command line, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program. To use an SQL-statement time zone package that you have downloaded, unpack it, then load the ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
[UNION [ALL | DISTINCT] SELECT ...] UNION combines the result from multiple SELECT statements into a single result set. If the data types of corresponding SELECT columns do not match, the types and lengths of the columns in the UNION result take ...