It still doesn't seem to be working. To be clear, I can download PDFs for small reports but once they get a bit bigger it just bogs down the whole server and never finishes.
For instance, I can run a report with 16 different graphs and download to PDF. This finishes almost instantly. However, if I run a larger capacity report (for example with 100 graphs) downloading the PDF just results in the usual slow or no responsiveness in other browser windows and the http to pdf process eats up CPU forever. Given that it can create a 16 page PDF in seconds I imagine it shouldn't take hours for one with 100...
Thanks,
Scott
PDF Report Creation extremely slow
-
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: PDF Report Creation extremely slow
Hi Scott,
The capacity planning report is very CPU intensive since it has to parse all the performance data and then run the extrapolations on top of that. Since the legacy reports are working faster, and the GUI report is slow, the main levers we have to improve this are optimizing the PHP variables. If you running a VM, you could add more CPU resources to try to speed this up and possibly bump up the memory limit again in PHP.
The other settings on the sever look correct, but we could certainly move this case over to a ticket and take a look at your system on a remote if you'd like to troubleshoot this further.
Benjamin
The capacity planning report is very CPU intensive since it has to parse all the performance data and then run the extrapolations on top of that. Since the legacy reports are working faster, and the GUI report is slow, the main levers we have to improve this are optimizing the PHP variables. If you running a VM, you could add more CPU resources to try to speed this up and possibly bump up the memory limit again in PHP.
The other settings on the sever look correct, but we could certainly move this case over to a ticket and take a look at your system on a remote if you'd like to troubleshoot this further.
Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
- Posts: 17
- Joined: Wed Sep 19, 2018 6:20 pm
Re: PDF Report Creation extremely slow
I want to clarify - I'm not sure if we're misunderstanding each other. The GUI reports are fine on screen - I can do any of them quickly. It's specifically when making a PDF download where it bogs down.
I can try to increase resources again and see what happens - I'm on vacation this week so will double the CPU resources and also bump up Ram and the PHP variables next week and report back.
Thanks,
Scott
I can try to increase resources again and see what happens - I'm on vacation this week so will double the CPU resources and also bump up Ram and the PHP variables next week and report back.
Thanks,
Scott
-
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: PDF Report Creation extremely slow
Hi Scott,
Thanks, clarification. Have a good break and let us know if the resource increases reduce the time required.
The PDF report is generated using the wkhtmltopdf package. I would watch the load on that process while the report is generating.
Make sure the settings in the Admin -> System Settings under "Program URL:" and "External URL:" are correct as well. If it is set, make sure the hostname in the field is correct and that the name is resolvable in DNS.
Benjamin
Thanks, clarification. Have a good break and let us know if the resource increases reduce the time required.
The PDF report is generated using the wkhtmltopdf package. I would watch the load on that process while the report is generating.
Make sure the settings in the Admin -> System Settings under "Program URL:" and "External URL:" are correct as well. If it is set, make sure the hostname in the field is correct and that the name is resolvable in DNS.
Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
- Posts: 17
- Joined: Wed Sep 19, 2018 6:20 pm
Re: PDF Report Creation extremely slow
I migrated this VM from an older host to a newer clustered host, with newer, more powerful CPUs. I also bumped the VM from 6 to 12 cores and from 8GB Ram to 24GB. I set php.ini to give Apache 18GB of Ram to use.
Nothing has changed - I can run smaller reports - i.e. PDF with 10 pages, almost instantly. Once it starts to get a bit bigger(50 pages, for example, it goes to 100% right away (wkhtml) and just gets stuck forever. The system should have all the resources it needs but it seems like there's a setting or bug or something similar that just stops these PDF reports from working if they're not small.
Nothing has changed - I can run smaller reports - i.e. PDF with 10 pages, almost instantly. Once it starts to get a bit bigger(50 pages, for example, it goes to 100% right away (wkhtml) and just gets stuck forever. The system should have all the resources it needs but it seems like there's a setting or bug or something similar that just stops these PDF reports from working if they're not small.
-
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: PDF Report Creation extremely slow
Hi Scott,
Thanks for your patience, the server resources look good.
I'd like to move this thread over to support the ticket so we can get a remote session going on this to take a live look at the system to help troubleshoot this. Please reference this thread when opening the ticket.
https://support.nagios.com/tickets/
Also, It's worth trying crank up the max_execution_time setting beyond what we have so far, for example:
And restart Apache.
Thanks for your patience, the server resources look good.
I'd like to move this thread over to support the ticket so we can get a remote session going on this to take a live look at the system to help troubleshoot this. Please reference this thread when opening the ticket.
https://support.nagios.com/tickets/
Also, It's worth trying crank up the max_execution_time setting beyond what we have so far, for example:
Code: Select all
max_execution_time = 1800
Code: Select all
systemctl restart httpd
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
- Posts: 17
- Joined: Wed Sep 19, 2018 6:20 pm
Re: PDF Report Creation extremely slow
Thanks for your help - I tried a bunch more and it seems I can create and download a 25 page PDF almost instantly but if it gets up to 35, 40, 50 pages or above it just won't do it.
I'll submit that ticket.
Scott
I'll submit that ticket.
Scott
-
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: PDF Report Creation extremely slow
Sounds good. Thanks Scott.I'll submit that ticket.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!