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 54: Which are scenarios for MyISAM tables? – MySQL Question of the Day

Skip to content

Question 54: Which are scenarios for MyISAM tables?

31. May 2010
By plogi in mysql questions

1 Comment

 
(Find all correct answers)
 
a) Summary tables
b) Concurrency
c) Small foot-print on disk
d) No transactions
 
[ Basic Optimizations (10%) - Choosing Appropriate Storage Engines ]

Tags: , ,

Comment Feed

One Response

  1. plogi — 31. May 2010 @ 18:49:11 —


    a c d
     
    MyISAM is fast, and the table-locking is of little consequence for read-heavy tables.
    It stores data in an efficient way and offers index-compression.
    If your tables are written into and read from all the time by many connections,
    then MyISAM is not the right choice.

You must be logged in to post a comment.