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 60: Which buffers are only used by Innodb? – 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. plogi6. June 2010 @ 15:49:44


    b c
     
    The name is consistant in this case:
    Innodb specific buffers start with “innodb%”
    The buffer pool and the log buffer are also important for Innodb tuning.

You must be logged in to post a comment.