Search Results
https://dev.mysql.com/doc/connector-j/en/connecting-using-kerberos.html
Client-side Kerberos configurations In order to operate properly with the Kerberos server, Connector/J requires either a system-wide Kerberos configuration, or these local system property settings for the JVM: -Djava.security.krb5.kdc=[the KDC host ... Kerberos is a ticket-based server-client mutual authentication protocol that is supported by the MySQL Server (commercial versions ...Support for Kerberos is implemented by Connector/J using the GSS-API, JAAS API, and JCA API; ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...The ... The .NET tracing architecture consists of four main parts: Source - This is the originator of the trace ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server. For example, to set the variable to 128MB, start the server like ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
MySQL stores the sql_mode system variable setting in effect when a routine is created or altered, and always executes the routine with this setting in force, regardless of the current server SQL mode when the routine begins executing. The exception ...This behavior can be changed by disabling the automatic_sp_privileges system ...See Section 11.2.5, “Function Name Parsing and Resolution”, for the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
The auto-increment lock mode is configured at startup using the innodb_autoinc_lock_mode variable. innodb_autoinc_lock_mode = 0 (“traditional” lock mode) The traditional lock mode provides the same behavior that existed before the ... InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
Statements in a file named at server startup by the init_file system variable. If the table_encryption_privilege_check system variable is enabled, the TABLE_ENCRYPTION_ADMIN privilege is required to specify a default encryption setting that differs ...(In a stored routine, variables with character data types use the database defaults if the character set or collation are not specified ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
Otherwise, the server considers the attribute buffer valid and tracks the size of the longest such buffer in the Performance_schema_session_connect_attrs_longest_seen status variable. For accepted connections, the Performance Schema checks aggregate ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...For applications based on the C API implemented by the ...
https://dev.mysql.com/doc/internals/en/a-mysql-client-logs-in.html
which responds with a handshake packet which contains the version, some flags and a password challenge.: client -> server 3a 00 00 01 05 a6 03 00 00 00 00 01 08 00 00 00 :............... The client answers with username, some flags and the response ...00 00 27 75 3e 6f 38 66 79 4e 00 ff f7 08 02 00 ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
MySQL Server supports three comment styles: From a # character to the end of the line. (Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style ...In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. After restarting a busy server, there is ...The ...