Search Index Requests Table Schema (search_index_requests)


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.)

search_index_requests table columns

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

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

Table contained -1 rows

search_index_requests table 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

search_index_requests table relationships

Close relationships within degrees of separation