MyISAM的key

本文介绍了MyISAM的key_buffer_size的InnoDB等效项是什么?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

使用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.