extra arkcmp processes being started during query compilation
Bug #1403987 reported by
Anoop Sharma
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Committed
|
High
|
Anoop Sharma |
Bug Description
An extra arkcmp process is being started when a query is getting compiled.
This will result in doubling the number of processes and will have impact on memory,
jvm usage as well as number of processes on the system. At higher concurrency, performance
will start to degrade. It will also start to impact multithreaded perf as there will now be
an extra external process started per thread.
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
status: | In Progress → Fix Committed |
To post a comment you must log in.
Internal calls to get metadata information was not using embedded compiler.
This showed up during read of metadata as well as when user/role info was
being read.
To check it, one can do:
sqps | grep arkcmp
before and after running a 'prepare' statement on a user table from sqlci
or running sqlci with an external user (sqlci -usql_user1).
and see if an extra arkcmp process is started.