API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 20th, 2016
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 16.29 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0"?>
  2. <jdbc-datacollection-config rrdRepository="/var/lib/opennms/rrd/snmp/" xmlns="http://xmlns.opennms.org/xsd/config/jdbc-datacollection">
  3.     <jdbc-collection name="default">
  4.         <rrd step="300">
  5.           <rra>RRA:AVERAGE:0.5:1:2016</rra>
  6.           <rra>RRA:AVERAGE:0.5:12:1488</rra>
  7.           <rra>RRA:AVERAGE:0.5:288:366</rra>
  8.           <rra>RRA:MAX:0.5:288:366</rra>
  9.           <rra>RRA:MIN:0.5:288:366</rra>
  10.         </rrd>
  11.       <queries>
  12.         <query name="opennmsQuery" ifType="ignore">
  13.           <statement data-source="opennms">
  14.             <queryString>SELECT COUNT(eventid) as EventCount
  15. FROM events
  16. WHERE eventtime
  17. BETWEEN (CURRENT_TIMESTAMP - INTERVAL '1 day')
  18. AND CURRENT_TIMESTAMP;</queryString>
  19.           </statement>
  20.           <columns>
  21.             <column name="eventCount" data-source-name="EventCount" alias="OnmsEventCount" type="GAUGE"/>
  22.           </columns>
  23.         </query>
  24.         <query name="opennmsNodeQuery" ifType="ignore">
  25.           <statement data-source="opennms">
  26.             <queryString>SELECT COUNT(*) as NodeCount FROM node WHERE nodetype != 'D';</queryString>
  27.           </statement>
  28.           <columns>
  29.             <column name="nodeCount" data-source-name="NodeCount" alias="OnmsNodeCount" type="GAUGE"/>
  30.           </columns>
  31.         </query>
  32.       </queries>
  33.     </jdbc-collection>
  34.  
  35.     <jdbc-collection name="MySQL-Global-Stats-51">
  36.     <rrd step="300">
  37.         <rra>RRA:AVERAGE:0.5:1:2016</rra>
  38.         <rra>RRA:AVERAGE:0.5:12:1488</rra>
  39.         <rra>RRA:AVERAGE:0.5:288:366</rra>
  40.         <rra>RRA:MAX:0.5:288:366</rra>
  41.         <rra>RRA:MIN:0.5:288:366</rra>
  42.     </rrd>
  43.     <queries>
  44.         <query name="Q_MyUptime" ifType="ignore" >
  45.         <statement>
  46.             <queryString>SELECT VARIABLE_VALUE AS Uptime FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'UPTIME'</queryString>
  47.         </statement>
  48.         <columns>
  49.             <column name="Uptime" data-source-name="Uptime" alias="MyUptime" type="GAUGE"/>
  50.         </columns>
  51.             </query>
  52.         <query name="Q_MyBytesReceived" ifType="ignore" >
  53.         <statement>
  54.             <queryString>SELECT VARIABLE_VALUE AS Bytes_received FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'BYTES_RECEIVED'</queryString>
  55.         </statement>
  56.         <columns>
  57.             <column name="Bytes_received" data-source-name="Bytes_received" alias="MyBytesReceived" type="COUNTER"/>
  58.         </columns>
  59.             </query>
  60.         <query name="Q_MyBytesSent" ifType="ignore" >
  61.         <statement>
  62.             <queryString>SELECT VARIABLE_VALUE AS Bytes_sent FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'BYTES_SENT'</queryString>
  63.         </statement>
  64.         <columns>
  65.             <column name="Bytes_sent" data-source-name="Bytes_sent" alias="MyBytesSent" type="COUNTER"/>
  66.         </columns>
  67.         </query>
  68.         <query name="Q_Com_delete" ifType="ignore" >
  69.         <statement>
  70.             <queryString>SELECT VARIABLE_VALUE AS Com_delete FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_DELETE'</queryString>
  71.         </statement>
  72.         <columns>
  73.             <column name="Com_delete" data-source-name="Com_delete" alias="MyComDelete" type="COUNTER"/>
  74.         </columns>
  75.         </query>
  76.         <query name="Q_Com_delete_multi" ifType="ignore" >
  77.         <statement>
  78.             <queryString>SELECT VARIABLE_VALUE AS Com_delete_multi FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_DELETE_MULTI'</queryString>
  79.         </statement>
  80.         <columns>
  81.             <column name="Com_delete_multi" data-source-name="Com_delete_multi" alias="MyComDeleteMulti" type="COUNTER"/>
  82.         </columns>
  83.         </query>
  84.         <query name="Q_Com_insert" ifType="ignore" >
  85.         <statement>
  86.             <queryString>SELECT VARIABLE_VALUE AS Com_insert FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_INSERT'</queryString>
  87.         </statement>
  88.         <columns>
  89.             <column name="Com_insert" data-source-name="Com_insert" alias="MyComInsert" type="COUNTER"/>
  90.         </columns>
  91.         </query>
  92.         <query name="Q_Com_insert_select" ifType="ignore" >
  93.         <statement>
  94.             <queryString>SELECT VARIABLE_VALUE AS Com_insert_select FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_INSERT_SELECT'</queryString>
  95.         </statement>
  96.         <columns>
  97.             <column name="Com_insert_select" data-source-name="Com_insert_select" alias="MyComInsertSelect" type="COUNTER"/>
  98.         </columns>
  99.         </query>
  100.         <query name="Q_Com_select" ifType="ignore" >
  101.         <statement>
  102.             <queryString>SELECT VARIABLE_VALUE AS Com_select FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_SELECT'</queryString>
  103.         </statement>
  104.         <columns>
  105.             <column name="Com_select" data-source-name="Com_select" alias="MyComSelect" type="COUNTER"/>
  106.         </columns>
  107.         </query>
  108.         <query name="Q_Com_stmt_execute" ifType="ignore" >
  109.         <statement>
  110.             <queryString>SELECT VARIABLE_VALUE AS Com_stmt_execute FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_STMT_EXECUTE'</queryString>
  111.         </statement>
  112.         <columns>
  113.             <column name="Com_stmt_execute" data-source-name="Com_stmt_execute" alias="MyComStmtExecute" type="COUNTER"/>
  114.         </columns>
  115.         </query>
  116.         <query name="Q_Com_update" ifType="ignore" >
  117.         <statement>
  118.             <queryString>SELECT VARIABLE_VALUE AS Com_update FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_UPDATE'</queryString>
  119.         </statement>
  120.         <columns>
  121.             <column name="Com_update" data-source-name="Com_update" alias="MyComUpdate" type="COUNTER"/>
  122.         </columns>
  123.         </query>
  124.         <query name="Q_Com_update_multi" ifType="ignore" >
  125.         <statement>
  126.             <queryString>SELECT VARIABLE_VALUE AS Com_update_multi FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'COM_UPDATE_MULTI'</queryString>
  127.         </statement>
  128.         <columns>
  129.             <column name="Com_update_multi" data-source-name="Com_update_multi" alias="MyComUpdateMulti" type="COUNTER"/>
  130.         </columns>
  131.         </query>
  132.         <query name="Q_Created_tmp_disk_tables" ifType="ignore" >
  133.         <statement>
  134.             <queryString>SELECT VARIABLE_VALUE AS Created_tmp_disk_tables FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'CREATED_TMP_DISK_TABLES'</queryString>
  135.         </statement>
  136.         <columns>
  137.             <column name="Created_tmp_disk_tables" data-source-name="Created_tmp_disk_tables" alias="MyCreatTmpDiskTbl" type="COUNTER"/>
  138.         </columns>
  139.         </query>
  140.         <query name="Q_Created_tmp_tables" ifType="ignore" >
  141.         <statement>
  142.             <queryString>SELECT VARIABLE_VALUE AS Created_tmp_tables FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'CREATED_TMP_TABLES'</queryString>
  143.         </statement>
  144.         <columns>
  145.             <column name="Created_tmp_tables" data-source-name="Created_tmp_tables" alias="MyCreatTmpTables" type="COUNTER"/>
  146.         </columns>
  147.         </query>
  148.         <query name="Q_key_buffer_size" ifType="ignore" >
  149.         <statement>
  150.             <queryString>SELECT VARIABLE_VALUE AS key_buffer_size FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME ='KEY_BUFFER_SIZE'</queryString>
  151.         </statement>
  152.         <columns>
  153.             <column name="key_buffer_size" data-source-name="key_buffer_size" alias="MyKeyBufferSize" type="GAUGE"/>
  154.         </columns>
  155.         </query>
  156.         <query name="Q_key_cache_block_size" ifType="ignore" >
  157.         <statement>
  158.             <queryString>SELECT VARIABLE_VALUE AS key_cache_block_size FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME ='KEY_CACHE_BLOCK_SIZE'</queryString>
  159.         </statement>
  160.         <columns>
  161.             <column name="key_cache_block_size" data-source-name="key_cache_block_size" alias="MyKeyCacheBlkSize" type="GAUGE"/>
  162.         </columns>
  163.         </query>
  164.         <query name="Q_Key_blocks_unused" ifType="ignore" >
  165.         <statement>
  166.             <queryString>SELECT VARIABLE_VALUE AS Key_blocks_unused FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'KEY_BLOCKS_UNUSED'</queryString>
  167.         </statement>
  168.         <columns>
  169.             <column name="Key_blocks_unused" data-source-name="Key_blocks_unused" alias="MyKeyBlkUnused" type="GAUGE"/>
  170.         </columns>
  171.         </query>
  172.         <query name="Q_Key_read_requests" ifType="ignore" >
  173.         <statement>
  174.             <queryString>SELECT VARIABLE_VALUE AS Key_read_requests FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'KEY_READ_REQUESTS'</queryString>
  175.         </statement>
  176.         <columns>
  177.             <column name="Key_read_requests" data-source-name="Key_read_requests" alias="MyKeyReadReqs" type="COUNTER"/>
  178.         </columns>
  179.         </query>
  180.         <query name="Q_Key_reads" ifType="ignore" >
  181.         <statement>
  182.             <queryString>SELECT VARIABLE_VALUE AS Key_reads FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'KEY_READS'</queryString>
  183.         </statement>
  184.         <columns>
  185.             <column name="Key_reads" data-source-name="Key_reads" alias="MyKeyReads" type="COUNTER"/>
  186.         </columns>
  187.         </query>
  188.         <query name="Q_Key_write_requests" ifType="ignore" >
  189.         <statement>
  190.             <queryString>SELECT VARIABLE_VALUE AS Key_write_requests FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'KEY_WRITE_REQUESTS'</queryString>
  191.         </statement>
  192.         <columns>
  193.             <column name="Key_write_requests" data-source-name="Key_write_requests" alias="MyKeyWriteReqs" type="COUNTER"/>
  194.         </columns>
  195.         </query>
  196.         <query name="Q_Key_writes" ifType="ignore" >
  197.         <statement>
  198.             <queryString>SELECT VARIABLE_VALUE AS Key_writes FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'KEY_WRITES'</queryString>
  199.         </statement>
  200.         <columns>
  201.             <column name="Key_writes" data-source-name="Key_writes" alias="MyKeyWrites" type="COUNTER"/>
  202.         </columns>
  203.         </query>
  204.         <query name="Q_Open_files" ifType="ignore" >
  205.         <statement>
  206.             <queryString>SELECT VARIABLE_VALUE AS Open_files FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'OPEN_FILES'</queryString>
  207.         </statement>
  208.         <columns>
  209.             <column name="Open_files" data-source-name="Open_files" alias="MyOpenFiles" type="GAUGE"/>
  210.         </columns>
  211.         </query>
  212.         <query name="Q_Open_tables" ifType="ignore" >
  213.         <statement>
  214.             <queryString>SELECT VARIABLE_VALUE AS Open_tables FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'OPEN_TABLES'</queryString>
  215.         </statement>
  216.         <columns>
  217.             <column name="Open_tables" data-source-name="Open_tables" alias="MyOpenTables" type="GAUGE"/>
  218.         </columns>
  219.         </query>
  220.         <query name="Q_table_open_cache" ifType="ignore" >
  221.         <statement>
  222.             <queryString>SELECT VARIABLE_VALUE AS table_open_cache FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME ='TABLE_OPEN_CACHE'</queryString>
  223.         </statement>
  224.         <columns>
  225.             <column name="table_open_cache" data-source-name="table_open_cache" alias="MyTableOpenCache" type="GAUGE"/>
  226.         </columns>
  227.         </query>
  228.         <query name="Q_Questions" ifType="ignore" >
  229.         <statement>
  230.             <queryString>SELECT VARIABLE_VALUE AS Questions FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'QUESTIONS'</queryString>
  231.         </statement>
  232.         <columns>
  233.             <column name="Questions" data-source-name="Questions" alias="MyQuestions" type="COUNTER"/>
  234.         </columns>
  235.         </query>
  236.         <query name="Q_Slow_queries" ifType="ignore" >
  237.         <statement>
  238.             <queryString>SELECT VARIABLE_VALUE AS Slow_queries FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'SLOW_QUERIES'</queryString>
  239.         </statement>
  240.         <columns>
  241.             <column name="Slow_queries" data-source-name="Slow_queries" alias="MySlowQueries" type="COUNTER"/>
  242.         </columns>
  243.         </query>
  244.         <query name="Q_Connections" ifType="ignore" >
  245.         <statement>
  246.             <queryString>SELECT VARIABLE_VALUE AS Connections FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'CONNECTIONS'</queryString>
  247.         </statement>
  248.         <columns>
  249.             <column name="Connections" data-source-name="Connections" alias="MyConnections" type="COUNTER"/>
  250.         </columns>
  251.         </query>
  252.         <query name="Q_Threads_created" ifType="ignore" >
  253.         <statement>
  254.             <queryString>SELECT VARIABLE_VALUE Threads_created FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'THREADS_CREATED'</queryString>
  255.         </statement>
  256.         <columns>
  257.             <column name="Threads_created" data-source-name="Threads_created" alias="MyThreadsCreatd" type="COUNTER"/>
  258.         </columns>
  259.         </query>
  260.         <query name="Q_Threads_cached" ifType="ignore" >
  261.         <statement>
  262.             <queryString>SELECT VARIABLE_VALUE AS Threads_cached FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'THREADS_CACHED'</queryString>
  263.         </statement>
  264.         <columns>
  265.             <column name="Threads_cached" data-source-name="Threads_cached" alias="MyThreadsCachd" type="GAUGE"/>
  266.         </columns>
  267.         </query>
  268.         <query name="Q_Threads_connected" ifType="ignore" >
  269.         <statement>
  270.             <queryString>SELECT VARIABLE_VALUE AS Threads_connected FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'THREADS_CONNECTED'</queryString>
  271.         </statement>
  272.         <columns>
  273.             <column name="Threads_connected" data-source-name="Threads_connected" alias="MyThreadsCnnctd" type="GAUGE"/>
  274.         </columns>
  275.         </query>
  276.         <query name="Q_Threads_running" ifType="ignore" >
  277.         <statement>
  278.             <queryString>SELECT VARIABLE_VALUE AS Threads_running FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'THREADS_RUNNING'</queryString>
  279.         </statement>
  280.         <columns>
  281.             <column name="Threads_running" data-source-name="Threads_running" alias="MyThreadsRunng" type="GAUGE"/>
  282.         </columns>
  283.         </query>
  284.     </queries>
  285.     </jdbc-collection>
  286.     <jdbc-collection name="PostgreSQL">
  287.         <rrd step="300">
  288.             <rra>RRA:AVERAGE:0.5:1:2016</rra>
  289.             <rra>RRA:AVERAGE:0.5:12:1488</rra>
  290.             <rra>RRA:AVERAGE:0.5:288:366</rra>
  291.             <rra>RRA:MAX:0.5:288:366</rra>
  292.             <rra>RRA:MIN:0.5:288:366</rra>
  293.         </rrd>
  294.         <queries>
  295.             <query name="pg_tablespace_size" ifType="all" resourceType="pgTableSpace" instance-column="spcname">
  296.                 <statement>
  297.                     <queryString>
  298.                     SELECT spcname, pg_tablespace_size(pg_tablespace.spcname) AS ts_size
  299.                     FROM pg_tablespace
  300.                     </queryString>
  301.                 </statement>
  302.                 <columns>
  303.                     <column name="spcname" data-source-name="spcname" alias="spcname" type="string"/>
  304.                     <column name="ts_size" data-source-name="ts_size" alias="ts_size" type="gauge"/>
  305.                 </columns>
  306.             </query>
  307.             <query name="pg_stat_database" ifType="all" resourceType="pgDatabase" instance-column="datname">
  308.                 <statement>
  309.                     <queryString>
  310.                     SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit,
  311.                            pg_database_size(pg_stat_database.datname) AS db_size
  312.                     FROM pg_stat_database
  313.                     WHERE datname NOT IN ('template0', 'template1')
  314.                     </queryString>
  315.                 </statement>
  316.                 <columns>
  317.                     <column name="datname" data-source-name="datname" alias="datname" type="string"/>
  318.                     <column name="numbackends" data-source-name="numbackends" alias="numbackends" type="gauge"/>
  319.                     <column name="xact_commit" data-source-name="xact_commit" alias="xact_commit" type="counter"/>
  320.                     <column name="xact_rollback" data-source-name="xact_rollback" alias="xact_rollback" type="counter"/>
  321.                     <column name="blks_read" data-source-name="blks_read" alias="blks_read" type="counter"/>
  322.                     <column name="blks_hit" data-source-name="blks_hit" alias="blks_hit" type="counter"/>
  323.                     <column name="db_size" data-source-name="db_size" alias="db_size" type="gauge"/>
  324.                 </columns>
  325.             </query>
  326.         </queries>
  327.     </jdbc-collection>
  328.  
  329.     <jdbc-collection name="mysql-balances">
  330.       <rrd step="300">
  331.         <rra>RRA:AVERAGE:0.5:1:2016</rra>
  332.         <rra>RRA:AVERAGE:0.5:12:1488</rra>
  333.         <rra>RRA:AVERAGE:0.5:288:366</rra>
  334.         <rra>RRA:MAX:0.5:288:366</rra>
  335.         <rra>RRA:MIN:0.5:288:366</rra>
  336.       </rrd>
  337.       <queries>
  338.         <query name="accountsQuery" ifType="ignore">
  339.           <statement>
  340.             <queryString>
  341.                 SELECT COUNT(*) AS accountsCount FROM accounts
  342.             </queryString>
  343.           </statement>
  344.           <columns>
  345.             <column name="accountsCount" data-source-name="accountsCount" alias="accountsCount" type="counter"/>
  346.           </columns>
  347.         </query>
  348.         <query name="accountsBalance" ifType="ignore" instance-column="accountId" resourceType="balanceAccount">
  349.           <statement>
  350.             <queryString>
  351.                  <!--
  352.                 SELECT accountId, accountName, round(rand()*100) as accountBalance FROM accounts
  353.                 -->
  354.                 SELECT accountId, accountName, accountBalance FROM accounts
  355.             </queryString>
  356.           </statement>
  357.           <columns>
  358.             <column name="accountName"    data-source-name="accountName"    alias="accountName"    type="string"/>
  359.             <column name="accountBalance" data-source-name="accountBalance" alias="accountBalance" type="gauge"/>
  360.           </columns>
  361.         </query>
  362.       </queries>
  363.     </jdbc-collection>
  364.  
  365. </jdbc-datacollection-config>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!