Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a row exists, the fetched columns are stored in the named variables. The number of columns ...