Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
MySQL Enterprise Data Masking and De-Identification database table and components are: masking_dictionaries table Purpose: A table that provides persistent storage for masking dictionaries and terms. To set up MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, ... If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
For example, you can save the state of the buffer pool after reaching a stable throughput under a steady workload. Only tablespace IDs and page IDs necessary to locate the appropriate pages are saved to disk. By default, tablespace ID and page ID ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. You can enforce a high degree of consistency with the default REPEATABLE READ level, for ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes. If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to make data insertion even faster. When loading a table from ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. INSTALL PLUGIN also registers the plugin by adding a line that indicates the plugin name and library file name to the ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
Wait event data collected in Performance Schema tables can help identify mutexes with the most waits or the greatest total wait time, for example. To view available InnoDB mutex wait instruments, query the Performance Schema setup_instruments table.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-concepts.html
The data actually stored in the database tables at the time that the backup was made Transaction log. Each node saves the same table definitions (for all tables in the cluster) to its own version of this file. BACKUP-backup_id-0.node_id.data A data ... A backup is a snapshot of the database at a given ...