Search Results
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
When in-memory internal temporary tables are managed by the MEMORY storage engine, fixed-length row format is used. In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under ...
https://dev.mysql.com/doc/refman/8.4/en/introduction.html
For a history of new features and bug fixes, see the Release Notes. The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
The file name suffix for Unix and Unix-like systems is .so. For example: [mysqld] authentication_kerberos_service_key_tab=/var/mysql/data/mysql.keytab If the keytab file is not in the correct place or does not contain a valid SPN key, the MySQL ...
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/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/doc/refman/8.4/en/linux-installation-apt-repo.html
This section provides guidance on installing MySQL using the MySQL APT repository. First, add the MySQL APT repository to your system's software repository list. Follow these steps: Go to the download page for the MySQL APT repository at ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/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/doc/refman/8.4/en/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/doc/refman/8.4/en/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 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes ...