Search Results
https://dev.mysql.com/doc/refman/9.7/en/select-benchmarking.html
The built-in MySQL functions are typically highly optimized, but there may be some exceptions. To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-regressor.html
Optimization and Scoring Metrics, provides information about metrics compatible with the AutoML regression task. Regressor Constructor Regressor.train() Regressor.fit() Regressor.predict() Regressor.score() Regressor.explain() ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...