Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both ...You ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
Note Because each counter adds a degree of runtime overhead, use counters conservatively on production servers to diagnose specific issues or monitor specific functionality. If you run programs that would be affected by the addition or removal of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
Note Locking reads are only possible when autocommit is disabled (either by beginning transaction with START TRANSACTION or by setting autocommit to 0. Note Queries that skip locked rows return an inconsistent view of the data. If you query data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Note On Unix-like systems, ls -l tablespace_name.ibd shows the apparent file size (equivalent to FILE_SIZE) in bytes. Page Compression Limitations and Usage Notes Page compression is disabled if the file system block size (or compression unit size ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/installing.html
Please note that not all platforms are equally suitable for running MySQL, and that not all platforms on which MySQL is known to run are officially supported by Oracle Corporation. A summary of the procedure follows and later sections provide the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Note Only one keyring component or plugin should be enabled at a time. Note A keyring component must be enabled on the MySQL server instance if you need to support secure storage for persisted system variable values. To do this, check the notes for ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. Note that you must register a separate endpoint for each MySQL Server instance. Note If the existing file is not in this format, then create a ...The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all statement-processing has stopped and all index changes have been flushed to disk. Note If you want a ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
Note After completing the installation, do not yet start any of the binaries. Note The actual file and directory names vary according to the NDB Cluster version number. Note The data directory on each machine hosting a data node is ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...You can also obtain this list by executing TABLE ndbinfo.dict_obj_types in the mysql ...