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/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-linux-native-aio.html
With synchronous I/O, query threads queue I/O requests, and InnoDB background threads retrieve the queued requests one at a time, issuing a synchronous I/O call for each. InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
FILE_SIZE The apparent size of the file, which represents the maximum size of the file, uncompressed. The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. ACTION_STATEMENT The trigger body; that is, the statement executed when the ...To ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-server.html
The DTrace probes in the MySQL server are designed to provide information about the execution of queries within MySQL and the different areas of the system being utilized during that process. The DTrace probes are organized so that you can follow ...
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
If an incoming sequence is illegal, an error or warning is returned. If an illegal sequence is used in CONVERT(), an error is returned. The minimum multibyte length is 1 and the maximum is 4. Non-Chinese characters are sorted before Chinese ... In ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-row-events.html
This is similar to --base64-output=NEVER but does not exit with an error if a row event is found. # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F ### DELETE FROM test.t ### WHERE ### @1=1 ### ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-avg-latency.html
max_latency The maximum single wait time of timed occurrences of events in the class. total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-latency.html
max_latency The maximum single wait time of timed occurrences of events in the class. total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
To see the values used by a given instance, connect to it and execute a SHOW VARIABLES statement. If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] ... In some ...