US 10,706,009 B2Granted

Techniques to parallelize CPU and IO work of log writes

AssigneeOracle International Corporation

InventorsChi Cao Minh, Yunrui Li, Jonghyun Lee

Life of this patent

Estimating the term…

Loading patent…

Abstract

Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a system, log data is stored in one or more buffers. In response to receiving a request to perform a logical write, a first process writes a first portion of the log data to a log file in persistent storage. While the first portion of the log data is being written to the log file, a second process writes a second portion of the log data in the one or more buffers to the log file in persistent storage. In another embodiment, a request to perform a second logical write may be received before the first logical write completes. While the first log data is being written to the log file, one or more processes write second log data for the second logical write to the log file.

Claims23

Dependent claims

A method comprising:

storing log data in one or more buffers;
receiving a first request to write first log data for one database to one log file stored in persistent storage;
in response to the first request:
determining a first location in the log file and a second location in the log file for respectively writing a first portion and a second portion of the first log data to preserve an ordering of the first and second portions, wherein the second location is based on a size of the first portion;
writing, using a first process, the first portion of the first log data in the one or more buffers to said first location in the log file in persistent storage;
while the first portion of the first log data is being written to the first location in the log file, concurrently writing, using a second process, the second portion of the first log data in the one or more buffers to said second location in the log file in persistent storage;
and
after determining that the first portion and the second portion are written to the log file, sending a notification that the first log data is written to the log file;
determining based on one or more collected metrics, to disable parallel log writing;
after determining to disable parallel log writing receiving a second request to write second log data to the log file;
in response to receiving the second request, writing all of the second log data to the log file;
wherein the method is performed by one or more computing devices.

9 more elements

Non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

storing log data in one or more buffers;
receiving a first request to write first log data for one database to one log file stored in persistent storage;
in response to the first request:
determining a first location in the log file and a second location in the log file for respectively writing a first portion and a second portion of the first log data to preserve an ordering of the first and second portions;
writing, using a first process, the first portion of the first log data in the one or more buffers to said first location in the log file in persistent storage;
while the first portion of the first log data is being written to the first location in the log file, concurrently writing, using a second process, the second portion of the first log data in the one or more buffers to said second location in the log file in persistent storage;
and
after determining that the first portion and the second portion are written to the log file, sending a notification that the first log data is written to the log file;
determining based on one or more collected metrics, to disable parallel log writing;
after determining to diable parallel log writing, receiving a second request to write second log data to the log file;
in response to receiving the second request, writing all of the second log data to the log file.

8 more elements

Dependencies are inferred from the claim text.