PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab parser plugin. Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_CREATE_RATE The number of pages created per second (pages created since the last printout / time elapsed). The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
Most indexes created implicitly by InnoDB have consistent names but the index names are not necessarily unique. For GEN_CLUST_INDEX indexes, this value is 0 because the index is created using an artificial value rather than a real table column. Any ... The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the information in the internal SYS_INDEXES table in the InnoDB data ...
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/innodb-locking.html
For such cases, InnoDB creates a hidden clustered index and uses this index for record locking. Client A creates a table containing two index records (90 and 102) and then starts a transaction that places an exclusive lock on index records with an ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
Creating a New Table and Column Mapping This example shows how to setup your own InnoDB table with the daemon_memcached plugin. mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. In addition, MySQL Enterprise Backup can create compressed backup files, and back up subsets of tables. This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. Secondary indexes are not created as efficiently because keys are inserted in the order they appeared in the primary key. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
Online DDL operations have the following space requirements: Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a table. Temporary sort files: Online DDL operations that rebuild ...The temporary log file is extended as required by the value of innodb_sort_buffer_size up to a maximum specified by ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-tablespaces.html
If a directory location is not specified, undo tablespaces are created in the data directory. Create a new MySQL test instance using the configuration settings you have chosen. Undo Tablespace Truncation Recovery An undo tablespace truncate ... Undo ...