comdb2 icon indicating copy to clipboard operation
comdb2 copied to clipboard

{172983130}: Limiting number of rows returned in comdb2_sc_history

Open riverszhang89 opened this issue 10 months ago • 0 comments

It takes a whopping 75GiB memory to query the comdb2_sc_history table of 2.4 million records, against the database in the linked ticket. In this patch comdb2_sc_history and comdb2_sc_status are changed to return the most recent 10K records.

A memory leak in the comdb2_sc_status system table is also fixed, in this patch.

riverszhang89 avatar Mar 27 '24 18:03 riverszhang89