MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 131 to 138 of 138 total results

« Previous
12
13
14
Next »

https://dev.mysql.com/doc/refman/8.0/en/source-ssl-library-configuration.html

An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. If you compile MySQL from a source distribution, CMake configures the distribution to use the installed ...

2.9.2.1 Troubleshooting Problems Starting the MySQL Server

https://dev.mysql.com/doc/refman/8.0/en/starting-server-troubleshooting.html

This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”. If you have problems ...

10.2.2.3 Optimizing Subqueries with the EXISTS Strategy

https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html

Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery results. This section discusses these optimizations, particularly with regard to the challenges that NULL values present. The last part of the ...

10.15.12 Example

https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html

Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...

10.8.1 Optimizing Queries with EXPLAIN

https://dev.mysql.com/doc/refman/8.0/en/using-explain.html

The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...

7.9.1.4 Debugging mysqld under gdb

https://dev.mysql.com/doc/refman/8.0/en/using-gdb-on-mysqld.html

On most systems you can also start mysqld from gdb to get more information if mysqld crashes. With some older gdb versions on Linux you must use run --one-thread if you want to be able to debug mysqld threads. In this case, you can only have one ...

7.9.1.6 Using Server Logs to Find Causes of Errors in mysqld

https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html

Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If mysqld dies or hangs, you should start mysqld with the general query log enabled. When mysqld dies again, you can examine the ...

8.4.1.6 Windows Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html

Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition for Windows supports an authentication method that performs external authentication on Windows, enabling ...