US 11,709,752 B2
Pause and resume in database system workload capture and replay
Myunggon Park, Seoul (KR); Wonyoung Kwak, Seoul (KR); YoungSeok Hwang, Seoul (KR); and Jihun Kang, Seoul (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Apr. 2, 2020, as Appl. No. 16/838,113.
Prior Publication US 2021/0311850 A1, Oct. 7, 2021
Int. Cl. G06F 11/34 (2006.01); G06F 11/30 (2006.01); G06F 16/14 (2019.01); G06F 16/182 (2019.01)
CPC G06F 11/3414 (2013.01) [G06F 11/3034 (2013.01); G06F 11/3466 (2013.01); G06F 16/144 (2019.01); G06F 16/156 (2019.01); G06F 16/182 (2019.01); G06F 2201/80 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for pause and resume during replay of a workload in a target database system, the method being executed by one or more processors and comprising:
receiving a capture file, the capture file comprising data representative of a workload executed in a source database system;
processing the capture file to provide a replay file, the replay file being in a format that is executable by a replayer to replay the workload in a target database system, the workload comprising a set of requests represented within the replay file;
providing a set of tags associated with the replay file, the set of tags comprising one or more tags, each tag being provided after processing of the capture file to provide the replay file, each tag being associated with a request in the set of requests by a request identifier of the request, and each tag being associated with multiple commands of the replayer;
for the request, providing an output file in response to a tag being added to the request, the output file storing metadata of the tag, such that the tag provides a breakpoint for the request when the request is executed in the target database system; and
during replay of the workload in the target database system:
pausing replay of the workload in response to the tag,
executing a request associated with the tag,
providing replay results specific to the request, and
selectively resuming replay of the workload in the target database system; and
wherein the tag comprises one of a pause tag and an exclusive tag, and, if the tag comprises a pause tag all replay activity of the workload is paused and the resuming replay of the workload is performed in response to user input, and if the tag comprises an exclusive tag all replay threads are paused first, then the request is exclusively executed, and the resuming replay of the workload is atomically preformed without user input.