Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
When consecutive primary values are physically stored near each other, InnoDB can insert and retrieve them faster. For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger saves disk I/O. Consider the following guidelines for optimizing redo logging: Increase the size of your redo log files. When InnoDB has written ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.4/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 8.4. For information on partitioning ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...