[Bug 231457] Out of swap space on ZFS

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=231457

Parashiva <parashiva at outlook.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |parashiva at outlook.com

--- Comment #16 from Parashiva <parashiva at 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.