The search index is currently processing.

[dutchsnowden]

Ok. so in ACP I do have 3 options.

1. go with the logged in users
2. crontab every minute
3. use a webservice

However in the dashboard, where "background" processes are, there is one more method as far as I see. The most important one for "immediately" after conversion. The "manual run now". However, this runs from a browser and now it's third day it is running and nowhere to be finished.

I'd like very much to finish this manual run asap, then add to crontab and make sure everything is ok with database. Is there a way that I can run a script overnight that does this MUCH quicker than few records at a time through browser?

I mean the browser picks up few at a time so it does not timeout I assume, but this would be much quicker done directly on the server somehow. Or maybe I do not understand something correctly or am I missing something?

 

 

[Randy Calvert]

I don't believe so.  However if this is a VM, is it possible to allocate it more resources?  The task processor limits what it can do based on available resources.  So upping the resources should help it get more done faster.  Once done, drop it back to the normal reservation.  

[dutchsnowden]

No, this is a dedicated server, not VM, and the CPU and SSDs are almost idle. And memory less than 1/4 used.

 

It is so painful to see how slow it goes.

Edited January 8, 2022 by dutchsnowden

[dutchsnowden]

@Randy Calvert this does not look like lack of resources on the server to be honest.

[dutchsnowden]

Moreover I am very keen to see everything done manually ASAP then run more backups, delete other tables, etc. Then and only then set up cron tables for tasks and see how it all goes. 

At nights, I got at least 6 hours with minimal traffic so that could be a great time doing it manually somehow.

[Marc]

This is a large process, and will take quite some time. Note that on your server, the amount of memory you have is not equal to the amount of memory your configuration is allowing it to use. You can increase items such as memory limit, timeouts on mysql and more in order to change performance

[dutchsnowden]

I increased all my limits in PHP, and optimized MySQL for best configuration. I got 32 Gb available only for IPB.

 

[Marc]

2 hours ago, dutchsnowden said:

I increased all my limits in PHP, and optimized MySQL for best configuration. I got 32 Gb available only for IPB.

 

No problem. Good luck with the completion of that

[dutchsnowden]

My snail now has the finish line in sight! Yeeey! 🤪

[Randy Calvert]

[Marc]

32 minutes ago, Randy Calvert said:

I saw putting roller skates on a tortoise, and I swear I nearly marked that as a solution. 😄 

[dutchsnowden]

Drum rolls....

[Randy Calvert]