insert-intention lock, 3080 intention lock, 3080 limitations, 3396 limits, 3394 Linux, 3126 lock modes, 3080 locking, 3080, 3080, 3094 locking reads, 3091 memory usage, 3030 migrating tables, 3027 Monitors, 3390 multi-versioning, 3004 new features, 12 next-key lock, 3080, 3098 NFS, 3103 on-disk structures, 3016 online DDL, 3175 page size, 3042 physical index structure, 3042 point-in-time recovery, 3347 primary keys, 3017, 3032 raw partitions, 3051 record-level locks, 3098 recovery, 3347 redo log, 3074, 3074 REDUNDANT row format, 3166 replication, 3350 restrictions, 3396 row format, 3017, 3171 secondary index, 3041 shared lock, 3080 Solaris issues, 202 sorted index builds, 3042 storage, 3032 storage layout, 3031 system variables, 3205 table properties, 3017 tables, 3016 converting from other storage engines, 3029 transaction model, 3080, 3085 transactions, 3030 transferring data, 3032 troubleshooting, 3390 cannot open datafile, 3393 data dictionary problems, 3393 deadlocks, 3098, 3100 defragmenting tables, 3174 I/O problems, 3390 online DDL, 3195 performance problems, 1745 recovery problems, 3391 restoring orphan ibd files, 3393 SQL errors, 3394 InnoDB buffer pool, 1815, 3009, 3110, 3115, 3115, 3116, 3119 

