PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. The value shown in this column is one of CONNECTION_HANDLER_WORKER_THREAD, LISTENER_WORKER_THREAD, QUERY_WORKER_THREAD, or TIMER_WORKER_THREAD. Note ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
Memory Caches: Different applications respond better to some memory caching strategies than others, so although some memory caches are common to all storage engines (such as those used for user connections), others are uniquely defined only when a ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
If auto-reconnect is enabled, the client is not notified that the connection was lost. If all operands of the operator are parameters, the derived type is VARCHAR; its collation is determined by the value of collation_connection. If all operands of ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-mysql-sock.html
You can test whether the new socket location works by attempting to connect to the server with this command: $> mysqladmin --socket=/path/to/socket version . The default location for the Unix socket file that the server uses for communication with ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
Id is the connection identifier for the client associated with the thread. The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list entries. The other sources have negative performance consequences because they require a ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. List the options in an option file that ...
https://dev.mysql.com/doc/refman/8.0/en/programs-client.html
This section describes client programs that connect to the MySQL server.
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
However, if a replica is not connected and you happen to purge one of the log files it has yet to read, the replica cannot replicate after it reconnects. PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration.html
In addition, InnoDB Cluster interfaces seamlessly with MySQL Router, which enables your applications to connect to the cluster without writing your own failover process. Once replication has been started it executes without requiring much regular ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
To address the issue, connect to the replica manually and determine the cause of the problem. If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a ...