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/point-in-time-recovery-binlog.html
To apply events from the binary log, process mysqlbinlog output using the mysql client: $> mysqlbinlog binlog_files | mysql -u root -p Viewing log contents can be useful when you need to determine event times or positions to select partial log ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-literals.html
MySQL also recognizes the ODBC syntax corresponding to the standard SQL syntax: { d 'str' } { t 'str' } { ts 'str' } MySQL uses the type keywords and the ODBC constructions to produce DATE, TIME, and DATETIME values, respectively, including a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
log_slow_slave_statements Command-Line Format --log-slow-slave-statements[={OFF|ON}] System Variable log_slow_slave_statements Scope Global Dynamic Yes Type Boolean Default Value OFF When the slow query log is enabled, this variable enables logging ...--master-retry-count=count Command-Line Format --master-retry-count=# Deprecated Yes Type Integer Default Value 86400 Minimum Value 0 Maximum Value (64-bit platforms) 18446744073709551615 Maximum Value (32-bit platforms) 4294967295 The number of times that the replica tries to reconnect to the source before giving ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-recovering-from-a-point-in-time.html
The second part is incremented every time a view change happens. To synchronize the server joining the group with the donor up to a specific point in time, the server joining the group and donor make use of the MySQL Global Transaction Identifiers ...This is the job of binary log view markers, which mark view changes in the binary log stream, and also contain additional metadata information, provisioning the server joining the group with missing certification related ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
The command-start and command-done probes are best used when combined with the statement probes to get an idea of overall execution time. The probe includes a single argument, status, which returns 0 when the query is successfully executed and 1 if ...The status argument contains 0 if the command executed successfully, or 1 if the statement was terminated before normal ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
MySQL permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
Conversion of DATETIME and TIMESTAMP values: Conversion to a DATE value takes fractional seconds into account and rounds the time part. To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the ...For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html
Point-in-time recovery refers to recovery of data changes up to a given point in time. Typically, this type of recovery is performed after restoring a full backup that brings the server to its state as of the time the backup was made. (The full ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
For temporal types that include a date part (DATE, DATETIME, and TIMESTAMP), use of these values may produce warning or errors. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. The ...Each ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Sometimes people try to insert gbk characters into gb2312, and it works most of the time because gbk is a superset of gb2312. Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...