Search Results
https://dev.mysql.com/doc/refman/9.7/en/lock-order-tool.html
To run the server with the LOCK_ORDER tool enabled, enable the lock_order system variable at server startup. lock_order_dependencies Command-Line Format --lock-order-dependencies=file_name System Variable lock_order_dependencies Scope Global Dynamic ...Several other system variables for LOCK_ORDER configuration are available as ... The MySQL server is a multithreaded application that uses numerous internal locking and lock-related ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-replication.html
Verify that the skip_networking system variable has not been enabled in the configuration file for either server. How do I tell whether a replication source server is using statement-based or row-based binary logging format? Check the value of the ...How can I use replication to improve performance of my system? Set up one server as the source and direct all writes to ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-using-ssl.html
The system works through two Java keystore files: one file contains the certificate information for the server (truststore in the examples below), and another contains the keys and certificate for the client (keystore in the examples below). All ...
https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html
MySQL Connector/NET 9.x series is a continuation of Connector/NET 8.x series, but now named to synchronize with the (latest) MySQL server version it supports. For general guidance about configuring the server and clients for secure connections, see ...This version continues the functionality of the previous Connector/NET release series, including support for X Protocol ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
row *************************** user: root plugin: auth_socket To verify that the auth_socket plugin works, log in to the MySQL server host as the operating system root user and then connect to the MySQL server locally as the MySQL root user. When ...This deployment uses the caching_sha2_password and auth_socket authentication plugins for user ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.html
The system works through two Java keystore files: one file contains the certificate information for the server (truststore in the examples below), and another contains the keys and certificate for the client (keystore in the examples below). All ...
https://dev.mysql.com/doc/mysql-errors/9.7/en/client-error-reference.html
Here is an example client error message, as displayed by the mysql client: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0) Each client error message includes an error code, SQLSTATE value, and message ...
https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html
If the value is NULL (the default), the global expiration policy applies, as defined by the default_password_lifetime system variable. The mysql system database includes several grant tables that contain information about user accounts and the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. For example, if a mutex is instrumented in the server source but the server cannot allocate memory for ...Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
Protocol::Handshake Initial Handshake Packet When the client connects to the server the server sends a handshake packet to the client. Depending on the server version and configuration options different variants of the initial packet are sent. To ...Since 3.21.0 the Protocol::HandshakeV10 is sent, while it was still supporting Protocol::HandshakeV9 with a compile time ...