Date: Wed, 11 Sep 2019 16:54:04 +0000 From: bugzilla-noreply@freebsd.org To: bugs@FreeBSD.org Subject: [Bug 231457] Out of swap space on ZFS Message-ID: <bug-231457-227-Jb54O45Jmp@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-231457-227@https.bugs.freebsd.org/bugzilla/> References: <bug-231457-227@https.bugs.freebsd.org/bugzilla/>
index | next in thread | previous in thread | raw e-mail
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=231457 Parashiva <parashiva@outlook.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |parashiva@outlook.com --- Comment #16 from Parashiva <parashiva@outlook.com> --- Hello, My server also with same error "mysqld killed out of swap space" when I import an 70G+ mysql dump (mysqldump -u root -p database -r dump.sql). The server's hardware is 256G SSD*2, 32G RAM, CPU e3-1245 v3, with latest freebsd 12, zfs mirror, atime=off,primarycache=all,secondarycache=none. I tried below solutions: 1. trick learn from stackoverflow.com set global net_buffer_length=1048576; set global max_allowed_packet=1073741824; SET foreign_key_checks = 0; not working 2. disable swap not working 3. then I think it related to RAM or SWAP, should I disabled ARC? zfs set primarycache=none tank working!!! So I have my database working now. Hope my experience could help someone. Thank you, Best Regards. -- You are receiving this mail because: You are the assignee for the bug.help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-231457-227-Jb54O45Jmp>