Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the INFO value shows the SELECT statement. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release.
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB follows the same procedure when initializing the auto-increment counter for a newly created table that has a user-specified auto-increment value greater than 0. InnoDB provides a configurable locking mechanism that can significantly improve ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Use the following procedure: Perform a slow shutdown of the MySQL server and make sure that it stops without errors. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuration.html
This section provides configuration information and procedures for InnoDB initialization, startup, and various components and features of the InnoDB storage engine. For information about optimizing database operations for InnoDB tables, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
Modifying the configuration after InnoDB is initialized may involve non-trivial procedures. The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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 ...