MySQL Forums
Forum List  »  InnoDB

Re: InnoDB on RAMdisk optimization for specific purpose
Posted by: Rick James
Date: May 01, 2013 11:16PM

> Is decreasing of InnoDB buffer pool to 16Mb or less is viable here, or will it cause severe performance loss?

At some point (tiny buffer_pool), InnoDB will consume a lot of resources swapping blocks between the buffer_pool and the RAM disk.

For maximal performance, I would recommend making the RAM disk only as big as it needs to be to hold the various files (.ibd, ibdata1, 2 iblog files), plus a little bit of room just in case. Then give most of the rest to the buffer_pool.

The iblog files don't need to be very big; perhaps the default, perhaps smaller.

I don't know what parameters you can set on the RAM disk, but something equivalent to O_DIRECT would avoid the extra copy of buffered I/O.

I have never tried what you describe; I am guessing, based on understanding how things work.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB on RAMdisk optimization for specific purpose
1278
May 01, 2013 11:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.