PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
SHOW ENGINE INNODB MUTEX output has these columns: Type Always InnoDB. The connection row's Status column contains the name/value pairs described in the following table. An NdbBlob is created for each new operation involving a BLOB column in an NDB ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
Name Conflicts within Stored Routines The same identifier might be used for a routine parameter, a local variable, and a table column. The behavior that variables take precedence over table columns is nonstandard. However, the time shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. For example, '41' is stored into a CHAR(3) column as '41 ' and retrieved as '41' (with the trailing pad ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
For comparisons of strings with column values, collation_connection does not matter because columns have their own collation, which has a higher collation precedence (see Section 10.8.4, “Collation Coercibility in Expressions”). This includes ...
https://dev.mysql.com/doc/refman/5.7/en/fixed-point-types.html
In a DECIMAL column declaration, the precision and scale can be (and usually is) specified. Standard SQL requires that DECIMAL(5,2) be able to store any value with five digits and two decimals, so values that can be stored in the salary column range ... The DECIMAL and NUMERIC types store exact numeric data ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
MySQL also determines when to evaluate functions based on types of arguments, whether the arguments are table columns or constant values. A deterministic function that takes a table column as argument must be evaluated whenever that column changes ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
In this context, the table data is treated as just another index, one that happens to contain all the columns: the clustered index. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables have these columns: DATABASE_NAME The schema ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including ... The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
The INNODB_METRICS table has these columns: NAME A unique name for the counter. (The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
This is the same value displayed in the Id column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. For system user, ...