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/mysql-command-options.html
--otel_exporter_otlp_traces_compression Compression type --otel_exporter_otlp_traces_endpoint The trace export endpoint --otel_exporter_otlp_traces_headers Key-value pairs to be used as headers associated with HTTP requests ... mysql supports the ...
https://dev.mysql.com/doc/refman/9.7/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. --mysqld-safe-log-timestamps Command-Line Format --mysqld-safe-log-timestamps=type Type Enumeration Default ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. Typically, this means from the time the server gets ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-triggers.html
It is sufficient to switch to statement-based replication only for those statements where you want this effect, and to use row-based replication the rest of the time. (Bug #45677) A trigger can have triggers for different combinations of trigger ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-gtids.html
If the server's most recent binary log files do not have GTID log events, for example if gtid_mode=ON was used but the server was later changed to gtid_mode=OFF, this process can take a long time. If the server's older binary log files do not have ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html
The relay log file position (Relay_Log_Pos) is also updated at that time. This means that there is a small window of time during which SHOW REPLICA STATUS shows a nonzero value for Last_SQL_Errno even though Replica_SQL_Running still displays Yes.
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the host. max_latency The maximum single wait time of timed statements for the host. lock_latency The total time waiting for locks by timed statements for the host. The ...