MySQL Forums :: Performance :: A proposal to make disk IO much faster under SSD


Advanced Search

A proposal to make disk IO much faster under SSD
Posted by: suiyemin sui ()
Date: May 29, 2016 09:16PM

Problem: CentOS, insert+commit operation is very slow. There are 3 types of files need to be synced to ensure data persistence: innodb data files, log files and binary log files.

In current implementation, for each commit the fsync or fdatasync will be invoked to ensure data persistence. That will cost 3~4 milliseconds. That's necessary for HDD. However, there is a much better way for SSD.

Proposal under SSD: use directIO for all those files without data sync. For volatile cache inside SSD, just disable it.(For industry level SSD, there will be a non-volatile cache inside SSD which will make SSD fast enough.) In this way, the commit operation will cost only about 200 microseconds.

I know it's not easy to support full directIO. But it will be fascinating fast.

Best Regards,
Yemin

Options: ReplyQuote


Subject Views Written By Posted
A proposal to make disk IO much faster under SSD 708 suiyemin sui 05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD 437 Rick James 05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD 349 suiyemin sui 06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD 308 Rick James 06/04/2016 04:38PM


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.