All geek questions in one place

Full-text search with InnoDB tables

I need to use full-text search, but the tables that I use in my web application use the INNODB mechanism, from what I read, JDBC does not support Mysql triggers, and I have to deploy the project to the course server so installing tools like sphinxs , impossible, can anyone suggest a method for full-text search?

thank

Edit: the requirement in the project is to have a consistent database, the table in which I want to search contains a list of tools that exist in the laboratory for which I create a web application, you can insert new tools for it, but let it is assumed that there are few accesses to the inserts, and that the table will mainly be used for read access, in which case it justifies MyIsam and will comply with the requirements of consistency (Myisam does not support transactions)

+3
source share
1 answer

MyISAM, , FULLTEXT. , , JOIN InnoDB MyISAM MATCH MyISAM.

MyISAM " InnoDB", , "" /, MySQL FULLTEXT .

, , MyISAM InnoDB. , , , . , , , " ".

, LIKE/RLIKE (regexp), . , , , , , .

Edit:

, , , , -.

, FULLTEXT ? , , ( )?

2 ?

MyISAM INSERT . , " ". , , ", , , , ".

+3

Source: https://habr.com/ru/post/1766085/

More articles:


All Articles