Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the Web server. To avoid connecting to untrusted servers, clients can establish a secure connection ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-api.html
AutoReconnect: Specifies whether an API node should reconnect fully when disconnected from cluster. ConnectBackoffMaxTime: Specifies longest time in milliseconds (~100ms resolution) to allow between connection attempts to any given data node by this ... The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-top.html
Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the cluster. By default, it attempts to connect to a mysqld running on localhost and port 3306, as the MySQL root ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
The user connects to the server using an encrypted connection and supplies an SSL certificate with the designated Subject value. Such a user then connects to the server with the certificate and any other SSL options required to establish an ... SET ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
Locking also lowers the total time for multiple-connection tests, although the maximum wait time for individual connections might go up because they wait for locks. Suppose that five clients attempt to perform inserts simultaneously as follows: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. For a description of how the Performance Schema maintains rows in this table, ...To set the table size explicitly, set the performance_schema_accounts_size system variable at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
PS_CURRENT_THREAD_ID() Returns a BIGINT UNSIGNED value representing the Performance Schema thread ID assigned to the current connection. mysql> SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | PS_CURRENT_THREAD_ID() | ... MySQL includes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
To connect to a server using a user account that authenticates with this plugin, you must either set up an encrypted connection as described in Section 19.3.1, “Setting Up Replication to Use Encrypted Connections”, or enable the unencrypted ...
https://dev.mysql.com/doc/refman/8.4/en/replication-security.html
In addition, for servers in a replication topology, consider implementing the following security measures: Set up sources and replicas to use encrypted connections to transfer the binary log, which protects this data in motion. Encryption for these ... To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your installation, as described in Chapter 8, ...