Reduce log contention by batching log record transfers to the log

A system comprising:

• one or more processors;
• and
• a memory storing instructions that, when executed by at least one processor among the one or more processors, cause the system to perform operations comprising:
• creating a log record in a private log cache that corresponds to a user task, the created log record indicating a data operation to be performed on a portion of a database;
• enqueuing the log record into a queue before the log record is written to an in-memory version of a transaction log distinct from the queue, the enqueuing the log record into the queue comprising adding, to the queue, a pointer to a memory location of the log record in the private log cache;
• writing the log record into the in-memory version of the transaction log after the enqueuing of the log record into the queue distinct from the transaction log;
• and
• writing the log record into a disk version of the transaction log.

A non-transitory machine-readable storage medium comprising instructions that, when executed by one or more processors of a machine, cause the machine to perform operations comprising:

• creating a log record in a private log cache that corresponds to a user task, the created log record indicating a data operation to be performed on a portion of a database;
• enqueuing the log record into a queue before the log record is written to an in-memory version of a transaction log distinct from the queue, the enqueuing the log record into the queue comprising adding, to the queue, a pointer to a memory location of the log record in the private log cache;
• writing the log record into the in-memory version of the transaction log after the enqueuing of the log record into the queue distinct from the transaction log;
• and
• writing the log record into a disk version of the transaction log.