https://dev.mysql.com/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/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/innodb-parameters.html
A minimum file size is enforced for the first system tablespace data file to ensure that there is enough space for doublewrite buffer pages: For an innodb_page_size value of 16KB or less, the minimum file size is 3MB. innodb_doublewrite Property ...
https://dev.mysql.com/invoking-programs.html
shell> mysql --user=root test shell> mysqladmin extended-status variables shell> mysqlshow --help shell> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program options. To invoke a MySQL program from ...
https://dev.mysql.com/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/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. Reserved words are permitted as ...
https://dev.mysql.com/limits-windows.html
The following limitations apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/mysql-cluster-ndbinfo-config-values.html
The config_values table provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. Table 22.383 Columns of the config_params table ...
https://dev.mysql.com/mysql-cluster-programs-ndb-mgm.html
The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and performing other administrative functions. The management client ...
