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?
Take the 2-minute tour
×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
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
|
|||
|
|
