MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 91 to 100 of 108 total results

https://dev.mysql.com/doc/refman/5.7/en/query-log.html

The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you ...

13.7.2.5 REPAIR TABLE Statement

https://dev.mysql.com/doc/refman/5.7/en/repair-table.html

Table Repair Considerations REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...

16.1.7.1 Checking Replication Status

https://dev.mysql.com/doc/refman/5.7/en/replication-administration-status.html

This is especially likely when the events have old timestamps; in such cases, if you execute SHOW SLAVE STATUS several times in a relatively short period, you may see this value change back and forth repeatedly between 0 and a relatively large value. The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...

16.4.1.1 Replication and AUTO_INCREMENT

https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html

Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the ...A ...

16.4.1.37 Replication and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html

sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...

16.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html

This variable can take one of the three values described in the following list: COMMIT_ORDER: Dependency information is generated from the source's commit timestamps. Startup Options Used with Binary Logging System Variables Used with Binary ...

5.1.3 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

5.1.6 Server Command Options

https://dev.mysql.com/doc/refman/5.7/en/server-options.html

For information about the implications for binary logging and replication, see the description for SYSDATE() in Section 12.7, “Date and Time Functions” and for SET TIMESTAMP in Section 5.1.7, “Server System Variables”. When you start the ...

5.1.9 Server Status Variables

https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html

Slave_last_heartbeat Shows when the most recent heartbeat signal was received by a replica, as a TIMESTAMP value. To monitor any replication channel, use the LAST_HEARTBEAT_TIMESTAMP column in the replication_connection_status table for the ... The ...

5.1.4 Server System Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html

The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...

Displaying 91 to 100 of 108 total results