Aside from these blog postings: http://yatb.mitza.net/2012/10/slow-db-performance-on-content-manager.html and http://www.mrgn.co/2012/10/tridion-error-unable-to-notify-server/ I can't find details on these two tables (QUEUE_CONSUMERS
and QUEUE_FILTERS
).
Back in the early days of our project, database schemas were copied here and there across environments and we have dozens of host names in our QUEUE_CONSUMERS
table which shouldn't be there. So, I'm setting the IS_ONLINE=0
for those hosts.
Can anyone explain a little more about that table? For example:
- how do host names get added in there?
- why do I have 4 entries for each host name (4 separate "port" values)?
- what does the "port" indicate? (I know what a port is... but these aren't our CME or deployer port #s: each host in our system has 1150, 1151, 1152, and 1153)
- What within Tridion is using this table?
- Why did support tell me to mark
IS_ONLINE=0
instead of deleting the rows?
Now, how about QUEUE_FILTERS
?
- this seems to have 4 rows for each
QUEUE_CONSUMERS
entry, but each has "-1" for the VALUE column. what's the point of that? - What within Tridion is using this table?
And, yes, I know all the standard disclaimers: don't touch, will make your system unstable, unsupported, etc. I just want to understand what's going on here.