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/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/sys-innodb-lock-waits.html
blocking_trx_age How long the blocking transaction has been executing, as a TIME value. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been ... These views summarize the InnoDB locks that transactions are waiting ...
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/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/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/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/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/performance-schema-query-profiling.html
Performance Schema displays event timer information in picoseconds (trillionths of a second) to normalize timing data to a standard unit. In the following example, TIMER_WAIT values are divided by 1000000000000 to show data in units of seconds. The ... The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all 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 ...