MyISAM的key_buffer_size的InnoDB等效项是什么? [英] What is the InnoDB equivalent of MyISAM's key_buffer_size?

问题描述

使用MyISAM时，配置设置key_buffer_size定义了MySQL缓存常用索引数据块的全局缓冲区的大小.

When using MyISAM the configuration setting key_buffer_size defines the size of the global buffer where MySQL caches frequently used blocks of index data.

InnoDB的对应设置是什么?

What is the corresponding setting for InnoDB?

推荐答案

innodb_buffer_pool_size是用于控制InnoDB用于缓存索引和数据的内存缓冲区大小的设置.这是一个重要的性能选项.

innodb_buffer_pool_size is the setting that controls the size of the memory buffer that InnoDB uses to cache indexes and data. It's an important performance option.

请参见手册页充分的解释. MySQL Performance Blog 也有一篇有关如何选择合适的文章.大小.

See the manual page for the full explanation. The MySQL Performance Blog also has an article about how to choose a proper size for it.

这篇关于MyISAM的key_buffer_size的InnoDB等效项是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！