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 <[email protected]> To: JMeter Users List <[email protected]> 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 <[email protected]> To: JMeter Users List <[email protected]>; Glenn Caccia <[email protected]> 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 <[email protected]> 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 <[email protected]> > To: JMeter Users List <[email protected]> > 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? > > >
