PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
mysql> SELECT index_id, name, table_id, space from INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE index_id=457; +----------+------+----------+-------+ | index_id | name | table_id | space | +----------+------+----------+-------+ | 457 | idx | 327 | 283 ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-files-table.html
mysql> SELECT FILE_ID, FILE_NAME, FILE_TYPE, TABLESPACE_NAME, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE, DATA_FREE, STATUS ENGINE FROM INFORMATION_SCHEMA.FILES WHERE TABLESPACE_NAME LIKE 'innodb_system' \G ... The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G Empty set (0.00 sec) An empty set is returned because INNODB_TEMP_TABLE_INFO and its data are not persisted to disk when the server is shut down. INNODB_TEMP_TABLE_INFO provides ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
mysql> SELECT * FROM test.city; +---------+-----------+-----------+---------+-------+------+--------+ | city_id | name | state | country | flags | cas | expiry | +---------+-----------+-----------+---------+-------+------+--------+ | B | BANGALORE | ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be somewhat slower than using memcached by itself. When using the InnoDB memcached plugin, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, the row is a “phantom” row. If you were to execute the same SELECT within the same transaction, you would see a new row with an ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
A transaction ID is only needed for a transaction that might perform write operations or locking reads such as SELECT ... The autocommit setting is turned on, so that the transaction is guaranteed to be a single statement, and the single statement ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
mysql> SELECT @@innodb_default_row_format; +-----------------------------+ | @@innodb_default_row_format | +-----------------------------+ | dynamic | +-----------------------------+ mysql> CREATE TABLE t1 (c1 INT); mysql> SELECT * FROM ... The row ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%ldap%'; +----------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------------+---------------+ | ...