Database memory management in a high availability database system using limits

A system comprising:

• at least one data processor;
• and
• memory storing instructions, which when executed by at least one data processor, result in operations comprising:
• receiving a first statement including requests for database operations in a secondary database system, the secondary database system comprising data replicated from a primary database system by replaying transaction logs containing output generated by the primary database system;
• requesting responsive to the first statement, an allocation of memory from the secondary database system to support the requested database operations;
• generating an aggregated statement memory consumption value based on the amount of memory consumed by all statements executing in the secondary database system that are not associated with replaying the transaction logs;
• determining that the requested allocation of memory in addition to the aggregated statement memory consumption value exceeds a total statement execution memory limit value indicating the total amount of memory that is available for allocation to all database operations associated with statements executed by a secondary database system;
• and
• denying responsive to the determination, the requested allocation of memory.

A non-transitory computer program product storing instructions which, when executed by at least one data processor forming part of at least one computing device, result in operations comprising:

• receiving a first statement including requests for database operations in a secondary database system, the secondary database system comprising data replicated from a primary database system by replaying transaction logs containing output generated by the primary database system;
• requesting responsive to the first statement, an allocation of memory from the secondary database system to support the requested database operations;
• generating an aggregated statement memory consumption value based on the amount of memory consumed by all statements executing in the secondary database system that are not associated with replaying the transaction logs;
• determining that the requested allocation of memory in addition to the aggregated statement memory consumption value exceeds a total statement execution memory limit value indicating the total amount of memory that is available for allocation to all database operations associated with statements executed by a secondary database system;
• and
• denying responsive to the determination, the requested allocation of memory.