How to write values if I want to query multiple fields

[free]

How to write values if I want to query multiple fields

[shawbruno]

Hey how to install sql_Exporter in linux , i can't install in linux with command in readme.. do u like help me ?

[tangxiaoran]

I used this，Support Oracle 、sqlserver, platform agnostic。 https://github.com/Corundex/database_exporter At 2020-03-12 16:29:16, "shawbruno" <[email protected]> wrote: Hey how to install sql_Exporter in linux , i can't install in linux with command in readme.. do u like help me ? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[shawbruno]

i receive that of line command :

go build github.com/Corundex/database_exporter
can't load package: package github.com/Corundex/database_exporter: cannot find package "github.com/Corundex/database_exporter" in any of:
/usr/lib/go-1.10/src/github.com/Corundex/database_exporter (from $GOROOT)
/home/ana-aeroportos/go/src/github.com/Corundex/database_exporter (from $GOPATH)

[free]

@shawbruno, please do not hijack threads, I've tried to answer your issue directly.

@tangxiaoran, the answer to your question is in the error message: "value_label must be defined for metric with multiple values".

As is, you would get one oracle_tablespace_detail{tablespace_name="foo",autoextend="bar"} value (with no extra label) for each of free, usage and total. I.e. 3 instances of the exact same metric. You need a type (or something) label with the value label set to free/usage/total in order to differentiate between the three. E.g.

oracle_tablespace_detail{tablespace_name="foo",autoextend="bar",type="free"} 1
oracle_tablespace_detail{tablespace_name="foo",autoextend="bar",type="usage"} 2
oracle_tablespace_detail{tablespace_name="foo",autoextend="bar",type="total"} 3

But you need to tell SQL Exporter what name to use for that label, which is where the value_label comes in. See for example the mssql_io_stall_seconds metric in mssql_standard.collector.yml. So you would need to rewrite your config to something like this instead (you can use something more informative instead of "type"):

 - metric_name: oracle_tablespace_detail
    type: gauge
    help: 'oracle_tablespace_detail.'
    value_label: type
    values:
      - free
      - usage
      - total
    key_labels:
      - tablespace_name
      - autoextend
    query: |
        [...]