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
table_open_cache = 2000
table_definition_cache = -1
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
I've tried optimize mariadb, do you have any other suggestions?