[MDEV-14054] MySQL High memory issue Created: 2017-10-12  Updated: 2017-11-11  Resolved: 2017-11-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 10.1.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Sukan Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: federated, innodb, memory, need_feedback


 Description   

RAM usage is getting filled up when I execute a simple query against a federated table.

SELECT * FROM `daily_limit` LIMIT 0, 30

*Before : *
free -g
total used free shared buffers cached
Mem: 125 67 57 0 0 10

During Query execution :
free -g
total used free shared buffers cached
Mem: 125 124 1 0 0 30

Processlist :

Note : I've killed the query since memory usage gone high

7663290 admin localhost analytics Killed 451 Sending data SELECT * FROM `daily_limit` LIMIT 0, 30


 Comments   
Comment by Elena Stepanova [ 2017-10-13 ]

Please provide the output of SHOW CREATE TABLE for the local and remote tables, and attach your cnf file(s).

Generated at Thu Feb 08 08:10:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.