https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=231457
Parashiva <parash...@outlook.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |parash...@outlook.com
--- Comment #16 from Parashiva <parash...@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.
_______________________________________________
freebsd-bugs@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-bugs
To unsubscribe, send any mail to "freebsd-bugs-unsubscr...@freebsd.org"
