Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-json.html
This section describes how to configure error logging using the built-in filter, log_filter_internal, and the JSON sink, log_sink_json, to take effect immediately and for subsequent server startups. For general information about configuring error ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rotation.html
If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is writing. To rename an error log file, do so manually before flushing.
https://dev.mysql.com/doc/refman/8.4/en/error-log-syslog.html
It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like systems). This section describes how to configure error logging using the built-in filter, log_filter_internal, and the ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. These indicate issues of interest to database administrators or that require DBA action.
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
In most cases, you can estimate query performance by counting disk seeks. For small tables, you can usually find a row in one disk seek (because the index is probably cached). For bigger tables, you can estimate that, using B-tree indexes, you need ...
https://dev.mysql.com/doc/refman/8.4/en/execute.html
EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with PREPARE, you execute it with an EXECUTE statement that refers to the prepared statement name. If the prepared statement contains any parameter markers, you must ...
https://dev.mysql.com/doc/refman/8.4/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. A query on a huge table can be performed ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN. Extended information is available for SELECT, DELETE, INSERT, REPLACE, ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-connectors-apis.html
For common questions, issues, and answers relating to the MySQL Connectors and other APIs, see the following areas of the Manual: Using C API Features Connector/ODBC Notes and Tips Connector/NET Programming MySQL Connector/J Developer Guide .
https://dev.mysql.com/doc/refman/8.4/en/faqs-migration.html
Where can I find information on how to upgrade or downgrade MySQL? A.8.1. Where can I find information on how to upgrade or downgrade MySQL? For detailed upgrade information, see Chapter 3, Upgrading MySQL. Do not skip a major version when ...