MMA Settings – Meta Query
MetaMiner Query Agent is a separate Java-application supplied in a software set together with MMTE Server.
To open Meta Query settings:
- Open MMTE Administrator.
- Choose Preferences – Settings from the main menu.
- Choose Meta Query category.
Meta Query Settings¶
|Allow Write Commands||Checkbox/Boolean||False||Set to enable active SQL commands that change the database content, like
|Convert Unknown Types||Checkbox/Boolean||False||If set, then RDBMS-specific JDBC data types/classes (like
|Result Set Threshold||Positive Integer||5||Set the limit for the maximum size of the result set which can be sent to you immediately following your queries. If the result set exceeds this threshold, a warning will be displayed, indicating the expected result set size, and user will have to confirm transfer. Measurement: Megabytes. Range: 5 to 50.|
|Worker threads||Positive Integer||3||Set the limit for the maximum number of threads of MMTE Server which can be utilized for running your queries simultaneously. Range: 1 to 5. If set to 1, all queries will be executed sequentially one by one.|
|Result Set Fetch Size||Positive Integer||10000||Set the limit for the maximum size of the result set which can be sent to you following your queries. Measurement: rows. Range: 100 to 100000.|
Configure RAM that can be allocated to JVM of MetaMiner Query Agent. It runs as a standalone Java application and is started and stopped by MMTE Server automatically. Its process run under the same account and with the same privileges as MMTE Server.
|Limit max memory to quarter of physical memory||Checkbox/Boolean||True||If checked, JVM of MetaMiner Query Agent will not be able to allocated more than ¼ of the size of physically installed RAM of the server machine.|
|Memory allocation for Meta Query agent||Positive Integer||2||You can limit RAM available for JVM of MetaMiner Query Agent by this setting. If specified, this value will be applied as XMS and XMX VMARG parameters when starting Meta Query Agent. If the checkbox above is set, then this value cannot exceed ¼ of physical RAM. Otherwise, it should not exceed
This timeout helps keeping your MMDB respond with no delays. If you allow to run too "heavy" queries, it may affect the system performance.
|Meta Query timeout period||Positive Integer||10||Set the limit for the maximum time allowed for running your requests in MMDB from Meta Query. Measurement: minutes. Range: 5 to 20.|