What is the InnoDB equivalent of MyISAM's key_buffer_size?

mysql performance innodb myisam
knorv picture knorv · Aug 2, 2009 · Viewed 19.6k times · Source

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.

What is the corresponding setting for InnoDB?

Answer

zombat picture zombat · Aug 2, 2009

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.

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.

Related questions

MyISAM versus InnoDB

I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would also include updates which I consider to be one read and one write. The reads can be dirty (e.g. …

Read More
Is there a REAL performance difference between INT and VARCHAR primary keys?

Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I'd like to use VARCHAR as the primary key for reference lists (think US States, Country Codes) and a coworker won't budge on …

Read More
Why is MySQL InnoDB insert so slow?

I am using large random numbers as keys (coming in from another system). Inserts and updates on fairly-small (as in a few million rows) tables are taking much longer than I think is reasonable. I have distilled a very simple …

Read More