Changing an analyser means reindexing, and reindexing in place means a search index that is half old and half new for twenty minutes. The application must only ever…
InnoDB full-text ignores words shorter than three characters and words appearing in more than half the rows, and both are configurable only at the server level. Changing innodb_ft_min_token_size…
October’s point release can add a hidden primary key to a table created without one, which matters for replication and for group replication in particular. A table without…
Forcing an index makes one query faster today and freezes a decision that the optimiser would otherwise revisit as the data changes. A hint is appropriate as a…
An expression in a WHERE clause cannot use an index, and a generated column moves the expression somewhere indexable. The automatic substitution is the good part and requires…
A deleted_at column means every query filters on it forever, and the rows stay in the index, in the buffer pool and in the backup. PostgreSQL’s partial index…
The default parser splits on whitespace, which produces one enormous token for a language that does not have any. The size of the resulting index is the cost…