Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ...If you are running with innodb_strict_mode enabled, the combination of a KEY_BLOCK_SIZE with any ROW_FORMAT other than COMPRESSED generates an error, not a warning, and the table is not ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-engines-table.html
A value of DISABLED occurs either because the server was started with an option that disables the engine, or because not all options required to enable it were given. In the latter case, the error log should contain a reason indicating why the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-in-core-file.html
The innodb_buffer_pool_in_core_file option is disabled by default on systems that support MADV_DONTDUMP, otherwise it defaults to ON. Note Before MySQL 8.4, innodb_buffer_pool_in_core_file was enabled by default instead of disabled. $> mysqld ... A ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
The subrepository for the latest bugfix series (currently MySQL 8.4) is enabled by default, and the subrepositories for all other series are disabled. Use this command to see all of the subrepositories in the MySQL SLES repository, and to see which ... The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Note The mysql_native_password authentication plugin is deprecated as of MySQL 8.0.34, disabled by default in MySQL 8.4, and removed as of MySQL 9.0.0. Installing Native Pluggable Authentication The mysql_native_password plugin exists in server and ... MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
Disable it for non-rotational storage or a mix of rotational and non-rotational storage. innodb_log_compressed_pages If redo logs are on non-rotational storage, consider disabling this option to reduce logging. See Section 17.6.4, “Doublewrite ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
A value of DISABLED occurs either because the server was started with an option that disables the engine, or because not all options required to enable it were given. In the latter case, the error log should contain a reason indicating why the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
This section provides information about the Table class, which models a database table in the NDB API. Signature void setLogging ( bool enable ) Parameters If enable is true, then logging for this table is enabled; if it is false, then logging is ...This class extends the Object class, which in turn is an inner class of the NdbDictionary ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
The omitted columns are set to their implicit default values if strict SQL mode is not enabled. In strict mode, the statement is rejected if any of the omitted columns have no default value. (Standard SQL requires you to have the INSERT privilege on ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/workbench/en/wb-installing-linux.html
There are binary distributions of MySQL Workbench available for several variants of Linux, including Fedora, Oracle Linux, and Ubuntu. For general requirements and specific installation instructions, see the sections that follow. Requirements for ...