PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-identifying.html
If you enable a different file format using the innodb_file_format configuration option, the change only applies to newly created tables. Also, when you create a new table, the tablespace containing the table is tagged with the “earliest” or ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
If an indexed column cannot contain any NULL values, declare it as NOT NULL when you create the table. The optimizer can better determine which index is most effective to use for a query, when it knows whether each column contains NULL values. To ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/partitioning-overview.html
This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning restrictions and feature limitations, see Section 22.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME For a prepared statement created by a client session, these columns are NULL. These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, ...
https://dev.mysql.com/doc/refman/5.7/en/row-constructor-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: const rows: 3 filtered: 100.00 Extra: Using where In such cases, rewriting the row constructor ...For ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SHOW CREATE TABLE quotes table and column names ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other single-value types (POINT, LINESTRING, and POLYGON) restrict their values to a particular geometry type.