Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
To view undo tablespace names and paths, query INFORMATION_SCHEMA.FILES: SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG'; A MySQL instance supports up to 127 undo tablespaces including the two default ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-system-variables.html
keyring_hashicorp_ca_path Command-Line Format --keyring-hashicorp-ca-path=file_name System Variable keyring_hashicorp_ca_path Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value empty string The absolute path name of a ...
https://dev.mysql.com/doc/refman/8.4/en/lock-order-tool.html
The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and files. For MySQL, the effect of a deadlock is catastrophic, ...Within the server, the set of lock-related objects changes with implementation of new features and code refactoring for performance ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. Note In MySQL 8.4, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when ...As in ...
https://dev.mysql.com/doc/refman/8.4/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
MySQL Perl support requires that you have installed MySQL client programming support (libraries and header files). If you install MySQL from RPM files on Linux, be sure to install the developer RPM as well. For example: $> perl -MCPAN -e shell ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
Note Many of the examples in this and the next section use the mysql client to process binary log output produced by mysqlbinlog. If your binary log contains \0 (null) characters, that output cannot be parsed by mysql unless you invoke it with the ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.4/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. For example, mysql has a max_allowed_packet variable that controls the maximum size of its communication buffer. To set the max_allowed_packet variable ...See Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 7.1.9, “Using System ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). Advantages of replication in MySQL include: Scale-out solutions - spreading the load among multiple ...Replication is asynchronous by default; replicas do not need to be connected permanently to receive updates from a ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.