Add NUMA support to PXB

Description

Currently, PXB does not support NUMA as InnoDB does. This cause various issues, including out of memory kills on some environment *when PXB backups large active MySQL server). Please add NUMA support to PXB.

How to Repeat.

1. Start sandbox, create database sbtest, few tables in it and start sysbench /usr/share/sysbench/oltp_point_select.lua:

2. Start backup:

3. While backup is running watch NUMA:

Environment

None

AFFECTED CS IDs

CS0017156

Smart Checklist

Activity

Show:

Jan Mynar February 19, 2025 at 12:25 PM

delivered (explained) by the linked issue (doc) in the comment

Jan Mynar February 19, 2025 at 12:24 PM

please provide a explanation and close the issue

Marcelo Altmann August 10, 2022 at 1:30 PM

Created to deal with documentation improvement.

George Lorch April 8, 2021 at 5:27 PM

Just occurred to me too that at a minimum we should document numa implications in PXB and specifically guidance on --use-memory on numa systems. , can you create a low-prio doc ticket andd add it to your backlog?  Thanks!

Sveta Smirnova April 8, 2021 at 2:52 PM

This is with option --use-memory=10G:

Duplicate

Details

Assignee

Reporter

Labels

Affects versions

Priority

Smart Checklist

Created April 7, 2021 at 3:55 PM
Updated February 19, 2025 at 12:25 PM
Resolved February 19, 2025 at 12:25 PM