MemoryRefresh!

Administration / Innodb     Innodb



Questions Answers 0%

Pages   0 from 12
Questions   0 from 14

Reset


MyISAM tables
Only one write could be in progress at any time. Data in MyISAM tables is split between three different files on the disk. One for the table format, another for the data, and lastly a third for the indexes. Text/Blob fields are able to be fully-indexed which is of great importance to search functions.
InnoDB tables
Are transaction-safe meaning data-integrity is maintained throughout the entire query process. Provides row-locking, as opposed to table-locking, meaning while one query is busy updating or inserting a row, another query can update a different row at the same time. These features increase multi-user concurrency and performance. Another great feature InnoDB tables is the ability to use foreign-key constraints. Because of its row-locking feature InnoDB is said to thrive in high load environments. Its CPU efficiency is probably not matched by any other disk-based relational database engine.
Default engine
The default engine is InnoDB as of MySQL 5.5.5 (MyISAM before 5.5.5)
stackoverflow.com dev.mysql.com
1) Which engine provides row-locking




2) Which engine provides foreign-key feature?




3) Can you use fully-indexed text/blob fields with InnoDB?







MyISAM tables
Only one write could be in progress at any time. Data in MyISAM tables is split between three different files on the disk. One for the table format, another for the data, and lastly a third for the indexes. Text/Blob fields are able to be fully-indexed which is of great importance to search functions.
InnoDB tables
Are transaction-safe meaning data-integrity is maintained throughout the entire query process. Provides row-locking, as opposed to table-locking, meaning while one query is busy updating or inserting a row, another query can update a different row at the same time. These features increase multi-user concurrency and performance. Another great feature InnoDB tables is the ability to use foreign-key constraints. Because of its row-locking feature InnoDB is said to thrive in high load environments. Its CPU efficiency is probably not matched by any other disk-based relational database engine.
Default engine
The default engine is InnoDB as of MySQL 5.5.5 (MyISAM before 5.5.5)
stackoverflow.com dev.mysql.com





Programming

Php
   
Regex
   
MySQL
   
Css
   
jQuery
   
Git
   


References
n/a