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-features-timeout.html
The total retry count can be seen in the output of SHOW STATUS; see Section 5.1.9, “Server Status Variables”.
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
As InnoDB evolves, data file formats that are not compatible with prior versions of InnoDB are sometimes required to support new features. To help manage compatibility in upgrade and downgrade situations, and systems that run different versions of ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
row *************************** ID: 10 USER: me HOST: localhost:58834 DB: test COMMAND: Query TIME: 0 STATE: executing INFO: SELECT * FROM performance_schema.processlist ... See Section 5.1.9, “Server Status Variables” TIME The time in seconds ...The MySQL process list indicates the operations currently being performed by the set of threads executing within the ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. Multiple ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard. An error occurs if the json_doc argument is not a valid JSON document or any path argument is ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. At any given time, a transaction may request a lock that ... When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
The minimum MERGE_THRESHOLD value is 1 and the maximum value is 50. If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA ...