Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
For additional information about thread termination, see Section 15.7.8.4, “KILL Statement”, in particular for the instructions about killed REPAIR TABLE or OPTIMIZE TABLE operations on MyISAM tables. The server shutdown process takes place as ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
If ORDER BY appears without LIMIT within a query block, it is optimized away because it has no effect in any case. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set ...
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 ...