Search Results
https://dev.mysql.com/doc/refman/9.7/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Your MySQL connection id is 3 Server version: 9.7.0 Source ...Due to ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. For a description of how the Performance Schema maintains rows in ...To set the table size explicitly, set the performance_schema_hosts_size system variable at server ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. For a description of how the Performance Schema maintains rows in this table, ...
https://dev.mysql.com/doc/refman/9.7/en/start-replica.html
START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...uuid: ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-sha2-cache-plugin.html
You can use X Plugin to authenticate against such accounts using non-SSL connections with SHA256_MEMORY authentication and SSL connections with PLAIN authentication. Before you can use non-SSL X Protocol connections to authenticate an account that ... X Plugin supports MySQL user accounts created with the caching_sha2_password authentication ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-builtin-thread.html
The built-in MySQL Shell report thread provides detailed information about a specific thread in the connected MySQL server. By default, the report shows information on the thread used by the current connection, or you can identify a thread by its ...The report works with servers running all supported MySQL 5.7 and MySQL 8.0 ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/registered-routers.html
Read-Only (roPort) and Read-Write (rwPort) ports, which the MySQL Router publishes for classic MySQL protocol connections. Read-Only (roXPort) and Read-Write (rwXPort) ports, which the MySQL Router publishes for X Protocol connections. Read-Write ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-asynchronous-interface-usage.html
The asynchronous C API functions cover operations that might otherwise block when reading to or writing from the server connection: The initial connection operation, sending a query, reading the result, and so forth. Asynchronous Function ... This ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-audit-plugins.html
For example, for MYSQL_AUDIT_CONNECTION_CLASS (the class that covers connect and disconnect events), plugin_audit.h defines these symbols: typedef enum { /** occurs after authentication phase is completed. */ MYSQL_AUDIT_CONNECTION_CONNECT = 1 << 0, ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...