Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
They provide information about thread pool operation: tp_connections: Information about thread pool connections. The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 7.6.3, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/en/programs-client.html
This section describes client programs that connect to the MySQL server.
https://dev.mysql.com/doc/refman/8.4/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 LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 ...