[Java-Melody] View old statistics.

[Abi Alias]

Hi,

We have configured java melody as a monitoring program for our server,
but seems like the old statistics get cleared automatically.

Kindly let me know how to get the statistics on each day.

Say If we wanted to get statistics on a particular day say Monday,
Tuesday , Wednesday what was the over all statistics or or even a
particular date say on 01-May-2012 what happend, where can I see this
information?

I get a feeling that old data is getting overridden.

We are using a central server for Java Melody and added 2-3 other
server. All our servers are running under Joss 7.0.2.Final/

Then in the central server we have added the storage directoy as a JVM
argument.

ie, JAVA_OPTS="$JAVA_OPTS -Djavamelody.resolution-seconds=120 -
Djavamelody.storage-directory=/var/log/javamelody"

please help us to figure out the same.

[Vernat Emeric]

Hi,

The old statistics are deleted after a year.

You can get the statistics for the current day (since midnight), the
week, the month or the year by choosing the period at the top of the
reports.
At the top-right of the reports, you can also choose to display the
statistics between two dates with a "custom" period. For example, you
can display the statistics (and the graphics) from 30-Apr-2012 to
01-May-2012 (included).

Your javamelody parameters are correct (resolution of 2 minutes and a
storage directory of your choice).
If you have changed the storage directory after some time, the data in
the old storage location is "lost", except of course if you have moved
the files to the new location before restarting the server.

Do you find your data when using the "custom" period?

bye,
Emeric


Le 02/05/2012 12:27, Abi Alias a �crit :

[Vernat Emeric]

Hi,

After looking at your issue here:
http://code.google.com/p/javamelody/issues/detail?id=213,
I see now that you are speaking about the graphics after choosing the
"All" period.

In fact, values in graphics are displayed after some time.
When just starting, values are in displayed in the graphics for the
"current day" period, but not in the week, month, year and all period.
After some hours, there are enough aggregated values and they appear in
the graphics for the week period, but not yet in the month, year and all
period.
And after some days, the values appear in the graphics for the month
period, then for the year period, and at last for the all period.
(They are graphics from Round Robin Databases.)

So keep your server running, and you will see values in the graphics
period after period.

Emeric


Le 02/05/2012 23:20, Vernat Emeric a �crit :

[Niraj Salot]

Hi Emeric,

Any specific reason that with the above mentioned configuration in
place , we are not able to see the Statistics sql .

On the agent side , we do have below mentioned thing in web.xml

<init-param>
<param-name>rewrap-datasources</param-name>
<param-value>true</param-value>
</init-param>

Thanks,

[Vernat Emeric]

Hi,

@Niraj,
I am a bit lost by the change in subject, because we were only speaking
of "old statistics" at the moment.
Do you speak of the same application as Abi Alias? Can you give more
information about your configuration?

@Abi
I have found your data files, lost in some unrelated issue:
http://javamelody.googlecode.com/issues/attachment?aid=2020004000&name=Phoenix_staging.tgz&token=DTlEsyrgc8d-4L_IvdCTOCbNYbo%3A1336132110474

But when I open this tgz file, 7zip says that some files are from user
"root" and some others are from "jboss", as it can be seen in the
attached 7zip screenshot.
That's quite strange. Don't you want to execute something like "chown
jboss:jboss ." in this storage directory?
It may be needed to read and write those files.

bye,
Emeric


Le 04/05/2012 12:40, Niraj Salot a �crit :

[Abi Alias]

Hi Emeric,

I have changed all the permissions to jboss: jboss now.

Shall we exactly know the SQL log moves to central server happens?
Sometimes I can see SQL logs, Sometimes, I cann't.

[evernat]

Hi,

When you use an optional collect server, the sql statistics move to
the collect server at the same time that the http statistics (every 60
seconds by default, or 120 seconds if you use resolution-seconds=120).

It was written in a previous mail of this thread about "rewrap-
datasources".
Note that "rewrap-datasources" is undocumented and probably useless
when you use jboss.
I suggest to read about documented parameters in the user guide,
before trying undocumented parameters:
http://code.google.com/p/javamelody/wiki/UserGuide#7._JDBC

It may also be simpler to not use the optional collect server at the
moment: we may understand better your problems one at a time.


From you email, can you explain precisely what means: "Sometimes I can
see SQL logs, Sometimes, I can't" ?

Thanks,
Emeric

[Abi]

Hi Emeric,

> From you email, can you explain precisely what means: "Sometimes I can
> see SQL logs, Sometimes, I can't" ?

Seems I figured out. Whenever I re-deploy my application, I need to re-
start the JBoss-server. Then every statistics are displaying
properly.