Invention Grant
- Patent Title: Tuning memory across database clusters for distributed query stability
-
Application No.: US15085410Application Date: 2016-03-30
-
Publication No.: US10228855B2Publication Date: 2019-03-12
- Inventor: Ian R. Finlay , Christian M. Garcia-Arellano , Adam J. Storm , Gennady Yakub
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Robert C. Bunker
- Main IPC: G06F3/06
- IPC: G06F3/06 ; G06F9/50 ; G06F17/30

Abstract:
A method for optimizing query compilation by tuning memory across a database cluster is provided. The method may include receiving, by a global memory tuner, memory configuration information from a plurality of nodes within the database cluster. The method may also include determining a node within the plurality of nodes having a least available memory value relative to a remainder of nodes within the plurality of nodes based on the received memory configuration information. The method may then include calculating a globally tuned memory value based on a memory value associated with the determined node. The method may further include determining a memory distribution based on the calculated globally tuned memory value. The method may also include sending the determined memory distribution to the plurality of nodes.
Public/Granted literature
- US20170285964A1 TUNING MEMORY ACROSS DATABASE CLUSTERS FOR DISTRIBUTED QUERY STABILITY Public/Granted day:2017-10-05
Information query