Search Results
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld. Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. An ... The ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
Possible causes include but are not limited to file system errors. In this case, the result set returned by REPAIR TABLE contains a line with a Msg_type value of error and a Msg_text value of Failed repairing incompatible .FRM file. Column Value ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
If the error is in a mixed transaction, that transaction is half-applied. When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. This ensures it never leaves gaps ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
Details of the error and the last applied transaction are recorded in the Performance Schema replication_applier_status_by_worker table. Follow this procedure to recover from the error: Identify the replicated event that caused the error and verify ... If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
For example, the following does not work: SELECT * FROM temp_table JOIN temp_table AS t2; The statement produces this error: ERROR 1137: Can't reopen table: 'temp_table' You can work around this issue if your query permits use of a common table ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
(If no CTE refers to itself, RECURSIVE is permitted but not required.) If you forget RECURSIVE for a recursive CTE, this error is a likely result: ERROR 1146 (42S02): Table 'cte_name' doesn't exist The recursive CTE subquery has two parts, separated ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
required: Compression algorithm negotiation occurs as for preferred mode, but if no common algorithm is available, the connection request terminates with an error. If the compression mode is required but no algorithm permitted on the client side is ... X Plugin supports compression of messages sent over X Protocol ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
mysqlbackup throws an error when the option is used without a regular expression being supplied with it. mysqlbackup throws an error when no table matches the regular expression specified with --include-tables. mysqlbackup throws an error when the ... To select specific data to be backed up or restored, use the partial backup and restore options described in this ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Use the error_code and error_message values to track any errors that have occurred, and to see if the backup operation should be terminated because of any serious errors. It is always important to check the output of mysqlbackup to see if an ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-other.html
AllowUnresolvedHostNames: When false (default), failure by management node to resolve host name results in fatal error; when true, unresolved host names are reported as warnings only. Checksum: If checksum is enabled, all signals between nodes are ...Group: Used for group proximity; smaller value is interpreted as being ...