Search Results
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
A “login path” is an option group containing options that specify which MySQL server to connect to and which account to authenticate as. Most MySQL programs that support option files handle the following options. Because these options affect ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
For example, [client] is the appropriate group to use to specify the password for connecting to the server. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
status_by_host has HOST and VARIABLE_NAME columns to summarize status variables by the host from which clients connected. FLUSH STATUS adds the session status from all active sessions to the global status variables, resets the status of all active ... The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable ...
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 ...