PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
Declaring a MyISAM table with the DELAY_KEY_WRITE=1 table option makes index updates faster because they are not flushed to disk until the table is closed. Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-spatial-analysis.html
In a non-SPATIAL index, you must declare a prefix for any spatial column except for POINT columns. For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
Unlike the case with partitions defined by range, list partitions do not need to be declared in any particular order. List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
Otherwise, you must declare an indexed column NOT NULL, and you cannot insert NULL into the column. The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
A setting of 0 also enforces the restriction that a function must be declared with the DETERMINISTIC characteristic, or with the READS SQL DATA or NO SQL characteristic. Startup Options Used with Binary Logging System Variables Used with Binary ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
The following procedure uses the increment procedure parameter and counter local variable: CREATE PROCEDURE p(increment INT) BEGIN DECLARE counter INT DEFAULT 0; WHILE counter < 10 DO -- ... variable: { user_var_name | param_name | local_var_name | ...