Where define rt_mem_limit with RT mode?

I’m looking into switching from Sphinx to Manticore. I am using RT indexes on Windows (later Centos).

If I define the RT indexes using the CREATE method instead of in the manticore.conf file, where do I specify attributes like charset_table and rt_mem_limit for each index? Normally, I’d put those in the .conf file along with the index definition.

After definition of structure, you can add the index settings separated by space.

CREATE TABLE name (field text, attr1 int, attr2 float) rt_mem_limit=‘2G’ charset_table=‘0…9, english, _’

see https://docs.manticoresearch.com/latest/html/sphinxql_reference/create_table_syntax.html

1 Like

Thanks! Can I change these attributes on the fly, for example, if I want to add more RAM later? I don’t see a MODIFY option, so I’m guessing not…

There’s ALTER and alter table t rt_mem_limit='1G' even doesn’t return any error, but it is not supported internally yet.

I’ve created an issue on Github about it https://github.com/manticoresoftware/manticoresearch/issues/344 . Subscribe to it to be informed about the status.