Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bench-Marker tool is not able to read queries from a file having 1M queries #16

Open
shisapian opened this issue Jan 28, 2017 · 1 comment

Comments

@shisapian
Copy link

Use case : "Identifying a data base which supports 1.08 million events per hour"

Steps I am following :

  1. I am populating data in InfluxDB by using Java API. ( Not using bulk_data_gen and bulk_data_load tools ) .
  2. In my Data model, I have one measurement with 1 million rows. All tags and keys are String field.
  3. now I am using "bulk_query_gen " tool to generate queries and write it into a file.
    I have modified the tool to create queries like "select from measurement where time < X and Time < y"

Bulk_gen_query tool

./bulk_query_gen --debug=0 --seed=321 --format=influx-http --timestamp-end="2016-01-18T14:44:00Z" -queries=1000000 --query-type="1-host-1-hr" --db="benchmark" --debug 1 | gzip > EventQueries1M.gz

** Query_Benchmarker_tool**

bash-3.2$
cat EventQueries1M.gz | gunzip | ./query_benchmarker_influxdb --url=http://localhost:8086 --print-interval=0 –limit=1000 --workers=2 --print-responses=true -- db="benchmark" --debug 1

**2017/01/27 21:45:51 Error during request: dialing to the given TCP address timed out**

( If the query size is > 10k, I am running into this issue )

Please note, I could reproduce this issue without making any changes to the benchmarking tool.

@shisapian
Copy link
Author

Below is the response I got

ID 9997: {
ID 9997: "results": [
ID 9997: {
ID 9997: "error": "unsupported call: countn"
ID 9997: }
ID 9997: ]
ID 9997: }

ID 9998: {
ID 9998: "results": [
ID 9998: {
ID 9998: "error": "unsupported call: countn"
ID 9998: }
ID 9998: ]
ID 9998: }

ID 9999: {
ID 9999: "results": [
ID 9999: {
ID 9999: "error": "unsupported call: countn"
ID 9999: }
ID 9999: ]
ID 9999: }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant