Re: [OT] visualvm time stamps
> On Apr 12, 2021, at 5:00 PM, Christopher Schultz > wrote: > > Chris, > > On 4/12/21 12:50, Chris Cheshire wrote: On Apr 9, 2021, at 3:02 PM, Chris Cheshire wrote: >>> My googlefu is failing me here. >>> I am trying to figure out some anomalous database connection behavior in my >>> tomcat web app. I have enabled JMX/RMI and have visualvm running on my >>> local machine. >>> I found the ability to monitor the active connections as a live chart, and >>> it has an export data function. This export creates a csv with what is >>> supposed to be a time stamp and a count but the time stamp is in a 5.6 >>> format. I have never seen this before. How do I convert this into something >>> normal - millis since epoch or even a human readable ISO format? >>> Example >>> 44295.607552 >>> Chris >> When all else fails ... RTFS >> So it’s the number of days since 1900. Why? Because Excel (and Lotus 1-2-3) > > Well... they chose to use days-since-epoch and chose a different epoch than > you did. Since it's all arbitrary and relative, why is yours better than > theirs? Because it doesn’t include a kludgy bug fix for a broken assumption about leap years and 1900 ;) In any case, yes it’s just a different epoch. In 20+ years of writing software I have never come across it and was completely baffled at how to make sense of it and my googlefu failed me. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] visualvm time stamps
Chris, On 4/12/21 12:50, Chris Cheshire wrote: On Apr 9, 2021, at 3:02 PM, Chris Cheshire wrote: My googlefu is failing me here. I am trying to figure out some anomalous database connection behavior in my tomcat web app. I have enabled JMX/RMI and have visualvm running on my local machine. I found the ability to monitor the active connections as a live chart, and it has an export data function. This export creates a csv with what is supposed to be a time stamp and a count but the time stamp is in a 5.6 format. I have never seen this before. How do I convert this into something normal - millis since epoch or even a human readable ISO format? Example 44295.607552 Chris When all else fails ... RTFS So it’s the number of days since 1900. Why? Because Excel (and Lotus 1-2-3) Well... they chose to use days-since-epoch and chose a different epoch than you did. Since it's all arbitrary and relative, why is yours better than theirs? The only thing truly Lotus/Excel-y about this is that they both implement 1900 as a leap-year (which it isn't). -chris - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] visualvm time stamps
> On Apr 9, 2021, at 3:02 PM, Chris Cheshire wrote: > > My googlefu is failing me here. > > I am trying to figure out some anomalous database connection behavior in my > tomcat web app. I have enabled JMX/RMI and have visualvm running on my local > machine. > > I found the ability to monitor the active connections as a live chart, and it > has an export data function. This export creates a csv with what is supposed > to be a time stamp and a count but the time stamp is in a 5.6 format. I have > never seen this before. How do I convert this into something normal - millis > since epoch or even a human readable ISO format? > > Example > 44295.607552 > > Chris > When all else fails ... RTFS So it’s the number of days since 1900. Why? Because Excel (and Lotus 1-2-3) /facepalm https://github.com/oracle/visualvm/blob/cbfb4426b25637fb5466705f76271cfcb5209090/plugins/mbeans/src/org/graalvm/visualvm/modules/mbeans/Formatter.java#L125
Re: [OT] visualvm time stamps
> On Apr 11, 2021, at 12:24 PM, Suvendu Sekhar Mondal wrote: > > Hi Chris, > >> On Sat, Apr 10, 2021 at 12:33 AM Chris Cheshire wrote: >> >> My googlefu is failing me here. >> >> I am trying to figure out some anomalous database connection behavior in my >> tomcat web app. I have enabled JMX/RMI and have visualvm running on my local >> machine. >> >> I found the ability to monitor the active connections as a live chart, and >> it has an export data function. This export creates a csv with what is >> supposed to be a time stamp and a count but the time stamp is in a 5.6 >> format. I have never seen this before. How do I convert this into something >> normal - millis since epoch or even a human readable ISO format? >> >> Example >> 44295.607552 >> > > As far as I know, out of the box visualvm(I have 2.0.2) do not have > any option to export CPU/GC/Heap details. Are you using any plugins to > export data? > Sorry - using the mbeans plugin. For this example, I am looking at the “active” attribute of a data source. Double click on the value to bring up a real time chart. Right click on the chart and select “save data as ...” to export as a CSV. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] visualvm time stamps
Am 9. April 2021 21:02:56 MESZ schrieb Chris Cheshire : >My googlefu is failing me here. > >I am trying to figure out some anomalous database connection behavior >in my tomcat web app. I have enabled JMX/RMI and have visualvm running >on my local machine. > >I found the ability to monitor the active connections as a live chart, >and it has an export data function. This export creates a csv with what >is supposed to be a time stamp and a count but the time stamp is in a >5.6 format. I have never seen this before. How do I convert this into >something normal - millis since epoch or even a human readable ISO >format? > >Example >44295.607552 Could it be seconds since start of the jvm? That would mean around 12 h? Felix > >Chris > > >- >To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] visualvm time stamps
Hi Chris, On Sat, Apr 10, 2021 at 12:33 AM Chris Cheshire wrote: > > My googlefu is failing me here. > > I am trying to figure out some anomalous database connection behavior in my > tomcat web app. I have enabled JMX/RMI and have visualvm running on my local > machine. > > I found the ability to monitor the active connections as a live chart, and it > has an export data function. This export creates a csv with what is supposed > to be a time stamp and a count but the time stamp is in a 5.6 format. I have > never seen this before. How do I convert this into something normal - millis > since epoch or even a human readable ISO format? > > Example > 44295.607552 > As far as I know, out of the box visualvm(I have 2.0.2) do not have any option to export CPU/GC/Heap details. Are you using any plugins to export data? > Chris > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
[OT] visualvm time stamps
My googlefu is failing me here. I am trying to figure out some anomalous database connection behavior in my tomcat web app. I have enabled JMX/RMI and have visualvm running on my local machine. I found the ability to monitor the active connections as a live chart, and it has an export data function. This export creates a csv with what is supposed to be a time stamp and a count but the time stamp is in a 5.6 format. I have never seen this before. How do I convert this into something normal - millis since epoch or even a human readable ISO format? Example 44295.607552 Chris - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org