Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
To run the example programs in this tutorial, set up a simple test database and table using the mysql Command-Line Client or MySQL Workbench. Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE ...The Query property can be set through the MySqlScript constructor or by using the Query ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
To run the example programs in this tutorial, set up a simple test database and table using the mysql Command-Line Client or MySQL Workbench. Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE ...The Query property can be set through the MySqlScript constructor or by using the Query ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
WAIT_FOR_EXECUTED_GTID_SET() monitors all the GTIDs that are applied on the server, including transactions that arrive from all replication channels and user clients. Table 14.26 GTID Functions Name Description WAIT_FOR_EXECUTED_GTID_SET() Wait ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. For batched_key_access to have any effect when ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
On Windows systems, innochecksum must be run separately for each user-defined tablespace file. innochecksum --allow-mismatches=1 --write innodb ../data/test/tab1.ibd With --allow-mismatches set to 1, if there is a mismatch at page 600 and another at ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
SQLConnect Yes ISO 92 Connects to a specific driver by data source name, user ID, and password. SQLDriverConnect Yes ODBC Connects to a specific driver by connection string or requests that the Driver Manager and driver display connection dialog ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
SQLConnect Yes ISO 92 Connects to a specific driver by data source name, user ID, and password. SQLDriverConnect Yes ODBC Connects to a specific driver by connection string or requests that the Driver Manager and driver display connection dialog ...
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Client informs about the user account it wants to log into in the Handshake Response Packet. Only then server can look-up the mysql.user ...If the guessed authentication method used either by the client or the server in the initial handshake was not correct, server informs client which authentication method should be used using Authentication Method Switch Request Packet (see Section 14.2.3, “Authentication Method ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. table_id Table ID for this table node_id Node ID for this node block_instance ...See the Notes later in this section to see how you can use this to find out how much memory is used by NDB ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
The following characteristics are relevant for this purpose: READ ONLY READ WRITE ISOLATION LEVEL WITH CONSISTENT SNAPSHOT Available Session State Trackers To support the session-tracking activities, notification is available for these types of ...A ...