Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.7
-
Linux 4.9.0-5-amd64 #1 SMP Debian 4.9.65-3+deb9u2 (2018-01-04) x86_64 GNU/Linux
Description
Same issue as MDEV-13403.
After a couple of days and quite a bit of "load data infile", mysqld dies with out of memory (eventually consuming 1TB of RAM and 100GB of swap).
We have several identical servers (load balanced), and they keep crashing with out of memory every couple of days one after the other.
All our tables are using tokudb.
Our cnf file is attached.
Attachments
Issue Links
- relates to
-
MDEV-13403 Mariadb (with TokuDB) excessive memory usage/leak
- Closed
We have a hunch that this is related to haproxy. In the general query log we see this every 2 seconds:
180727 16:31:21 44597 Connect haproxy_check@... as anonymous on
44597 Quit
180727 16:31:23 44598 Connect haproxy_check@... as anonymous on
44598 Quit
When we had a single server with exactly the same install, the box was up and running fine for more than two weeks. Once we setup the replicas and started running haproxy, out of memory issues ensued.
We will stop haproxy and see if that alleviates the problem, but this still sounds like a mysql memory leak (maybe connection related).