search_index_requests

0 rows


Description

Records requests for (re)indexing of specific contexts. Entries will be removed from this table when indexing of that context is complete. (This table is not used for normal time-based indexing of new content.)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
contextid BIGINT 19 null
context.id searinderequ_con2_fkR

Context ID that has been requested for reindexing.

searcharea VARCHAR 255

Set (e.g. ‘forum-post’) if a specific area is to be reindexed. Blank indicates all areas.

timerequested BIGINT 19 null

Time at which this index update was requested.

partialarea VARCHAR 255

If processing of this context partially completed, set to the area that needs processing next. Blank indicates not processed yet.

partialtime BIGINT 19 null

If processing partially completed, set to the timestamp within the next area where processing should start. 0 indicates not processed yet.

indexpriority BIGINT 19 null

Priority value so that important requests can be dealt with first; higher numbers are processed first

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
searinderequ_con_ix Performance Asc contextid
searinderequ_indtim_ix Performance Asc/Asc indexpriority + timerequested

Relationships