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/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D231457 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 imp= ort 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=3Doff,primarycache=3Dall,secondarycache=3Dnon= e. I tried below solutions: 1. trick learn from stackoverflow.com set global net_buffer_length=3D1048576; set global max_allowed_packet=3D1073741824; SET foreign_key_checks =3D 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=3Dnone tank working!!! So I have my database working now. Hope my experience could help someone. Thank you, Best Regards. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-231457-227-Jb54O45Jmp>