Search Results
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-rest-api-reference.html
This is the maximum number (integer) of idling server connections in the connection pool. GET /connection_pool/{name}/status Shows reusedConnections as a count (integer) of client connections that reused a server connection since the application ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-failover.html
In this situation, the partitioned areas of the InnoDB ClusterSet topology begin to diverge from each other, with a different transaction set on each group of servers. To carry out an emergency failover for the primary InnoDB Cluster, follow this ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-password-validation-plugins.html
To make the library file available for use, install it in the plugin directory (the directory named by the plugin_dir system variable). This section describes how to write a server-side password-validation plugin. plugin.h defines the ...The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-processlist-table.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. The value of this column corresponds to the COM_xxx ...The ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-filter-definitions.html
Example: { "filter": { "class": { "name": "general", "event": { "name": "status", "log": { "variable": { "name": "audit_log_connection_policy_value", "value": "::none" } } } } } } Each predefined variable corresponds to a system variable. By writing ...An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
Groups and Permissions 20.1 Groups and Permissions MySQL HeatWave on AWS has three predefined groups. The predefined groups and associated permissions are described in the following tables. Table 20-1 Table 20-2 Table 20-3 Note: The OCI user ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-temporary-tablespace.html
A pool of 10 temporary tablespaces is created when the server is started. Because the pool of session temporary tablespaces is recreated each time the server is started, space IDs for session temporary tablespaces are not persisted when the server ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. The MySQL server can be installed on a variety ', 'of operating systems, including ...Summarize Text To summarize text, perform the following steps: To define the text that you want to summarize, set the @text variable: mysql> SET @text="TextToSummarize"; Replace TextToSummarize with the text that you want to ... The following ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication.html
Section 20.9, “Group Replication Variables” is a reference for the system variables specific to Group Replication. Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time.