Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
If the compressed page size is set too small, inserts or updates may require time-consuming recompression, and the B-tree nodes may have to be split more frequently, leading to bigger data files and less efficient indexing. Whether to adjust the ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html
The file location is the %APPDATA%\MySQL directory on Windows and the current user's home directory on non-Windows systems. Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
A normalized statement does not retain information such as names, passwords, dates, and so forth. These columns store sample statement information: QUERY_SAMPLE_TEXT (the text of the statement), QUERY_SAMPLE_SEEN (when the statement was seen), and ...The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
*/ if (code->finalise() !=0) APIERROR (code->getNdbError()); /* Time to define the update operation to use the * InterpretedCode object. This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using ...The source code can be found can be found in the file storage/ndb/ndbapi-examples/ndbapi_recattr_vs_record/main.cpp in the NDB Cluster source ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
The UUID value is assumed not to have its time-low and time-high parts swapped. If swap_flag is 1, the UUID value is assumed to have its time-low and time-high parts swapped. For usage examples and information about time-part swapping, see the ...As ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
NdbTransaction::refresh() Description This method updates the transaction's timeout counter, and thus avoids aborting due to transaction timeout. It is not advisable to take a lock on a record and maintain it for a extended time since this can ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
Failed login attempts and password lock time in ALTER USER statements. New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS MASTER_COMPRESSION_ALGORITHM MASTER_TLS_CIPHERSUITES MASTER_ZSTD_COMPRESSION_LEVEL MEMBER OFF PASSWORD_LOCK_TIME ...New ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
There are as many data nodes as there are fragment replicas, times the number of fragments (see Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”). NDBCLUSTER (also known as NDB) is an in-memory storage engine ...NDB Cluster's NDB storage engine contains a complete set of data, dependent only on other data within the cluster ...