We have 4 stores, catalog products 80000+ when I do indexing of "Rebuild Catalog product full-text search index" it runs for 30 min and then breaks due to lock of tables.
the site is also very slow.
cache is enabled.
How can I do full re-index in a faster method? Any solution/suggestion welcomed