Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 17.6.3.2, ... There are ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. Reduced locking and waiting for MySQL ...Online operations read less data into the buffer pool than table-copy operations, which reduces purging of frequently accessed data from ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ...If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure called the key cache (or key buffer) is maintained. When data from any table index block must be accessed, the server ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
Alternatively, if you can stop the mysqld server for a while, change location into the data directory and use this command while the server is stopped: $> myisamchk -r -s --sort-index --myisam_sort_buffer_size=16M */*.MYI . (These are “expected ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-print-file.html
Like ndb_print_schema_file and ndb_print_sys_file (and unlike most of the other NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_print_file must be run on an NDB Cluster data node, since ... ndb_print_file obtains information from an NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-print-frag-file.html
Like ndb_print_backup_file, ndb_print_sys_file, and ndb_print_schema_file (and unlike most of the other NDB utilities that are intended to be run on a management server host or to connect to a management server), ndb_print_frag_file must be run on a ...It is intended for use in helping to diagnose issues with data node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-print-schema-file.html
Like ndb_print_backup_file and ndb_print_sys_file (and unlike most of the other NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_print_schema_file must be run on a cluster data node, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-print-sys-file.html
Like ndb_print_backup_file and ndb_print_schema_file (and unlike most of the other NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_print_backup_file must be run on a cluster data node, ... ndb_print_sys_file obtains diagnostic information from an NDB Cluster system ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-redo-log-reader.html
Like ndb_print_backup_file and ndb_print_schema_file (and unlike most of the NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_redo_log_reader must be run on a cluster data node, since it ... Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or ...