You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Glenn Caccia <ga...@yahoo.com.INVALID> on 2015/04/08 21:25:55 UTC
checking data in influxdb
I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted to try Grafana 2.0 (beta), but its configuration is different than the older version that JMeter has documentation for and I've not gotten it to work yet. I wanted to at least confirm that the InfluxDB part is working correctly and would like to run a query to confirm that data made it in from a test run. What is the data structure for the JMeter DB? That is, if I write a query for "select * from ????, what is ????. I don't know if these are called tables or something else, but basically, what structure is created in the JMeter database? Into what structure are run results saved?
Re: checking data in influxdb
Posted by Glenn Caccia <ga...@yahoo.com.INVALID>.
Interesting. Looks like my issue was using IE for running the InfluxDB console. When I tried running "list series" I was getting an error back. Switched over to Firefox and it didn't even recognize that I had the jmeter database. Recreated it, reran my JMeter test and ran "list series" in InfluxDB via Firefox. Data!!! Thanks.
From: "Wilson, Cheyne" <Ch...@airnz.co.nz>
To: JMeter Users List <us...@jmeter.apache.org>; Glenn Caccia <ga...@yahoo.com>
Sent: Wednesday, April 8, 2015 3:52 PM
Subject: RE: checking data in influxdb
Have you tried the influxdb command 'list series' to verify the data is getting in there?
http://influxdb.com/docs/v0.8/api/query_language.html
That's what I used when getting it set up / troubleshooting last night using influxdb 0.8.8. The output was as follows:
list_series_result
time name
0 jmeter.MySampleName.a.count
0 jmeter. MySampleName.a.max
0 jmeter. MySampleName.a.min
0 jmeter. MySampleName.a.pct90
0 jmeter. MySampleName.a.pct95
0 jmeter. MySampleName.a.pct99
0 jmeter. MySampleName.ko.count
0 jmeter. MySampleName.ok.count
0 jmeter. MySampleName.ok.max
0 jmeter. MySampleName.ok.min
0 jmeter. MySampleName.ok.pct90
0 jmeter. MySampleName.ok.pct95
0 jmeter. MySampleName.ok.pct99
0 jmeter. MySampleName.a.count
0 jmeter. MySampleName.a.max
0 jmeter. MySampleName.a.min
0 jmeter. MySampleName.a.pct90
0 jmeter. MySampleName.a.pct95
....
Regards,
Cheyne
-----Original Message-----
From: Glenn Caccia [mailto:gacaccia@yahoo.com.INVALID]
Sent: Thursday, 9 April 2015 7:26 a.m.
To: JMeter Users List
Subject: checking data in influxdb
I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted to try Grafana 2.0 (beta), but its configuration is different than the older version that JMeter has documentation for and I've not gotten it to work yet. I wanted to at least confirm that the InfluxDB part is working correctly and would like to run a query to confirm that data made it in from a test run. What is the data structure for the JMeter DB? That is, if I write a query for "select * from ????, what is ????. I don't know if these are called tables or something else, but basically, what structure is created in the JMeter database? Into what structure are run results saved?
Good planets are hard to find - please think of the environment before you print this email.
____________________________________________________________________
CAUTION - This message may contain privileged and confidential
information intended only for the use of the addressee named above.
If you are not the intended recipient of this message you are hereby
notified that any use, dissemination, distribution or reproduction
of this message is prohibited. If you have received this message in
error please notify Air New Zealand immediately. Any views expressed
in this message are those of the individual sender and may not
necessarily reflect the views of Air New Zealand.
_____________________________________________________________________
For more information on the Air New Zealand Group, visit us online
at http://www.airnewzealand.com
_____________________________________________________________________
RE: checking data in influxdb
Posted by "Wilson, Cheyne" <Ch...@airnz.co.nz>.
Have you tried the influxdb command 'list series' to verify the data is getting in there?
http://influxdb.com/docs/v0.8/api/query_language.html
That's what I used when getting it set up / troubleshooting last night using influxdb 0.8.8. The output was as follows:
list_series_result
time name
0 jmeter.MySampleName.a.count
0 jmeter. MySampleName.a.max
0 jmeter. MySampleName.a.min
0 jmeter. MySampleName.a.pct90
0 jmeter. MySampleName.a.pct95
0 jmeter. MySampleName.a.pct99
0 jmeter. MySampleName.ko.count
0 jmeter. MySampleName.ok.count
0 jmeter. MySampleName.ok.max
0 jmeter. MySampleName.ok.min
0 jmeter. MySampleName.ok.pct90
0 jmeter. MySampleName.ok.pct95
0 jmeter. MySampleName.ok.pct99
0 jmeter. MySampleName.a.count
0 jmeter. MySampleName.a.max
0 jmeter. MySampleName.a.min
0 jmeter. MySampleName.a.pct90
0 jmeter. MySampleName.a.pct95
....
Regards,
Cheyne
-----Original Message-----
From: Glenn Caccia [mailto:gacaccia@yahoo.com.INVALID]
Sent: Thursday, 9 April 2015 7:26 a.m.
To: JMeter Users List
Subject: checking data in influxdb
I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted to try Grafana 2.0 (beta), but its configuration is different than the older version that JMeter has documentation for and I've not gotten it to work yet. I wanted to at least confirm that the InfluxDB part is working correctly and would like to run a query to confirm that data made it in from a test run. What is the data structure for the JMeter DB? That is, if I write a query for "select * from ????, what is ????. I don't know if these are called tables or something else, but basically, what structure is created in the JMeter database? Into what structure are run results saved?
Good planets are hard to find - please think of the environment before you print this email.
____________________________________________________________________
CAUTION - This message may contain privileged and confidential
information intended only for the use of the addressee named above.
If you are not the intended recipient of this message you are hereby
notified that any use, dissemination, distribution or reproduction
of this message is prohibited. If you have received this message in
error please notify Air New Zealand immediately. Any views expressed
in this message are those of the individual sender and may not
necessarily reflect the views of Air New Zealand.
_____________________________________________________________________
For more information on the Air New Zealand Group, visit us online
at http://www.airnewzealand.com
_____________________________________________________________________
Re: checking data in influxdb
Posted by Glenn Caccia <ga...@yahoo.com.INVALID>.
So one more thing I did was turn on DEBUG for JMeter logging. It sure looks like it is writing data, I just don't see it. Maybe my query is wrong??? Here's some samples from the log file...
2015/04/08 14:58:12 DEBUG - jmeter.visualizers.backend.BackendListener: StandardJMeterEngine@309a1aee-Backend Listener testStarted(local)
2015/04/08 14:58:12 INFO - jmeter.visualizers.backend.BackendListener: Backend Listener:Starting worker with class:class org.apache.jmeter.visualizers.backend.graphite.GraphiteBackendListenerClient and queue capacity:5000
2015/04/08 14:58:12 INFO - jmeter.visualizers.backend.BackendListener: Backend Listener: Started worker with class:class org.apache.jmeter.visualizers.backend.graphite.GraphiteBackendListenerClient
2015/04/08 14:58:12 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 taking SampleResult from queue:0
2015/04/08 14:58:12 INFO - jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender: Created TextGraphiteMetricsSender with host:xxx.xxx.com, port:2003, prefix:jmeter.
...
2015/04/08 14:58:14 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 took SampleResult:HTTP Request - GetPlaycount, isFinal:false
2015/04/08 14:58:14 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 polling from queue:0
2015/04/08 14:58:14 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 took from queue:null, isFinal:false
2015/04/08 14:58:14 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 exiting with FINAL EVENT:false, null:true
2015/04/08 14:58:14 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 taking SampleResult from queue:0
2015/04/08 14:58:15 DEBUG - jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender: Wrote 18 metrics
...
2015/04/08 14:58:18 DEBUG - jmeter.visualizers.backend.BackendListener: testEnded called on instance Backend Listener#1
2015/04/08 14:58:18 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 took SampleResult:, isFinal:true
2015/04/08 14:58:18 DEBUG - jmeter.visualizers.backend.BackendListener: Thread:Thread-13 exiting with FINAL EVENT:true, null:false
2015/04/08 14:58:18 INFO - jmeter.visualizers.backend.BackendListener: Worker ended
2015/04/08 14:58:18 DEBUG - jmeter.visualizers.backend.graphite.GraphiteBackendListenerClient: Canceled state:true
2015/04/08 14:58:18 DEBUG - jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender: Wrote 23 metrics
2015/04/08 14:58:18 DEBUG - jmeter.visualizers.backend.AbstractBackendListenerClient: org.apache.jmeter.visualizers.backend.graphite.GraphiteBackendListenerClient: teardownTest
From: Glenn Caccia <ga...@yahoo.com.INVALID>
To: JMeter Users List <us...@jmeter.apache.org>
Sent: Wednesday, April 8, 2015 2:39 PM
Subject: Re: checking data in influxdb
Thanks for the response. Yes, I can telnet to the graphiteHost on port 2003 from the computer where I'm running JMeter. I used RubyCLI simply because it gave some examples of how to query for metadata. I'm not sure about your last point. Where in JMeter do I specify the user? I don't see that in the documentation on setting up the Backend Listener.
From: chaitanya bhatt <bh...@gmail.com>
To: JMeter Users List <us...@jmeter.apache.org>; Glenn Caccia <ga...@yahoo.com>
Sent: Wednesday, April 8, 2015 1:56 PM
Subject: Re: checking data in influxdb
can you telnet onto to the graphiteHost on port 2003 from the jmeter
master/controller?
try: telnet hostblahblah.com <http://hostblah.com> 2003
For querying, instead of using RubyCLI for influxdb why don't you try using
the web interface? like: influxhostblah.com:8083
Make sure the database user specified in jmeter is the same as the one
created in influxdb.
Thanks
Chaitanya M Bhatt
http://www.performancecompetence.com
On Wed, Apr 8, 2015 at 1:28 PM, Glenn Caccia <ga...@yahoo.com.invalid>
wrote:
>
> So I kind of answered my own question, which then leads to the next. I
> installed the Ruby CLI for Influxdb. I connected into the jmeter database
> and ran the following command...
> db.query('SELECT * FROM /.*/ LIMIT 1').keys
>
> This returns nothing, which I believe means that JMeter isn't writing
> anything to the InfluxDB "jmeter" database. What am I doing wrong? I
> also enabled the JMeter log and when I run the test, I don't see any errors
> (did at first with an error on connection to graphite host when I had the
> config wrong).
> Here's my setup.
> JMeter 2.13InfluxDB 0.8.8
> JMeter Test Script:Added Backend Listener with settings
>
> | graphiteMetricsSender |
> org.apache.jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender |
> | graphiteHost | xxx-xxx-xxx.com |
> | graphitePort | 2003 |
> | rootMetricsPrefix | jmeter. |
> | summaryOnly | true |
> | samplersList | GetPlaycount |
> | percentiles | 90;95;99 |
>
>
> InfluxDB Configuration:
> [input_plugins.graphite]
> enabled = true
> address = "0.0.0.0" # If not set, is actually set to bind-address.
> port = 2003
> database = "jmeter" # store graphite data in this database
> # udp_enabled = true # enable udp interface on the same port as the tcp
> interface
>
> From: Glenn Caccia <ga...@yahoo.com.INVALID>
> To: JMeter Users List <us...@jmeter.apache.org>
> Sent: Wednesday, April 8, 2015 12:25 PM
> Subject: checking data in influxdb
>
> I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted
> to try Grafana 2.0 (beta), but its configuration is different than the
> older version that JMeter has documentation for and I've not gotten it to
> work yet. I wanted to at least confirm that the InfluxDB part is working
> correctly and would like to run a query to confirm that data made it in
> from a test run. What is the data structure for the JMeter DB? That is,
> if I write a query for "select * from ????, what is ????. I don't know if
> these are called tables or something else, but basically, what structure is
> created in the JMeter database? Into what structure are run results saved?
>
>
>
Re: checking data in influxdb
Posted by Glenn Caccia <ga...@yahoo.com.INVALID>.
Thanks for the response. Yes, I can telnet to the graphiteHost on port 2003 from the computer where I'm running JMeter. I used RubyCLI simply because it gave some examples of how to query for metadata. I'm not sure about your last point. Where in JMeter do I specify the user? I don't see that in the documentation on setting up the Backend Listener.
From: chaitanya bhatt <bh...@gmail.com>
To: JMeter Users List <us...@jmeter.apache.org>; Glenn Caccia <ga...@yahoo.com>
Sent: Wednesday, April 8, 2015 1:56 PM
Subject: Re: checking data in influxdb
can you telnet onto to the graphiteHost on port 2003 from the jmeter
master/controller?
try: telnet hostblahblah.com <http://hostblah.com> 2003
For querying, instead of using RubyCLI for influxdb why don't you try using
the web interface? like: influxhostblah.com:8083
Make sure the database user specified in jmeter is the same as the one
created in influxdb.
Thanks
Chaitanya M Bhatt
http://www.performancecompetence.com
On Wed, Apr 8, 2015 at 1:28 PM, Glenn Caccia <ga...@yahoo.com.invalid>
wrote:
>
> So I kind of answered my own question, which then leads to the next. I
> installed the Ruby CLI for Influxdb. I connected into the jmeter database
> and ran the following command...
> db.query('SELECT * FROM /.*/ LIMIT 1').keys
>
> This returns nothing, which I believe means that JMeter isn't writing
> anything to the InfluxDB "jmeter" database. What am I doing wrong? I
> also enabled the JMeter log and when I run the test, I don't see any errors
> (did at first with an error on connection to graphite host when I had the
> config wrong).
> Here's my setup.
> JMeter 2.13InfluxDB 0.8.8
> JMeter Test Script:Added Backend Listener with settings
>
> | graphiteMetricsSender |
> org.apache.jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender |
> | graphiteHost | xxx-xxx-xxx.com |
> | graphitePort | 2003 |
> | rootMetricsPrefix | jmeter. |
> | summaryOnly | true |
> | samplersList | GetPlaycount |
> | percentiles | 90;95;99 |
>
>
> InfluxDB Configuration:
> [input_plugins.graphite]
> enabled = true
> address = "0.0.0.0" # If not set, is actually set to bind-address.
> port = 2003
> database = "jmeter" # store graphite data in this database
> # udp_enabled = true # enable udp interface on the same port as the tcp
> interface
>
> From: Glenn Caccia <ga...@yahoo.com.INVALID>
> To: JMeter Users List <us...@jmeter.apache.org>
> Sent: Wednesday, April 8, 2015 12:25 PM
> Subject: checking data in influxdb
>
> I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted
> to try Grafana 2.0 (beta), but its configuration is different than the
> older version that JMeter has documentation for and I've not gotten it to
> work yet. I wanted to at least confirm that the InfluxDB part is working
> correctly and would like to run a query to confirm that data made it in
> from a test run. What is the data structure for the JMeter DB? That is,
> if I write a query for "select * from ????, what is ????. I don't know if
> these are called tables or something else, but basically, what structure is
> created in the JMeter database? Into what structure are run results saved?
>
>
>
Re: checking data in influxdb
Posted by chaitanya bhatt <bh...@gmail.com>.
can you telnet onto to the graphiteHost on port 2003 from the jmeter
master/controller?
try: telnet hostblahblah.com <http://hostblah.com> 2003
For querying, instead of using RubyCLI for influxdb why don't you try using
the web interface? like: influxhostblah.com:8083
Make sure the database user specified in jmeter is the same as the one
created in influxdb.
Thanks
Chaitanya M Bhatt
http://www.performancecompetence.com
On Wed, Apr 8, 2015 at 1:28 PM, Glenn Caccia <ga...@yahoo.com.invalid>
wrote:
>
> So I kind of answered my own question, which then leads to the next. I
> installed the Ruby CLI for Influxdb. I connected into the jmeter database
> and ran the following command...
> db.query('SELECT * FROM /.*/ LIMIT 1').keys
>
> This returns nothing, which I believe means that JMeter isn't writing
> anything to the InfluxDB "jmeter" database. What am I doing wrong? I
> also enabled the JMeter log and when I run the test, I don't see any errors
> (did at first with an error on connection to graphite host when I had the
> config wrong).
> Here's my setup.
> JMeter 2.13InfluxDB 0.8.8
> JMeter Test Script:Added Backend Listener with settings
>
> | graphiteMetricsSender |
> org.apache.jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender |
> | graphiteHost | xxx-xxx-xxx.com |
> | graphitePort | 2003 |
> | rootMetricsPrefix | jmeter. |
> | summaryOnly | true |
> | samplersList | GetPlaycount |
> | percentiles | 90;95;99 |
>
>
> InfluxDB Configuration:
> [input_plugins.graphite]
> enabled = true
> address = "0.0.0.0" # If not set, is actually set to bind-address.
> port = 2003
> database = "jmeter" # store graphite data in this database
> # udp_enabled = true # enable udp interface on the same port as the tcp
> interface
>
> From: Glenn Caccia <ga...@yahoo.com.INVALID>
> To: JMeter Users List <us...@jmeter.apache.org>
> Sent: Wednesday, April 8, 2015 12:25 PM
> Subject: checking data in influxdb
>
> I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted
> to try Grafana 2.0 (beta), but its configuration is different than the
> older version that JMeter has documentation for and I've not gotten it to
> work yet. I wanted to at least confirm that the InfluxDB part is working
> correctly and would like to run a query to confirm that data made it in
> from a test run. What is the data structure for the JMeter DB? That is,
> if I write a query for "select * from ????, what is ????. I don't know if
> these are called tables or something else, but basically, what structure is
> created in the JMeter database? Into what structure are run results saved?
>
>
>
Re: checking data in influxdb
Posted by Glenn Caccia <ga...@yahoo.com.INVALID>.
So I kind of answered my own question, which then leads to the next. I installed the Ruby CLI for Influxdb. I connected into the jmeter database and ran the following command...
db.query('SELECT * FROM /.*/ LIMIT 1').keys
This returns nothing, which I believe means that JMeter isn't writing anything to the InfluxDB "jmeter" database. What am I doing wrong? I also enabled the JMeter log and when I run the test, I don't see any errors (did at first with an error on connection to graphite host when I had the config wrong).
Here's my setup.
JMeter 2.13InfluxDB 0.8.8
JMeter Test Script:Added Backend Listener with settings
| graphiteMetricsSender | org.apache.jmeter.visualizers.backend.graphite.TextGraphiteMetricsSender |
| graphiteHost | xxx-xxx-xxx.com |
| graphitePort | 2003 |
| rootMetricsPrefix | jmeter. |
| summaryOnly | true |
| samplersList | GetPlaycount |
| percentiles | 90;95;99 |
InfluxDB Configuration:
[input_plugins.graphite]
enabled = true
address = "0.0.0.0" # If not set, is actually set to bind-address.
port = 2003
database = "jmeter" # store graphite data in this database
# udp_enabled = true # enable udp interface on the same port as the tcp interface
From: Glenn Caccia <ga...@yahoo.com.INVALID>
To: JMeter Users List <us...@jmeter.apache.org>
Sent: Wednesday, April 8, 2015 12:25 PM
Subject: checking data in influxdb
I'm trying to get setup with InfluxDB and Grafana with JMeter. I wanted to try Grafana 2.0 (beta), but its configuration is different than the older version that JMeter has documentation for and I've not gotten it to work yet. I wanted to at least confirm that the InfluxDB part is working correctly and would like to run a query to confirm that data made it in from a test run. What is the data structure for the JMeter DB? That is, if I write a query for "select * from ????, what is ????. I don't know if these are called tables or something else, but basically, what structure is created in the JMeter database? Into what structure are run results saved?