Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). Like all other unsafe statements, this generates a warning if ...When ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth. For row-based logging, the event indicates ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 15.7.7.37, “SHOW STATUS Statement”). | Threads_created | 217 | | Threads_running | 88 | | Uptime | 1389872 | ... The MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the table. A newly created secondary index contains only the ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
Executing a SELECT expr statement N times differs from executing SELECT BENCHMARK(N, expr) in terms of the amount of overhead involved. This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
(This applies to statements terminated by ; or \G.) --batch, -B Command-Line Format --batch Print results using tab as the column separator, with each row on a new line. By default, mysql translates \r\n in statement strings to \n and interprets \0 ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
The default value for the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO statement was changed to 10. The START REPLICA statement option SQL_AFTER_GTIDS is now compatible with the multi-threaded applier. (Previously, when MTA was ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
No replica to scan on this node (internal index stats error) 1429 MySQL error. Query aborted due to index fragment not found 20019 MySQL error. Create foreign key failed in NDB - parent index is not unique index 21027 MySQL error. Create foreign key ... This section lists all NDB errors, ordered by NDB error ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
LOAD DATA INFILE statements have been associated over time with several different events. Log files created subsequently (when someone issues a FLUSH LOGS statement or the current binary log file becomes too large) do not contain this event. The ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
abort enables rules to be written that block execution of specific SQL statements. audit_log_statement_policy_value This variable corresponds to the value of the audit_log_statement_policy system variable. Table 8.41, ...For information about using ...