Marc Posted July 6, 2022 Share Posted July 6, 2022 No, thats not the case. The queue task works on the background tasks list. That is, the list that shows in the dashboard of your admin CP Link to comment Share on other sites More sharing options...
dutchsnowden Posted July 6, 2022 Author Share Posted July 6, 2022 12 hours later... Link to comment Share on other sites More sharing options...
Randy Calvert Posted July 6, 2022 Share Posted July 6, 2022 I have a site with just about 2.5M posts and the reindex took about 2.5 hours. The time to reindex depends on a bunch of factors. Try just running the task list manually in the ACP and seeing how that goes after a few hours. Link to comment Share on other sites More sharing options...
Marc Posted July 7, 2022 Share Posted July 7, 2022 This will unfortunately be the speed at which your server is able to run them in its current configuration. As mentioned above, they dont generally take as long as they are on your server. They will take quite some time to run through, yes, but they shouldnt be taking that long Link to comment Share on other sites More sharing options...
dutchsnowden Posted July 7, 2022 Author Share Posted July 7, 2022 htop shows server pretty much idle, this is not a server speed issue, plenty of CPU power left. Link to comment Share on other sites More sharing options...
Marc Posted July 7, 2022 Share Posted July 7, 2022 I think you may be confusing server capability with sql setup there. While your server may indeed be capable, the fact its using very little in terms of your resources, would actually indicate your configuration on MySQL is not optimally set up. Link to comment Share on other sites More sharing options...
dutchsnowden Posted July 7, 2022 Author Share Posted July 7, 2022 I spent like one week trying to optimize MySQL when upgraded, because everything was awfully slow. I thought I managed to do a good job, because in the end everything reduced from days to tens of minutes. Now are you saying I am back to square one? Quote max_binlog_size = 1M disable_log_bin innodb_buffer_pool_size = 4G innodb_log_file_size = 1G innodb_log_buffer_size = 12M innodb_file_per_table = ON innodb_write_io_threads = 16 sql_mode = "" expire_logs_days = 10 innodb_io_capacity = 200 innodb_read_io_threads = 4 innodb_thread_concurrency = 4 innodb_write_io_threads = 4 key_buffer_size = 6G Link to comment Share on other sites More sharing options...
Marc Posted July 7, 2022 Share Posted July 7, 2022 Its very rare that these reindexing tasks take extreme amounts of time to go through. When it does, it tends to be the environment in which it is being run on, as that is the only differentiator there. Link to comment Share on other sites More sharing options...
dutchsnowden Posted July 7, 2022 Author Share Posted July 7, 2022 I think this might be the end result. Link to comment Share on other sites More sharing options...
Recommended Posts