Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
When there is a limit on the number of threads (when innodb_thread_concurrency is > 0), InnoDB reduces context switching overhead by permitting multiple requests made during the execution of a single SQL statement to enter InnoDB without observing ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. Invoke the mysql client to connect to the server using ... The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
This is equivalent to specifying a column as AUTO_INCREMENT in a CREATE TABLE statement, and can be used to distinguish parent rows with the same value for multiple rows generated by a NESTED [PATH] clause. When multiple values are truncated in a ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
This is a one-time operation, performed by executing the following statements, adjusting the .so suffix for your platform as necessary: CREATE FUNCTION keyring_aws_rotate_cmk RETURNS INTEGER SONAME 'keyring_aws.so'; CREATE FUNCTION ... Note The ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Check the server error log, correct the configuration issues, and use the ALTER INSTANCE RELOAD KEYRING statement to reload the configuration. Keyring components should be loaded only by using a manifest file, not by using the INSTALL COMPONENT ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. A mysqldump dump includes statements to recreate ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... You can do this by issuing, for each ... In this section, we list the basic steps required to add new data nodes to an NDB ...