Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. The following list names the functions in MySQL 8.4 that are affected by the IGNORE_SPACE setting and listed as special in the sql/lex.h source file. This occurs ...This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a given ...
https://dev.mysql.com/doc/refman/8.4/en/functions.html
This chapter describes the built-in functions and operators that are permitted for writing expressions in MySQL. For information about loadable functions and stored functions, see Section 7.7, “MySQL Server Loadable Functions”, and Section 27.2, ... Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
mysql> SELECT @@group_replication_local_address; Once you know the group communication addresses of s1 (127.0.0.1:10000) and s2 (127.0.0.1:10001), you can use that on one of the two servers to inject a new membership configuration, thus overriding ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
Each member makes its own decision locally, following the primary election algorithm in its MySQL Server release. Because all members must reach the same decision, members adapt their primary election algorithm if other group members are running ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. Notes MySQL permits different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
Each session corresponds to a MySQL thread, and executes one transaction after another. Using the blocking_pid, query the MySQL Performance Schema threads table to determine the THREAD_ID of the blocking transaction. SELECT THREAD_ID, SQL_TEXT FROM ... This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%'; +---------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_TEMP%) | +---------------------------------------------+ | INNODB_TEMP_TABLE_INFO | ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog and mysql to restore the changes that occurred after the backup was made. If MySQL still has trouble starting because of InnoDB consistency ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
$> cd BASEDIR/data/#innodb_temp $> ls temp_10.ibt temp_2.ibt temp_4.ibt temp_6.ibt temp_8.ibt temp_1.ibt temp_3.ibt temp_5.ibt temp_7.ibt temp_9.ibt In statement based replication (SBR) mode, temporary tables created on a replica reside in a single ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/8.4/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...