Marc Posted July 6, 2022 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
Randy Calvert Posted July 6, 2022 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.
Marc Posted July 7, 2022 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
dutchsnowden Posted July 7, 2022 Author Posted July 7, 2022 htop shows server pretty much idle, this is not a server speed issue, plenty of CPU power left.
Marc Posted July 7, 2022 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.
dutchsnowden Posted July 7, 2022 Author 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
Marc Posted July 7, 2022 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.
Recommended Posts