Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). However, not all system variables can be ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
Exceptions: Even with --defaults-file, mysqld reads mysqld-auto.cnf and client programs read .mylogin.cnf. Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, they must be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_BIND) AUTO_POSITION 1 if GTID auto-positioning is in use; otherwise 0. (CHANGE REPLICATION SOURCE TO option: SOURCE_AUTO_POSITION) SSL_ALLOWED, SSL_CA_FILE, SSL_CA_PATH, SSL_CERTIFICATE, SSL_CIPHER, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variable-tables.html
persisted_variables: Provides a SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings. The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server ...