Search Results
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, ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/refman/8.4/en/server-plugins.html
MySQL distributions include several plugins that implement server extensions: Plugins for authenticating attempts by clients to connect to MySQL Server. A connection control plugin that enables administrators to introduce an increasing delay after a ... MySQL supports an plugin API that enables creation of server ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-cluster.html
Currently, MySQL Cluster Manager recognises only that an NDB API application is connected to the cluster; the NDB API application itself must be started, stopped, and configured manually. (If this is not specified, MySQL Cluster Manager assigns a ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-data-structures.html
The value may be one of the CONNECT_STAGE_ symbols shown in the following table. This section describes data structures specific to asynchronous C API functions. For information about general-purpose C API data structures, see Section 5.2, “C API ...