Search Results
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-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ... This section describes restrictions and limitations of the InnoDB storage ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-multiple-nodes.html
Stored procedures, stored functions, triggers, and scheduled events are all supported by tables using the NDB storage engine, but these do not propagate automatically between MySQL Servers acting as Cluster SQL nodes, and must be re-created ...The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html
A unique index read operation generates 2 primary key read operations—1 for the hidden unique index table, and 1 for the table on which the read takes place. Note A unique index update operation can generate multiple PK read and write operations ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...