MySQL Bugs: #79457: Memory consumtion and request errors during table scan

Bug #79457	Memory consumtion and request errors during table scan
Submitted:	30 Nov 2015 13:51	Modified:	19 Mar 2020 17:20
Reporter:	Mike Pentagra	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Cluster: NDB API	Severity:	S5 (Performance)
Version:	7.4.7	OS:	Oracle Linux
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
We observe high memory consumption and, as a result of swapping due to high memory load, request errors on client side while doing table scan and parallel requests to another table within same transaction.
Table size - about 80k records.

How to repeat:
Scan table using NDB api, for each received data from scaned table request data by id from another table within one transaction.
Sample tables and code in attachments.

sample tables and some to reporoduce the problem

Attachment: tables.tar.bz2 (application/x-bzip2, text), 1.72 MiB.

sample tables and some to reporoduce the problem

Attachment: ndb_ty.cpp (application/octet-stream, text), 5.67 KiB.

Hi,

I need some additional details from you.

* How did you configure your cluster?
* Where do you see increased data usage, on data nodes or on the api node?

thanks

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".