Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
The MySQL server uses several techniques to avoid I/O operations by caching information read from files, so it is possible that statements you might expect to result in I/O events do not do so. Example file I/O event summary information: mysql> ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
By starting the SQL node with the --server-id-bits option (which causes only some of the bits in the server_id to be used for uniquely identifying it) set to less than 32, the remaining bits can be used to store user data. This is used by NDB ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
However, only one request is sent from the MySQL Server, and the read of the index table is handled by the data node. When an ordered index is used, it performs a scan in the same manner as the full table scan, except that it scans only those ...In ... An NdbTransaction consists of a list of operations, each of which is represented by an instance of NdbOperation, NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation (that is, of NdbOperation or one of its child ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
Default Target MySQL Version: For modeling, set this Modeling MySQL preference to your target MySQL Server version. Having the wrong version may generate invalid syntax for your MySQL server. Save snapshot of open editors on close: By default, MySQL ... Commonly used configuration options and preferences include: Rescan for Local MySQL Instances: Right-click on the home screen, and this option will scan your system for MySQL instances and add connection tiles to the home ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-start-transaction.html
If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. It accepts arguments indicating whether to use a consistent snapshot, which transaction isolation level to use, and the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-start-transaction.html
If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. It accepts arguments indicating whether to use a consistent snapshot, which transaction isolation level to use, and the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
The value DISABLE ON REPLICA is used on a replica instead of ENABLE or DISABLE to indicate an event that was created on the replication source server and replicated to the replica, but that is not executed on the replica. This example changes the ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. The file can be read later by MySQL client programs to obtain authentication credentials ... MySQL users should use the following guidelines to keep passwords ...The methods you can use to specify your password when you run client ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variable-tables.html
The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server System Variables”). persisted_variables: Provides a SQL interface to the mysqld-auto.cnf file that stores persisted global system ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
(In this context, DECIMAL column values are regarded as floating-point values.) mysql> SELECT CAST(1 AS UNSIGNED) - 2.0; -> -1.0 The SQL mode affects the result of conversion operations (see Section 7.1.11, “Server SQL Modes”). The BINARY ...