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 59: Which buffers are only used by Myisam? – MySQL Question of the Day

Skip to content

By plogi in mysql questions
a) bulk_insert_buffer_size        8388608
b) innodb_buffer_pool_size        8388608
c) innodb_log_buffer_size         1048576
d) join_buffer_size               131072
e) key_buffer_size                8388600
f) myisam_sort_buffer_size        8388608
g) read_buffer_size               131072
h) read_rnd_buffer_size           262144
i) sort_buffer_size               2097144

 
[ MySQL Architecture (10%) - How MySQL Uses Memory ]

Tags: , ,

Comment Feed

One Response

  1. plogi5. June 2010 @ 13:03:31


    a e i
     
    The bulk insert buffer and the key buffer are used just by myisam,
    even though the name doesn’t imply that ;-)
    Read-, join- and sort buffer and not engine-specific.

You must be logged in to post a comment.