Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-components.html
Typically, a sink processes log events into log messages that have a particular format and writes these messages to its associated output, such as a file or the system log. This section describes the characteristics of individual error log ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
2020-08-06T14:25:03.109022Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 Traditional-format messages have these fields: time thread [label] [err_code] [subsystem] msg The [ and ] square bracket characters are ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
If this filter is disabled, log_error_verbosity and log_error_suppression_list have no effect, so filtering must be performed using another filter service instead where desired (for example, with individual filter rules when using ... The ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
These elements have the following characteristics: Error code: This value is numeric. For server-side errors, not all MySQL error numbers have corresponding SQLSTATE values. This section discusses how error messages originate within MySQL and the ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
If you have the PROCESS privilege, you can specify the identifier for any connection. In all cases, you must have sufficient privileges to explain the query on the specified connection. To obtain the execution plan for an explainable statement ...
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must have external locking enabled. (This is not done by default because in many setups it is useful to have a mixture of the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
When should the change buffer not be used? You might consider disabling the change buffer if the entire data set fits within the InnoDB buffer pool, if you have relatively few secondary indexes, or if you are using solid-state storage, where random ...What types of operations modify secondary indexes and result in change buffering? ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
Where can I obtain complete documentation for MySQL storage engines? A.2.2. Can I prevent the use of a particular storage engine? A.2.5. Is there an advantage to using the InnoDB storage engine exclusively, as opposed to a combination of InnoDB and ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
You can either create the local table and specify the connection string (containing the server name, login, password) to be used to connect to the remote table using the CONNECTION, or you can use an existing connection that you have previously ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
Before doing so, ensure that you have a backup copy of your database in case you need to recreate it. Only use an innodb_force_recovery setting of 4 or greater on a production server instance after you have successfully tested the setting on a ...