1

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?

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.