[SOLVED] Slow picture / graph downloading

[Dan33_il]

Hi there,
Installed cacti-0.8.6j.1.6.exe
Server is 2003 sp2 3GHz w/ 2GB RAM

I can't neccessarilly upgrade at this point.

Issue, has occurred twice. I can work within Cacti for some time, and then, I get incredibly slow response when I try to view graphs. I can access pages with no problems, but then it will hang on
Downloading picture http://...

This is not specific to a particular graph...they all get affected once it occurs. The server's task manager does not indicate any particular stress...

The last time this occurred, prior to the Holidays, I had to leave, and when I came back today, everything was working properly, until about 30 minutes ago. I do know the server was not rebooted since the previous issue.

Any thoughts? Thanks, Dan

[jay]

How big is your installation??

Post the output of the poller via the web browser - goto - system utilities - view cacti log file

You are looking for something like this

01/02/2008 05:15:55 PM - SYSTEM STATS: Time:55.4739 Method:cactid Processes:2 Threads:10 Hosts:344 HostsPerProcess:172 DataSources:4857 RRDsProcessed:2710

Post the output as shown above.

I noticed from previous posts that you are using the beta installed so you should have the correct versions of php/mysql etc.

Also this post is a good source of seeing what stats other users are getting and what hardware they are using.

http://forums.cacti.net/viewtopic.php?t=6206

Jay

[BSOD2600]

1) Is this a new installation? If so, why didn't you go with the latest installer which is based off of Cacti 0.8.7a?

2) during these slow graphing periods, look as the task manager -- is anything consuming a lot of the cpu?

3) next time the slow issues happen, try restarting all of the IIS services. Fix the problem? If so, then it's probably a php issue.

4) Hosting other websites on this server?

[Dan33_il]

Gentlemen, thank you for your replies. I have not been on site since I posted last week. I will be moving forward with recommendations today.

The one question I can answer at this point: this is not a new installation - simply one as a work in progress (@ 4 hours a week); that is the reason for the older version.

I am hoping to brush up on a few basic Mysql / Cacti maintenance steps before I look at upgrading.

FYI - as I came in this morning, the graphs are working as designed. Let's see how the day progresses.

Thanks. - D

[Dan33_il]

How big is your installation??

Post the output of the poller via the web browser - goto - system utilities - view cacti log file

You are looking for something like this

01/02/2008 05:15:55 PM - SYSTEM STATS: Time:55.4739 Method:cactid Processes:2 Threads:10 Hosts:344 HostsPerProcess:172 DataSources:4857 RRDsProcessed:2710

Jay - appreciate the tip. When I review the logs I see the following...

---- THESE ARE FROM THE TIME OF THE ISSUE
01/02/2008 11:00:10 AM - SYSTEM STATS: Time:10.2644 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101
01/02/2008 10:55:09 AM - SYSTEM STATS: Time:9.2415 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101
01/02/2008 10:50:09 AM - SYSTEM STATS: Time:9.2343 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101
01/02/2008 10:45:03 AM - SYSTEM STATS: Time:3.2824 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101
01/02/2008 10:40:08 AM - SYSTEM STATS: Time:8.3290 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101
01/02/2008 10:35:08 AM - SYSTEM STATS: Time:8.2511 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101

--- THIS IS FROM TODAY - WITHOUT ANY ISSUES

01/09/2008 07:50:09 AM - SYSTEM STATS: Time:9.2888 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:203 RRDsProcessed:102
01/09/2008 07:45:04 AM - SYSTEM STATS: Time:4.2885 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:203 RRDsProcessed:102
01/09/2008 07:40:09 AM - SYSTEM STATS: Time:9.3170 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:203 RRDsProcessed:102
01/09/2008 07:35:09 AM - SYSTEM STATS: Time:9.3848 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:203 RRDsProcessed:102
01/09/2008 07:30:08 AM - SYSTEM STATS: Time:8.2404 Method:cmd.php Processes:1 Threads:N/A Hosts:77 HostsPerProcess:77 DataSources:202 RRDsProcessed:101

Me again - based on a comparision internally, there does not seem to be much of discrepency.
Compared to your example, I have fewer items, but I am utilizing less processors and threads.

thoughts - recommendations for fine tuning? Thank you again.

[jay]

Hi Dan

The stats look ok to me. You have a small installation at the moment.

In order to increase poller speed I would first look at using Cactid instead of cmd.php. See BSOD installation guide on how to configure Cactid:- http://forums.cacti.net/viewtopic.php?t=11747

Relevant snippets from his guide

Cactid
Recommended Install Path: C:\Cactid\
Information: Cactid is a poller for Cacti that primarily strives to be as fast as possible. For this reason it is written in native C, makes use of POSIX threads, and is linked directly against the net-snmp library for minimal SNMP polling overhead. Cactid is a replacement for the default cmd.php poller so you must decide if using Cactid makes sense for your installation. It is highly recommended that users start out with the default cmd.php poller until their installation is fully functional!

* Extract the cactid zip file to C:\Cactid\

WARNING: Cactid is only compiled with Cygwin and thusly needs a few Cygwin dlls on the system. These are included with the downloaded zip file. This can become a problem if RRDTool is also compiled under a different Cygwin version, since then there will be different Cygwin dll versions on the system which can cause issues. If you're using a Win32 build of RRDTool, then nothing to worry about. There are a few ways to solve the problem:

1. Install a base install of Cygwin and delete all cygwin files from the RRDTool and Cactid folders.
2. Move RRDTool and Cactid into the same folder, so they share the Cygwin dlls. Your mileage may vary due to each binary being compiled against a different Cygwin version.




Cactid

1.

Modify the cactid.conf file in c:\cactid to include the following statements.

DB_Host IP Address or Hostname (not localhost)
DB_Database cacti
DB_User cactiuser
DB_Password cactipw
DB_Port 3306

2.

If you have Cygwin installed, remove the DLL files from the c:\cactid directory.





I can't seem to find the post where it tells you other settings to change. One of them is to increase your memory limit within php.ini (located in c:/php) the default may be set to 8MB unless BSOD has changed this with his installed that you installed.

max_execution_time = 220 ; Maximum execution time of each script, in seconds
max_input_time = 180 ; Maximum amount of time each script may spend parsing request data
memory_limit = 256M ; Maximum amount of memory a script may consume (8MB)


You can also increase speed by increasing memory on your hardware. Looking at the size of your current installation this is not really required at this point.

Hope this helps.

Jay

[Dan33_il]

Jay, let me just say Thanks and Wow!
My experience with open source began with this installation, and there is a definate learning curve, and a certain expectation from the community (certainly not a slight to anyone on the forum, as it is a reflection of me stepping into the deep end more than anything else.).

I count myself lucky...first by BS0D2600's installer (thanks!) and the fact that I have not had some of the other issues I have read about in the forum.

So I do appreciate your extensive tips. I am leaving this client for another week (so far no issues); but I am planning on implemennting Cacti at another client soon, so hopefully I will get my sh*t together.

Thank you again. I will keep you posted. - Dan

[jay]

Your certainly being thrown into the deep end if you are installing Cacti at clients sites. It took me a long time to get Cacti working the first time I set it up, long before the days of BSOD installer. There is still plenty I don't know but I'm learning all the time. The forums are a good place to get information as well as support.

Good luck with the rest of your installs.

Jay