I have more than 100000+ products and 20 store views, one of the category has 60000+ products, when I reindex catalogsearch_fulltext, It took more than 20 hours, and still doesn’t finish.
and the category with 60000+ products also couldn’t access got 500 error.
I googled many articles to try to figure out solution, but all doesn’t work for me.
my server is 16v CPU, 128G RAM, Mariadb 10.4, Nginx + PHP8.1
skip-name-resolve=1
table_open_cache = 2000
table_definition_cache = -1
performance_schema=ON
join_buffer_size = 8M
innodb_buffer_pool_size = 30G
innodb_log_file_size = 16M
tmp_table_size = 25G
max_heap_table_size = 25G
innodb_log_file_size = 3G
innodb_io_capacity=600
read_rnd_buffer_size=128K
innodb_buffer_pool_instances=16
innodb_lru_scan_depth=100
log_slow_verbosity=query_plan,explain
slow_query_log=ON
I also changed memory_limint to 8G.