Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 53: Storage engines and their features – MySQL Question of the Day

Skip to content

By plogi in mysql questions

 
Connect the storage engines a-d with their features 1-4
 
a) InnoDB
b) MyISAM
c) BLACKHOLE
d) MEMORY
 
1) Very fast and supports hash indexes
2) Does not store anything – can be useful for example in some replication scenarios
3) Transactions and row-level locking
4) Fast and is MySQL’s default (in 5.0)
 
[ Basic Optimizations (10%) - Choosing Appropriate Storage Engines ]

Tags: , ,

Comment Feed

One Response

  1. plogi29. May 2010 @ 23:42:37


    a-3, b-4, c-2, d-1

You must be logged in to post a comment.