I have a program that needs to insert and update a table very frequently (200+ insert or update queries per minute), and this table should also support fulltext search.
I am currently using MySQL MyISAM, but it will lock the table when some data is inserted. So the fulltext queries go in a queue, slowing them down and eating a lot of memory.
What can I do to get both fulltext indexing and no table locks on inserts or updates?
id | title | content | url | date | image | source | imagesource