Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
The optimizer chooses SQL compliance over speed, so it accounts for the possibility that outer_expr might be NULL: If outer_expr is NULL, to evaluate the following expression, it is necessary to execute the SELECT to determine whether it produces ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-threaded-clients.html
If a thread does not create the connection to the MySQL database but calls MySQL functions, take the following into account: When you call mysql_init(), MySQL creates a thread-specific variable for the thread that is used by the debug library (among ...It is not thread-safe, so call it before threads are created, or protect the call with a ... This section ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
Blocking Account The account associated with the thread that is blocking the waiting lock. Blocking Account Duration How long the blocking lock has been held. Waiting Account The account associated with the session that is waiting for the lock.
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-function-reference.html
Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions Name Description gen_blocklist() Perform dictionary term replacement gen_dictionary() Return random term from dictionary gen_range() Generate random number within ...
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. This is like executing a SHUTDOWN statement without having to connect to the server (which ...Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT TO_DAYS(950501); -> 728779 mysql> SELECT TO_DAYS('2007-10-07'); -> 733321 TO_DAYS() is not intended for use with values that precede the advent of the Gregorian calendar (1582), because it does not take into account the days that were ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-updating-egress-endpoints.html
Updating Egress Endpoints for a Egress PrivateLink 6.3.4 Updating Egress Endpoints for a Egress PrivateLink You need to update the Egress Endpoints if the service in your account is listening on a different port, or you want to make it accessible ...Use the MySQL HeatWave Console to update the Egress Endpoints of a Egress ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). The optimizer ... InnoDB automatically extends each secondary index by appending the primary key columns to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
You can also use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. For example: mysql> STOP GROUP_REPLICATION; mysql> CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = ...To secure one of ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server-troubleshooting.html
You can create a my.cnf file and specify startup options for the engines that you plan to use. For example, if the data directory is /usr/local/mysql/var, use this command: $> ls -la /usr/local/mysql/var If the data directory or its files or ...