PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
(Unix shells treat it as a command terminator, for example.) Startup command: mysqld --innodb-directories="directory_path_1;directory_path_2" MySQL option file: [mysqld] innodb_directories="directory_path_1;directory_path_2" The following procedure ... The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
These tables are set up automatically in all install, upgrade, and build-from-source procedures. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
For information about buffer pool dump and load procedures used in this example, see Section 17.8.3.6, “Saving and Restoring the Buffer Pool State”. To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. In previous MySQL versions, the system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
Internals The following information describes internals and messages written to the error log during a table import procedure. This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, ...
https://dev.mysql.com/doc/refman/8.0/en/install-plugin.html
This procedure has the advantage that it can be used without stopping the server. INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. It requires the INSERT privilege for the mysql.plugin system table ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
For more information on the postinstallation procedures, see Section 2.9, “Postinstallation Setup and Testing”. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
To use the LOCK_ORDER tool, follow this procedure: Build MySQL from source, configuring it with the -DWITH_LOCK_ORDER=ON CMake option so that the build includes LOCK_ORDER tooling. The MySQL server is a multithreaded application that uses numerous ...