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/known-issues.html
If these are binary logs, you must edit the binary log index file and fix the binary log file names there as well. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and ...
https://dev.mysql.com/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/midpoint-insertion.html
The division point between two parts is not fixed, but the key cache management system takes care that the warm part is not “too short,” always containing at least key_cache_division_limit percent of the key cache blocks. By default, the key ...
https://dev.mysql.com/miscellaneous-optimization-tips.html
To fix any compression issues that occur with ARCHIVE tables, use OPTIMIZE TABLE. This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related ...
https://dev.mysql.com/myisam-storage-engine.html
Tables with VARCHAR columns may have fixed or dynamic row length. MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 16.2 MyISAM Storage Engine Features Feature Support B-tree indexes ...
https://dev.mysql.com/myisamchk-repair-options.html
--recover, -r Do a repair that can fix almost any problem except unique keys that are not unique (which is an extremely unlikely error with MyISAM tables). myisamchk supports the following options for table repair operations (operations performed ...
https://dev.mysql.com/myisamchk.html
You can also specify a table by naming its index file (the file with the .MYI suffix). The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have ...
https://dev.mysql.com/mysql-cluster-disk-data-storage-requirements.html
The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to the space required to store the largest possible value for that column. For ...
https://dev.mysql.com/mysql-cluster-installation.html
This section describes the basics for planning, installing, configuring, and running an NDB Cluster. Whereas the examples in Section 22.3, “Configuration of NDB Cluster” provide more in-depth information on a variety of clustering options and ...
