PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/processlist-access.html
Time indicates how long the thread has been in its current state. The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. For a replica SQL thread, the value is the number of ... The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list ...
https://dev.mysql.com/doc/refman/9.7/en/program-options.html
This is common for options that you want the program to use each time it runs. This method is useful for options that you want to apply each time the program runs. Options are processed in order, so if an option is specified multiple times, the last ... There are several ways to specify options for MySQL programs: List the options on the command line following the program ...
https://dev.mysql.com/doc/refman/9.7/en/programs-overview.html
mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time zones). Later sections provide a more detailed description of each one, with ...
https://dev.mysql.com/doc/refman/9.7/en/query-log.html
To disable or enable the general query log or change the log file name at runtime, use the global general_log and general_log_file system variables. You can also rename the general query log file at runtime by disabling the log: SET GLOBAL ... The ...
https://dev.mysql.com/doc/refman/9.7/en/replication-administration-skip.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. For instructions to do this, see Section 9.5, “Point-in-Time (Incremental) Recovery”. When you issue the START REPLICA statement for the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-administration-status.html
The SOURCE_HEARTBEAT_PERIOD setting on the source (set by CHANGE REPLICATION SOURCE TO) specifies the frequency of the heartbeat, which defaults to half of the connection timeout interval for the replica (specified by the system variable ... The ...
https://dev.mysql.com/doc/refman/9.7/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. Please spend some time and effort in preparing a good bug report. We need to obtain ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
rpl_semi_sync_master_timeout Command-Line Format --rpl-semi-sync-master-timeout=# Deprecated Yes System Variable rpl_semi_sync_master_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10000 Minimum Value 0 Maximum ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/9.7/en/show-engine.html
An NdbTransaction is created each time a table schema operation (such as CREATE TABLE or ALTER TABLE) is performed on an NDB table. In general, one of these is created each time a data manipulation statement is performed by an SQL node. SHOW ENGINE ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...To free up resources taken up by parsed query and statement parameters, call PreparedStatement.deallocate(), which closes the prepared statement and frees its ...