more than 118922 Items

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
punktde
Posts: 15
Joined: Mon Nov 21, 2005 2:52 am

more than 118922 Items

Post by punktde »

Hi,

I'm trying to monitor a BBRAS (Juniper ERX) with more than 118922 Items. It already took some PHP tuning to gather the items, but trying to create an graph is some what impossible! The query (MySQL) takes too long!

Is it somehow possible to write the gathered informations directly into the DB and than parse the HTML "on the fly" so that at least somethings happening?

Do I have any chance to delete unneeded items? -> HOW!?

Regards
Maik
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Um, wow.......

Hummmm, I have to think about this one....

Sorry I don't have an answer right now.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
eshine
Posts: 30
Joined: Fri Feb 25, 2005 11:38 am
Location: Sao Paulo - Brazil

Post by eshine »

Maik,

I work in a broadband access provider and I didn't understand well why you should graph for each connection.

Have you tried walk in a limited leaf set with a xml script?
rgds,
Edgar Shine
punktde
Posts: 15
Joined: Mon Nov 21, 2005 2:52 am

Post by punktde »

eshine wrote:Maik,

I work in a broadband access provider and I didn't understand well why you should graph for each connection.

Have you tried walk in a limited leaf set with a xml script?
Hi,

well...if I knew HOW I would probably do that. Problem is: the interfaces I need are listed at the end...

Do you have any expieriences with ATM (SONET) interfaces?

CU
Maik
nugai
Posts: 49
Joined: Thu Nov 03, 2005 10:48 pm

Post by nugai »

Problem is: the interfaces I need are listed at the end...
Can you post an example of what you're doing and what you're looking for?
Do you have any expieriences with ATM (SONET) interfaces?
I'm new to cacti. I want to use it for monitoring specific ATM PVCs on Alcatel/Xylan equipment.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Cacti 0.8.6h (current SVN version) has a new feature of being able to perform a BULKWALK to obtain interface information. I have worked with a few users with over 10k interfaces and the new test version works as we had expected.

Over a WAN, it still takes a few minutes to build the interface list, and with some of the limitations associated with Java Script in the current product, the fancy yellow highlighting and faded grey interface descriptions are not available (we need to find a workaround for that too), but you can display the interfaces and create graphs.

We have not yet set a date for release. For now you need to update the following two files from SVN (BRANCH_0_8_6)

include/config_settings.php
lib/snmp.php

Then, you need to goto Settings->Paths and add the SNMPBULKWALK path to your saved settings.

One other last note, your device must be either SNMPv2 or SNMPv3 in order to use the BULK command.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
eshine
Posts: 30
Joined: Fri Feb 25, 2005 11:38 am
Location: Sao Paulo - Brazil

Post by eshine »

Is there a way to limit these bulks? For example, limit just for interface above ifIndex = 120000 ou interface between ifIndex 120000 - 125000.

This will be useful to save time avoiding some undesirable walks (for dynamic subscribers for example).
rgds,
Edgar Shine
User avatar
bulek
Cacti Pro User
Posts: 854
Joined: Mon May 20, 2002 2:07 am
Location: Poland
Contact:

Post by bulek »

No... you just ask for a whole table and you get it all in one UDP stream without asking for element by element as it is done in snmpwalk.

- Piotr
sini
Cacti User
Posts: 91
Joined: Mon Nov 24, 2003 10:22 am
Location: Hungary

Post by sini »

Hi,

I also try to monitor Juniper ERX bras with any success...
Snmp walk takes too long and at the end returns with no result...
I tried to add manually a data source because I know the ifAlias | ifDesc values of the interface what I want to monitor for example just the uplink interface. This solution worked on devices I successfully or almost successfully queried with cacti but with some of my juniper bras the snmp data query returned nothing (browser timeout) so manual data source add wasn't possible.
In this devices there are more than 10k ifIndex.

As I search the forum for solution I found this post:
http://forums.cacti.net/viewtopic.php?t=8426

How about this to kind of approach of the problem?
Could it be a solution or I am on a wrong way?
Sini
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests