dutchsnowden Posted January 8, 2022 Share Posted January 8, 2022 Ok. so in ACP I do have 3 options. go with the logged in users crontab every minute 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? Link to comment Share on other sites More sharing options...
Randy Calvert Posted January 8, 2022 Share Posted January 8, 2022 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. SeNioR- 1 Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 8, 2022 Author Share Posted January 8, 2022 (edited) 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 Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 8, 2022 Author Share Posted January 8, 2022 @Randy Calvert this does not look like lack of resources on the server to be honest. Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 8, 2022 Author Share Posted January 8, 2022 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. Link to comment Share on other sites More sharing options...
Marc Posted January 10, 2022 Share Posted January 10, 2022 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 Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 10, 2022 Author Share Posted January 10, 2022 I increased all my limits in PHP, and optimized MySQL for best configuration. I got 32 Gb available only for IPB. Link to comment Share on other sites More sharing options...
Marc Posted January 10, 2022 Share Posted January 10, 2022 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 Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 10, 2022 Author Share Posted January 10, 2022 My snail now has the finish line in sight! Yeeey! 🤪 Link to comment Share on other sites More sharing options...
Randy Calvert Posted January 10, 2022 Share Posted January 10, 2022 dutchsnowden, Jim M, Daniel F and 2 others 5 Link to comment Share on other sites More sharing options...
Marc Posted January 10, 2022 Share Posted January 10, 2022 32 minutes ago, Randy Calvert said: I saw putting roller skates on a tortoise, and I swear I nearly marked that as a solution. 😄 Randy Calvert 1 Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 10, 2022 Author Share Posted January 10, 2022 Drum rolls.... Marc 1 Link to comment Share on other sites More sharing options...
Randy Calvert Posted January 10, 2022 Share Posted January 10, 2022 Link to comment Share on other sites More sharing options...
Recommended Posts