Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
FLAG A numeric value that represents bit-level information about table format and storage characteristics. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-brief-table.html
FLAG A numeric value that represents bit-level information about tablespace format and storage characteristics. The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
FLAG A numeric value that represents bit-level information about tablespace format and storage characteristics. The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
On 64-bit systems with sufficient memory, you can split the buffer pool into multiple parts to minimize contention for memory structures among concurrent operations. The buffer pool is an area in main memory where InnoDB caches table and index data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
Warning On 32-bit GNU/Linux x86, if memory usage is set too high, glibc may permit the process heap to grow over the thread stacks, causing a server failure. The first decisions to make about InnoDB configuration involve the configuration of data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
Also, a deletion is treated internally as an update where a special bit in the row is set to mark it as deleted. It keeps information about old versions of changed rows to support transactional features such as concurrency and rollback. This ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
For example: mysql> SET GLOBAL innodb_redo_log_archive_dirs='label1:directory_path1[;label2:directory_path2;…]'; The label is an arbitrary identifier for the archive directory. On Windows, the performance impact is typically a bit higher, assuming ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
The following call creates a 2,048-bit DSA-encrypted key named MyKey: mysql> SELECT keyring_key_generate('MyKey', 'DSA', 256); +-------------------------------------------+ | keyring_key_generate('MyKey', 'DSA', 256) | ... MySQL Server supports a ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
The keys are randomly generated RSA keys of 4,096 and 2,048 bits, respectively. Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_hashicorp keyring plugin communicates with ...
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 ...