PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-processlist-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The MySQL process list indicates the operations currently being performed by the set of threads ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-filters-table.html
This table shows the replication channel specific filters configured on this replica. Each row provides information on a replication channel's configured type of filter. The replication_applier_filters table has these columns: CHANNEL_NAME The name ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-global-filters-table.html
This table shows the global replication filters configured on this replica. The replication_applier_global_filters table has these columns: FILTER_NAME The type of replication filter that has been configured. FILTER_RULE The rules configured for ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-tables.html
The following Performance Schema replication tables continue to be populated when the Performance Schema is disabled: replication_connection_configuration replication_connection_status replication_asynchronous_connection_failover ...This is similar ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-threads-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The threads table contains a row for each server thread. Each row contains information about a ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-group-state-table.html
QUERY_THREADS_COUNT same as num_query_threads, but used for different purposes? TIME_OF_EARLIEST_CON_EXPIRE A timestamp showing the earliest point in time when a connection is expected to expire. The tp_thread_group_state table has one row per ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-state-table.html
TIME_OF_ATTACH: Timestamp showing when the thread was attached, if attached to a connection; otherwise NULL. The tp_thread_state table has one row per thread created by the thread pool to handle connections. The tp_thread_state table has these ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-null.html
Under certain conditions, if you insert NULL into a TIMESTAMP column, the current date and time is inserted; this behavior depends in part on the server SQL mode (see Section 7.1.11, “Server SQL Modes”) as well as the value of the ... The ...
https://dev.mysql.com/doc/refman/9.7/en/query-log.html
The log_timestamps system variable controls the time zone of timestamps in messages written to the general query log file (as well as to the slow query log file and the error log). The general query log is a general record of what mysqld is doing.
https://dev.mysql.com/doc/refman/9.7/en/repair-table.html
REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format; namely, the TIME, DATETIME, and TIMESTAMP columns that lacked support for fractional seconds precision. [QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a ...