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/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, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
The column named “mysql.proc Name” indicates the mysql.proc table column that corresponds to the INFORMATION_SCHEMA ROUTINES table column, if any. The ROUTINES table has these columns: SPECIFIC_NAME The name of the routine. If you do not have ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. For fast join performance, define foreign keys on the join columns, and declare those columns ...Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
The c1 column maps to the key, the c2 column to the value, the c3 column to the flag value, the c4 column to the cas value, and the c5 column to the expiration time. Because the daemon_memcached plugin supports the MySQL binary log, updates made on ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
When the argument is a JSON column, this is the space used to store the JSON document. This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
A local variable should not have the same name as a table column. INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. Consequently, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-storage-requirements.html
The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to the space required to store the largest possible value for that column. In a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed ...