4.6.9 Search not working

[Marc]

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

[dutchsnowden]

12 hours later...

[Randy Calvert]

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]

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]

htop shows server pretty much idle, this is not a server speed issue, plenty of CPU power left.

[Marc]

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]

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]

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.

[dutchsnowden]

I think this might be the end result.