Versions Compared

Old Version 5

changes.mady.by.user Unknown User (xiaokang)

Saved on

compared with

New Version 6

changes.mady.by.user Unknown User (morningman)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
CREATE INDEX idx_request ON httplogs(request) USING INVERTED PROPERTIES("parser"="english");

CREATE INDEX idx_ngrambf ON tblname(username) USING NGRAM_BF PROPERTIES("size"="3", "other" = "256")  COMMENT "xxx";

CREATE INDEX idx ON tblname(username) USING BITMAP;

CREATE INDEX idx ON tblname(username) USING BLOOM_FILTER PROPERTIES("xxx"="asdasd");

// INDEX idx_ngrambf (`username`) USING NGRAM_BF(3,256) COMMENT 'username ngram_bf index'


  • fulltext search query
Code Block
languagesql
-- search for request contains word 'login'
SELECT * FROM httplogs WHERE request MATCH 'login';

-- search for request contains word 'login' or 'error'
SELECT * FROM httplogs WHERE request MATCH 'login error';

-- search for request contains word 'login' and 'error'
SELECT * FROM httplogs WHERE request MATCH_ALL 'login';

...