Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
To improve the performance of this method, disable autocommit when importing data. This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-spin_lock_polling.html
On a system where all processor cores share a fast cache memory, you might reduce the maximum delay or disable the busy loop altogether by setting innodb_spin_wait_delay=0. InnoDB mutexes and rw-locks are typically reserved for short intervals. On ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
Running a SELECT query after disabling autocommit, and forgetting to issue an explicit COMMIT or ROLLBACK. InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
To store DYNAMIC tables in the system tablespace, either disable innodb_file_per_table and use a regular CREATE TABLE or ALTER TABLE statement, or use the TABLESPACE [=] innodb_system table option with CREATE TABLE or ALTER TABLE. The row format of ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_hashicorp keyring plugin communicates with HashiCorp Vault for back end storage. No key information is permanently stored in ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-metadata.html
If the component loaded but failed to initialize, the value is Disabled. To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
To disable use of this file, set the LDAPNOINIT environment variable. Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. MySQL sometimes optimizes a query that has a LIMIT row_count clause and no ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
Note Once the MySQL APT repository is enabled on your system, you will no longer be able to install any MySQL packages from your platform's native software repositories until the MySQL APT repository is disabled. This section provides guidance on ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...