MySQL Forums
Forum List  »  Performance

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
1918
May 29, 2016 09: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.