[SOL-593] How to configure database raw and memory size limits Created: 19.02.2018 Updated: 21.08.2020 Resolved: 21.08.2020
|Affects Version/s:||Exasol 6.1.0, EXASOL 6.0.7|
|Reporter:||Captain EXASOL||Assignee:||Captain EXASOL|
Note: This solution is no longer maintained. For the latest information, please visit our Knowledge Base:
Sometimes databases growing too much on data.
It is possible to set size limits for Exasol databases, so as to prevent databases from growing too much on data. This limit can be set for a database instance using database parameters.
You can configure local database limit setting the the following database parameters:
You can either choose a raw data or a memory data limit, but not both.
These parameters are set in the Extra DB Parameters field of the database instance screen:
When the Exasol database reaches 105% of the given size limit, no more data inserts are permitted. This impacts the following SQL actions:
All such statements are rejected with a SQL exception alike the following:
To get the database back to normal operation, you have to reduce its data size below 100% of the limit. You can achieve this by either restarting the database with no or a larger limit, or by deleting or dropping table data.
Whenever your data size passes critical limit margins at 85%, 105% and 100%, you get an EXAoperation warning, error or notice message respectively.
For more information on managing data inserting restrictions and license limits, please consult this article.
|Category 1:||Database Administration|
|Category 2:||Cluster Administration - DB Instance Management|