What data is stored in ostjobs__search? To me it looks like a cache of search queries.
Can I delete old rows from this table to optimize on space?
Thanks
Can I delete rows from table ostjobs__search?
It’s not cache it’s an actual permanent table holding most searchable data. You can delete rows but you’ll likely remove data that needs to be there for search. What you can do is truncate the table, set reindex = 1 in the config table, and run cron a bunch of times to repopulate the table. You need to run cron manually until reindex is set back to 0 automatically.
Cheers.
KevinTheJedi Thanks.
Will the size of this table continue to increase indefinitely or is there a logic to remove old data ?
KevinTheJedi
okay, thanks