Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. This section provides a conceptual overview of partitioning in MySQL 9.7. For information on partitioning ...
https://dev.mysql.com/doc/refman/9.7/en/password-logging.html
In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged as is, so you should avoid such statements. Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-instrument-filtering.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-ndb-replication-applier-status-table.html
CONFLICT_FN_MAX_INS: The number of times that NDB replication “greater timestamp wins” conflict resolution has been applied to insert operations. NDBCLUSTER exposes its internal replication applier state for observation using global status ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-quick-start.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-digests.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. The MySQL server is capable of maintaining statement digest information. The digesting process ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-system-variables.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. The Performance Schema automatically sizes the values of several of its parameters at server ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. The name of the performance_schema database is lowercase, as are the names of tables within it. Many ...