Hi!
How can I increase the memory? I want to load a 100M+ sql script (dump), but I get out of memory error.
I tried dbeaver -vmargs -Xmx768m but it's not work...
-Xmx option
3 posts
• Page 1 of 1
Re: -Xmx option
by Serge » Wed Mar 14, 2012 5:51 pm
Hi!
1. It is really not a good idea to execute huge scripts in SQL editor. 100M scipt will eat a few gigabytes of memory (due to syntax highlighting and other intellectual text editor features).
To execute huge scripts (e.g. database dumps) you may use "Execute script" tool (you may find it in Tools submenu of database context menu or "Database" main menu). "Execute scipt" tool is available only for MySQL. Oracle has similar tool "Execute in SQL*Plus". For other databases you should use some native client features.
2. Actually -vmargs works fine. E.g. you may start DBeaver with parameters "-vmargs -Xms500m" - and you will see that initial heap size is about 500Mb. I think 768Mb just not enough for your script (see p.1) so it doesn't make sense to increase maximum memory size for such big scripts.
Thanks!
1. It is really not a good idea to execute huge scripts in SQL editor. 100M scipt will eat a few gigabytes of memory (due to syntax highlighting and other intellectual text editor features).
To execute huge scripts (e.g. database dumps) you may use "Execute script" tool (you may find it in Tools submenu of database context menu or "Database" main menu). "Execute scipt" tool is available only for MySQL. Oracle has similar tool "Execute in SQL*Plus". For other databases you should use some native client features.
2. Actually -vmargs works fine. E.g. you may start DBeaver with parameters "-vmargs -Xms500m" - and you will see that initial heap size is about 500Mb. I think 768Mb just not enough for your script (see p.1) so it doesn't make sense to increase maximum memory size for such big scripts.
Thanks!
- Serge
- Posts: 1526
- Joined: Sat Feb 26, 2011 8:24 pm
- Location: SPb
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests