https://dev.mysql.com/mysqld-server.html
The following discussion covers these MySQL server configuration topics: Startup options that the server supports. You can specify these options on the command line, through configuration files, or both. These variables reflect the current state and ...
https://dev.mysql.com/MySQLInstallerConsole.html
On success, the catalog is applied the next time either MySQLInstaller or MySQLInstallerConsole is executed. MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. It is installed when MySQL Installer is ...
https://dev.mysql.com/mysqlshow.html
This option can be used multiple times to increase the amount of information. The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information can be obtained by using those ...
https://dev.mysql.com/ndb-restore-different-number-nodes.html
This needs to be done once for each data node in the original cluster, each time using that data node's node ID. It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the ...
https://dev.mysql.com/nested-join-optimization.html
As a result, the execution time for the query may improve immensely. The following discussion refers to the join syntax described in Section 13.2.10.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard.
https://dev.mysql.com/no-login-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. If you installed the plugin at runtime using an INSTALL PLUGIN statement, it remains installed across server restarts. The mysql_no_login server-side ...
https://dev.mysql.com/no-matching-rows.html
Remove one table at a time from the query until it returns some rows. If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to ...
https://dev.mysql.com/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). If you get ERROR 'file_name' not found (errno: 23), Can't open file: ...
https://dev.mysql.com/optimization-indexes.html
Although it can be tempting to create an indexes for every possible column used in a query, unnecessary indexes waste space and waste time for MySQL to determine which indexes to use. The best way to improve the performance of SELECT operations is ...
https://dev.mysql.com/optimization.html
Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem occurs. This chapter explains how to optimize MySQL performance and provides examples.
