Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation process. Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as my.ini.
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-shell.html
For example, to view help on the \connect command, issue: mysql-js> \help \connect Quit MySQL Shell To quit MySQL Shell, issue the following command: mysql-js> \quit Related Information See Interactive Code Execution for an explanation of how ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-shell.html
For example, to view help on the \connect command, issue: mysql-py> \help \connect Quit MySQL Shell To quit MySQL Shell, issue the following command: mysql-py> \quit Related Information See Interactive Code Execution for an explanation of how ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status. Note For some Linux platforms, MySQL installation ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
INDEX, NO_INDEX: Acts as the combination of JOIN_INDEX, GROUP_INDEX, and ORDER_INDEX, forcing the server to use the specified index or indexes for any and all scopes, or as the combination of NO_JOIN_INDEX, NO_GROUP_INDEX, and NO_ORDER_INDEX, which ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. An ORDER BY with and without ...
https://dev.mysql.com/doc/refman/8.4/en/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). That is a problem with the system library, not with MySQL. To work around it, change your MySQL password ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/8.4/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...