mysql multiple database prioritize innodb buffer pool size

Question

With a mysql instance and multiple databases within that instance is there a way to allocate which database you would like to assign priority to the buffer pool size?

Answer 1

You can configure MyISAM dedicated key buffers. No such buffer scheme exists with InnoDB.

Usually, it is recommended to assign up to 80% of server RAM to the InnoDB Buffer Pool.

Since you cannot prioritize which database or tables can occupy the InnoDB Buffer Pool, all you can really do is create a buffer large enough to hold all InnoDB data.

See my earlier posts on sizing the InnoDB Buffer Pool

• Oct 22, 2012 : How large should be mysql innodb_buffer_pool_size?
• Oct 22, 2012 : How much memory do I need for innodb buffer pool? (This was my post on ServerFault that was later migrated to the DBA StackExchange the next day)
• Apr 14, 2011 : What are the main differences between InnoDB and MyISAM?