https://dev.mysql.com/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
https://dev.mysql.com/innodb-buffer-pool.html
On 64-bit systems with sufficient memory, you can split the buffer pool into multiple parts to minimize contention for memory structures among concurrent operations. The buffer pool is an area in main memory where InnoDB caches table and index data ...
https://dev.mysql.com/innodb-columns-table.html
PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”.
https://dev.mysql.com/innodb-foreign-table.html
TYPE A collection of bit flags with information about the foreign key column, ORed together. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FOREIGN table has these ...
https://dev.mysql.com/innodb-indexes-table.html
TYPE A numeric value derived from bit-level information that identifies the index type. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these ...
https://dev.mysql.com/innodb-init-startup-configuration.html
Warning On 32-bit GNU/Linux x86, be careful not to set memory usage too high. The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers. It is recommended that you ...
https://dev.mysql.com/innodb-multi-versioning.html
Also, a deletion is treated internally as an update where a special bit in the row is set to mark it as deleted. InnoDB is a multi-versioned storage engine: it keeps information about old versions of changed rows, to support transactional features ...
https://dev.mysql.com/innodb-redo-log.html
For example: mysql> SET GLOBAL innodb_redo_log_archive_dirs='label1:directory_path1[;label2:directory_path2;…]'; The label is an arbitrary identifier for the archive directory. On Windows, the performance impact is typically a bit higher, assuming ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/innodb-tables-table.html
FLAG A numeric value that represents bit-level information about table format and storage characteristics. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table ...
https://dev.mysql.com/innodb-tablespaces-brief-table.html
FLAG A numeric value that represents bit-level information about tablespace format and storage characteristics. The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and ...
