Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Important Care should be taken when changing innodb_buffer_pool_chunk_size, as changing this value can automatically increase the size of the buffer pool. For the meanings of these values and important information about innodb_force_recovery, see ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html
For limitations associated with importing tables using the Transportable Tablespaces feature, see Table Import Limitations. This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Importing a table that does not explicitly define a row format results in a schema mismatch error if the innodb_default_row_format setting on the source server differs from the setting on the destination server. The row format of a table determines ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
You can enforce a high degree of consistency with the default REPEATABLE READ level, for operations on crucial data where ACID compliance is important. Or you can relax the consistency rules with READ COMMITTED or even READ UNCOMMITTED, in ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
It is important to keep in mind that the size of any JSON document stored in a JSON column is limited to the value of the max_allowed_packet system variable. It is important to distinguish the partial update of a JSON column value stored in a table ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
Among other instructions discussed there, it is especially important to back up your database before the update. Important In-place downgrading of MySQL is not supported by the MySQL SLES repository. The MySQL SLES repository provides RPM packages ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The mysqlimport utility provides another way to load data files; it operates by sending a LOAD DATA statement to the server. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
Important This parameter is deprecated, and is subject to removal in a future release. (NDB 8.4.0) For queries that are translated into full table scans or range scans on indexes, it is important for best performance to fetch records in properly ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
To support NDB Cluster, you should update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. Note The options shown here should not be confused with those that are used ...