Search Results
https://dev.mysql.com/doc/refman/9.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, ...
https://dev.mysql.com/doc/refman/9.7/en/explain-extended.html
Extended information is available for SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). The EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/9.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/9.7/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-json-duality-view-columns-table.html
READ_ONLY 1 if insert, update, or delete are not allowed, otherwise 0. (In other words, this is 1 only when ALLOW_INSERT, ALLOW_UPDATE, and ALLOW_DELETE are all 0.) . The JSON_DUALITY_VIEW_COLUMNS table shows information about all columns ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-json-duality-view-tables-table.html
READ_ONLY 1 if insert, update, or delete are not allowed, otherwise 0. (In other words, this is 1 only when ALLOW_INSERT, ALLOW_UPDATE, and ALLOW_DELETE are all 0.) IS_ROOT_TABLE 1 if this is the root table, otherwise 0. The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-json-duality-views-table.html
READ_ONLY 1 if insert, update, or delete are not allowed, otherwise 0. (In other words, this is 1 only when ALLOW_INSERT, ALLOW_UPDATE, and ALLOW_DELETE are all 0.) STATUS One of valid or invalid. The JSON_DUALITY_VIEWS table provides information ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-params-ndbd.html
InsertRecoveryWork: Percentage of RecoveryWork used for inserted rows; has no effect unless partial local checkpoints are in use. RestartOnErrorInsert: Control type of restart caused by inserting error (when StopOnError is enabled). The listings in ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-mta.html
Conversely, transactions performing inserts, updates and deletes on foreign key child tables (referencing) are not especially serialized with regard to one another. To use this functionality with NDB Cluster, it is necessary that the replica be ...