PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. An “event” is anything the server does that takes time and has been instrumented so that timing ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. Modifying system variables with SET GLOBAL is a runtime capability that can be done from clients run locally ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
A parameter which is an operand of a temporal operator has type DATETIME if the operator returns a DATETIME, TIME if the operator returns a TIME, and DATE if the operator returns a DATE. Exceptions: The derived type is TIME and the actual type is ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/replication-administration-status.html
The MASTER_HEARTBEAT_PERIOD setting on the source (set by the CHANGE MASTER TO statement) 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/8.0/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 ...