Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. For certain statements that a client might execute multiple times during a session, the ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
Data Type Storage Required CHAR(M) The compact family of InnoDB row formats optimize storage for variable-length character sets. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. For functions that operate on string positions, the first position is numbered 1. For functions that ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
The same is true for the ALTER TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements. Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
Optimize SELECT statements to run faster so that they lock tables for a shorter time. InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
Optimal performance is often seen with values from 4 to 8. This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the ...