[Tomer Ratz]

'Mahesh' wrote:

Ok .. let me explain.

1) For “ALL Time” we are calculating based on current value of each status variable by executing

show global status;

2) For Delta we are considering difference between the values of the variables from last two data collections,

For example, consider this:

At 12:00:00 MONyog has collected data as:

Variable_name Value

---

---

Handler_commit 2552241

Handler_delete 1781614

Handler_discover 0

Handler_prepare 8

Handler_read_first 37670

Handler_read_key 556973055

Handler_read_next 285178627

Handler_read_prev 0

Handler_read_rnd 162380478

Handler_read_rnd_next 789906322

Handler_rollback 25

Handler_savepoint 0

Handler_savepoint_rollback 0

Handler_update 246574243

Handler_write 199241798

and at 12:00:05 MOnyog has collected data as:

Variable_name Value

---

---

Handler_commit 2552241

Handler_delete 1781614

Handler_discover 0

Handler_prepare 8

Handler_read_first 37670

Handler_read_key 556973055

Handler_read_next 385195627

Handler_read_prev 0

Handler_read_rnd 162380478

Handler_read_rnd_next 789906322

Handler_rollback 25

Handler_savepoint 0

Handler_savepoint_rollback 0

Handler_update 246574243

Handler_write 199241798

DELTA will show “Percentage of refused connection” value based on difference of each and every variable as

– (this applies to all status variables)

Thank you for your response.

I got it already, though I would really like to know how you calculate a delta for Percentage Of Full Table Scans, as it's a rather complicated formula, not just a reduction.

[Tomer Ratz]

Can you please help me with the way you calculate the graph using deltas?

Do you poll every minute and divide by time, or something like this?

[Tomer Ratz]

version 4.51

I'm uploading 2 screenshots.

[Tomer Ratz]

So maybe I've hit a bug in Monyog, because the result I get is corrrect from the formula, but the graph show a whole different result.

The result is around 20-40% but the graph shows 80%.

[Tomer Ratz]

Another good idea that will serve me even better is to automatically output the result into an HTML file.

Then our NOC team will be able to access a webpage to see the system status.

[Tomer Ratz]

A mailed HTML-formatted file is the most useful file format I can think of, all other are hard to edit/read.

My goal is to get a daily report without having to produce it myself.

[Tomer Ratz]

'Mahesh' wrote:

No.. currently there is no way to produce report from QA in an Automated way.

You have to go to QA tab — Analyze and then export report manually.

May I post a feature-request on the Feature forum?

[Tomer Ratz]

Thanks!

I'm using IPSwitch's What's Up Gold.

I've loaded the MIB file which comes with MONyog directly into the software.

'Sayan wrote on '16:

That would entirely depend on the SNMP client software that you are using. For example, here's a screenshot of how traps appear in the lightweight receiver from iReasoning:

[attachment=1295:screenshot.GIF]

I suspect that there should be a way to load MIB files from your SNMP client. That way, you wouldn't even have to add the OIDs manually, and much of the gibberish numbers are actually converted into much more meaningful strings.

For instance, on iReasoning's MIB Browser, enterprises.34330.1.1.1.0 appears as enterprises.webyog.monyog.monitor.ServerName.0

Which SNMP client are you using, anyhow? Maybe I can play around with it a bit, and then I can give some pointers.

[Tomer Ratz]

The SNMP Trap looks like this:

monitorTrap

enterprises.34330.1-1

TrapName=enterprises.34330.1-1 TrapMajor=6 TrapMinor=1 enterprises.34330.1.1.1.0=Pooh Cluster enterprises.34330.1.1.2.0=All Time/Current CommunityName=public enterprises.34330.1.1.3.0=Critical enterprises.34330.1.1.4.0=Current Connections 1.3.6.1.4.1.34330.1.1.1.0=Pooh Cluster enterprises.34330.1.1.5.0=Percentage of max allowed reached 1.3.6.1.4.1.34330.1.1.2.0=All Time/Current Packet Type=Trap enterprises.34330.1.1.6.0=52.57% 1.3.6.1.4.1.34330.1.1.3.0=Critical enterprises.34330.1.1.7.0=50 1.3.6.1.4.1.34330.1.1.4.0=Current Connections Protocol Version=SNMPv1 enterprises.34330.1.1.8.0=1. Make sure that you have a reasonable high value for max_connections.
2. Design your application such that a MySQL connection is kept open for a very short period of time.
3. Try pooling connections or switch to persistent connections to reduce the number of active MySQL connections. For example try using mysql_pconnect() instead of mysql_connect() 1.3.6.1.4.1.34330.1.1.5.0=Percentage of

max all

owed reached enterprises.34330.1.1.9.0=Created by MONyog 3.5 running on VincentVega (192.168.21.4).

(c) 2009, Webyog Softworks Pvt Ltd. 1.3.6.1.4.1.34330.1.1.6.0=52.57% 1.3.6.1.4.1.34330.1.1.7.0=50 Timetick=200days 19:13:42.54 1.3.6.1.4.1.34330.1.1.8.0=1. Make sure that you have a reasonable high value for max_connections.
2. Design your application such that a MySQL connection is kept open for a very short period of time.
3. Try pooling connections or switch to persistent connections to reduce the number of active MySQL connections. For example try using mysql_pconnect() instead of mysql_connect() 1.3.6.1.4.1.34330.1.1.9.0=Created by MONyog 3.5 running on VincentVega (192.168.21.4).

(c) 2009, Webyog Softworks Pvt Ltd. Object=1.3.6.1.4.1.34330.1 (enterprises.34330.1)

IP Address: 192.168.21.50

Is there anyway to “strip” all the unnecessary information from it (e.g. enterprises.34330.1.1.1.0=Pooh Cluster enterprises.34330.1.1.2.0=All Time/Current CommunityName=public)?

As you can see the trap is very scrambled at the moment.

[Tomer Ratz]

Rohit wrote on Sep 19 2008, 03:38 AM:

@Tomer,

We have got a few requests for SNMP traps in the past. We will try to push it for MONyog 3.0.

The first beta for MONyog 3.0 is expected in another 6-8 weeks.

Hi

Version 3 Beta 1 is out, and what about the SNMP option?

[Tomer Ratz]

Thank you for this sale, I just purchased the Monitor and the SQLYOG.

But here rises the question, if I currently use the community version of SQLYOG and I want to install the Enterprise version, How do I backup my servers-list in case it'll be deleted when I uninstall the community version?

[Tomer Ratz]

Rohit wrote on Sep 19 2008, 03:38 AM:

@Tomer,

We have got a few requests for SNMP traps in the past. We will try to push it for MONyog 3.0.

The first beta for MONyog 3.0 is expected in another 6-8 weeks.

Great, I'll be waiting…

[Tomer Ratz]

peterlaursen wrote on Sep 18 2008, 12:18 PM:

No!

Could you explain why you want this? I do not understand how to use it in MONyog context. MONyog uses no active code (“no agents”) on the servers running MySQL – except for the MySQL server and the OS themselves of course.

I use a SNMP-Based monitoring system (IPSwitch What's Up Gold), and SNMP or SNMP Traps are useful to send alerts.

I'm not available 24-7 near a computer to see E-mails, and my NOC team is watching the monitoring system.

To use SNMP you don't need any agents, you just need to communicate with the “SNMP service” which is built-in in Windows on the machine where MONyog is installed and use it to send SNMP Traps, or alerts.

[Author]

Posts