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-sys-foreign-table.html
The INNODB_SYS_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). TYPE A collection of bit flags with information about the foreign key ... The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table has these columns: TABLE_ID The table ID of the temporary table. The number includes three hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). Use the INFORMATION_SCHEMA COLUMNS table or the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.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 an LRU_POSITION column instead of a BLOCK_ID column. The definition for this page is the same as for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-row-events.html
# at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP '/*!*/; ### DELETE FROM ... The following examples illustrate how mysqlbinlog displays row events that specify data ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
For mysqldump --tab, the server by default writes table data to .txt files one line per row with tabs between column values, no quotation marks around column values, and newline as the line terminator. INTO OUTFILE.) To enable data files to be ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
Suppose that a join query over 3 tables T1,T2,T3 has this form: SELECT * FROM T1 INNER JOIN T2 ON P1(T1,T2) INNER JOIN T3 ON P2(T2,T3) WHERE P(T1,T2,T3) Here, P1(T1,T2) and P2(T3,T3) are some join conditions (on expressions), whereas P(T1,T2,T3) is ...The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
When doing bulk inserts into tables with auto-increment columns, set innodb_autoinc_lock_mode to 2 instead of the default value 1. For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. If you insert a row into a table partitioned by RANGE such that the column value ...Even though it is permitted to use NULL as the value of an expression that must otherwise yield an integer, it is important to keep in mind that NULL is not a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
The events_transactions_current table has these columns: THREAD_ID, EVENT_ID The thread associated with the event and the thread current event number when the event starts. END_EVENT_ID This column is set to NULL when the event starts and updated to ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The OBJECT_TYPE column indicates the type of object to which a row applies. The OBJECT_SCHEMA and OBJECT_NAME columns should contain a literal schema or object name, or '%' to match any name. The ENABLED column indicates whether matching objects are ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...