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/handler.html
It is faster than HANDLER tbl_name READ index_name when a full table scan is desired. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
U+FFFF Permitted characters in quoted identifiers include the full Unicode Basic Multilingual Plane (BMP), except U+0000: ASCII: U+0001 .. Depending on context, it might be interpreted as the expression 1e + 3 or as the number 1e+3. Certain objects ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
For example, the following two queries are equivalent: SELECT * FROM t1 USE INDEX (i1) IGNORE INDEX (i2) USE INDEX (i2); SELECT * FROM t1 USE INDEX (i1); For FULLTEXT searches, index hints work as follows: For natural language mode searches, index ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
In the output from SHOW FULL COLUMNS, the privileges are all in one column and in lowercase, for example, select,insert,update,references. The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
For example, if you say SHOW FULL COLUMNS FROM t, and you see in the COLLATION_NAME column a value of latin1_swedish_ci, the character set is what is before the first underscore: latin1. The COLUMNS table has these columns: TABLE_CATALOG The name of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
FREE_EXTENTS For InnoDB: The number of fully free extents in the current data file. TOTAL_EXTENTS For InnoDB: The number of full extents used in the current data file. The FILES table provides information about the files in which MySQL tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST SHOW FULL PROCESSLIST . The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. TABLE_TYPE BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
If log files become full, a sharp checkpoint occurs, causing a temporary reduction in throughput. InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer pool. Dirty pages are those that have been modified ...