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/create-trigger.html
Basic column value checks occur prior to trigger activation, so you cannot use BEFORE triggers to convert values inappropriate for the column type to valid values. Within the trigger body, you can refer to columns in the subject table (the table ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased in length. All credentials are stored in the authentication_string column, ... Before downgrading from MySQL 5.7, review the information in this ...
https://dev.mysql.com/doc/refman/5.7/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table has the same columns as the INNODB_BUFFER_PAGE table, except that the INNODB_BUFFER_PAGE_LRU table has LRU_POSITION and COMPRESSED columns instead of BLOCK_ID and PAGE_STATE columns. The INNODB_BUFFER_PAGE_LRU table ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
The data in this column is interpreted from the tablespace flags information that resides in the .ibd file. The data in this column is interpreted from the tablespace flags information that resides in the .ibd file. The data in this column is ...
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. (In-memory data resource usage is reported by the DATA_LENGTH column.) For partitioned tables, this value is only an estimate and may not be ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
It can also be employed to obtain the types of the result columns within applications that use a MySQL API that makes result set metadata available. With the mysql client program, you can use the --column-type-info option to display result column ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
For foreground threads (resulting from client connections), the initial values of the INSTRUMENTED and HISTORY columns in threads table rows are determined by whether the user account associated with a thread matches any row in the setup_actors ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
Each wait event summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_waits_summary_by_account_by_event_name has EVENT_NAME, ... The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
auto_increment_increment and auto_increment_offset affect AUTO_INCREMENT column behavior as follows: auto_increment_increment controls the interval between successive column values. The highest value present in the col column prior to the INSERT is ... This section describes the server options and system variables that you can use on replication source ...