Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/option-tracker-component-status-variables.html
option_tracker_usage:Connection control component The number of times that a failed connection attempt has been delayed. option_tracker_usage:Connection DoS control The number of times a failed connection attempt has been delayed. The Option ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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, ...
https://dev.mysql.com/doc/refman/9.7/en/reset-replica.html
RESET REPLICA does not change any replication connection parameters, which include the source's host name and port, the replication user account and its password, the PRIVILEGE_CHECKS_USER account, the REQUIRE_ROW_FORMAT option, the ... RESET ...
https://dev.mysql.com/doc/refman/9.7/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. You should now be able to connect to the MySQL server as root using the new password. You should now be able to connect to ...For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-faq.html
How many concurrent connections does each MySQL Router instance support? A.10. Doing so can decrease network latency, allow a local unix domain socket connection to the application instead of TCP/IP, and typically application servers are easiest to ...Can I run more than one instance of the router application? ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-repair.html
Follow this procedure to repair an InnoDB Cluster that is part of an InnoDB ClusterSet deployment: Using MySQL Shell, connect to any member server in the primary cluster or in one of the replica clusters, using an InnoDB Cluster administrator ...