Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
MySQL appends a statement to the transaction to insert the GTID into the table. One GTID is generated for the CREATE TABLE action and one GTID is generated for the row-insert actions. The life cycle of a GTID consists of the following steps: A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Important Before enabling this variable, you must make certain that there are no dependencies between transactional and nontransactional tables; an example of such a dependency would be the statement INSERT INTO myisam_table SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
In order to execute specific replicated transactions from the relay log, or transactions from mysqlbinlog output as required, the PRIVILEGE_CHECKS_USER account must have the following privileges: For a row insertion logged in row format (which are ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Deprecated Yes Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
A view cannot be referenced by a user who does not have the appropriate privilege for it (SELECT to select from it, INSERT to insert into it, and so forth). Stored programs (procedures, functions, triggers, and events) and views are defined prior ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
As an alternative to explicitly escaping special characters, many MySQL APIs provide a placeholder capability that enables you to insert special markers into a statement string, and then bind data values to them when you issue the statement. A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-index-statistics.html
insert_latency The total wait time of timed inserts into the index. The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
insert_latency The total wait time of timed insert I/O events for the table. These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics.html
insert_latency The total wait time of timed insert I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...