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
Displaying 971 to 978
of 978 total results
- « Previous
- 96
- 97
- 98
https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html
An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
Connect to the existing MySQL server and select the MySQL Server version you plan to upgrade to for the utility to report issues to address prior to an upgrade. MySQL supports upgrading between minor versions (within an LTS series) and to the next ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
This older method of accounting may be selected by starting the server with the --old-style-user-limits option. One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html
You can also try the command EXPLAIN on all SELECT statements that takes a long time to ensure that mysqld is using indexes properly. Note that before starting mysqld with the general query log enabled, you should check all your tables with ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation-layout.html
docs Release documentation With MySQL Installer, use the Modify operation to select this optional folder. For MySQL 8.0 on Windows, the default installation directory is C:\Program Files\MySQL\MySQL Server 8.0 for installations performed with MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%windows%'; +------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +------------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/windows-server-first-start.html
For information about which server binary to run, see Section 2.3.4.3, “Selecting a MySQL Server Type”. This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting ...
https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html
There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was performed. Note MySQL Installer deselects the server ...