Search Results
https://dev.mysql.com/doc/refman/8.4/en/help.html
To make a more specific request, please type 'help <item>', where <item> is one of the following topics: FLUSH SHOW SHOW BINARY LOG STATUS SHOW ENGINE SHOW FUNCTION STATUS SHOW PROCEDURE STATUS SHOW REPLICA STATUS SHOW STATUS SHOW TABLE STATUS List ... HELP 'search_string' The HELP statement returns online information from the MySQL Reference ...
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-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-system-tablespace.html
If you encounter this error, restore the previous innodb_data_file_path setting, and refer to the system tablespace resizing instructions. The only option to achieve a smaller system tablespace is to restore your data from a backup to a new MySQL ...
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
The example uses the general query log; the procedure for the slow query log is similar but uses the slow_log table and slow_query_log system variable. MySQL Server provides flexible control over the destination of output written to the general ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
You should keep the following issues and notes in mind: Other MySQL installations: The installation procedure does not recognize MySQL installations by package managers such as Homebrew. The installation and upgrade process is for MySQL packages ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-services.html
The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.3.8, “Starting MySQL as a Windows Service”. On Windows, a MySQL server can run as a Windows service. To set up multiple MySQL services, ...