Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
For general performance information about MySQL thread handling, see Section 7.1.12.1, “Connection Interfaces”. InnoDB uses operating system threads to process requests from user transactions. (Transactions may issue many requests to InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
Because uncompressing pages is a CPU-intensive process, it is more efficient for concurrency to perform the operation in a connection thread rather than in the single thread that performs the buffer pool restore operation. To reduce the warmup ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
Modifications that did not finish updating data files before an unexpected shutdown are replayed automatically during initialization and before connections are accepted. The redo log is a disk-based data structure used during crash recovery to ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. If you specify an ON DUPLICATE KEY UPDATE clause ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-system-support.html
Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-oci-component.html
“user”: The OCID of the Oracle Cloud Infrastructure user that component_keyring_oci uses for connections. Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial product.
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press Ok; in that case, root access to the server will be authenticated by Section 8.4.1.10, “Socket Peer-Credential Pluggable Authentication” ... This section provides guidance on installing MySQL using the MySQL APT ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...