Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
When you compress the data in the application and store the results in a compressed table, extra space savings are extremely unlikely, and the double compression just wastes CPU cycles. Most often, the internal optimizations described in InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files. This section describes techniques for moving or copying some or all InnoDB tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_doublewrite Command-Line Format --innodb-doublewrite=value System Variable innodb_doublewrite Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value ON Valid Values ONOFFDETECT_AND_RECOVERDETECT_ONLY The ... InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/invoking-programs.html
$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program options. To invoke a MySQL program from the command line ...
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
mysql> SELECT JSON_OBJECT('id', 87, 'name', 'carrot'); +-----------------------------------------+ | JSON_OBJECT('id', 87, 'name', 'carrot') | +-----------------------------------------+ | {"id": 87, "name": "carrot"} | ... The functions listed in ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations on JSON values to ...
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/mysql-cluster-backup-using-management-client.html
Before starting a backup, make sure that the cluster is properly configured for performing one. If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. If used, the backup_id must follow ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
To avoid modification of the index during this double-read operation, the row found in the hidden index table is locked. A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
This is due to the fact, during the execution of ALTER TABLE on a Cluster table, 3 times the number of attributes as in the original table are used, and a good practice is to permit double this amount. The [ndbd] and [ndbd default] sections are ...