Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
row *************************** SPACE: 26 NAME: test/t1 FLAG: 0 ROW_FORMAT: Compact or Redundant PAGE_SIZE: 16384 ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single FS_BLOCK_SIZE: 4096 FILE_SIZE: 98304 ALLOCATED_SIZE: 65536 AUTOEXTEND_SIZE: 0 SERVER_VERSION: 8.4.0 ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
The autocommit setting is turned on, so that the transaction is guaranteed to be a single statement, and the single statement making up the transaction is a “non-locking” SELECT statement. For information about START TRANSACTION and autocommit, ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. Because of the asynchronous nature of automatic statistics recalculation, which occurs in ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
The size of the pool never shrinks and tablespaces are added to the pool automatically as necessary. If no value is specified for innodb_temp_data_file_path, the default behavior is to create a single auto-extending data file named ibtmp1 in the ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
Starting and Stopping the MySQL Server The MySQL server is started automatically after installation. Note Known issue: Currently, not all components required for running the MySQL NDB Cluster test suite are installed automatically when you install ... This section provides guidance on installing MySQL using the MySQL APT ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
mysql> SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%wait/synch/mutex/innodb%'; +-------------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ... A mutex is a synchronization mechanism ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Like other MySQL storage engines, the NDB storage engine can handle a maximum of one AUTO_INCREMENT column per table, and this column must be indexed. However, in the case of an NDB table with no explicit primary key, an AUTO_INCREMENT column is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
--auto-inc, -a Show the next value for a table's AUTO_INCREMENT column, if it has one. ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
When using this option, it is recommended that auto synchronization be disabled by setting ndb_metadata_check=OFF until ndb_restore has completed restoring the metadata, after which it can it turned on again to synchronize objects newly created in ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...