{"action":"created","comment":{"url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/comments/205678261","pull_request_review_id":140995121,"id":205678261,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIwNTY3ODI2MQ==","diff_hunk":"@@ -0,0 +1,180 @@\n+type: db\n+data:\n+  query: SELECT * FROM events;\n+  dbUrl: jdbc:clickhouse://${SPM_MONITOR_CLICKHOUSE_DB_HOST_PORT}/system\n+  dbDriverClass: ru.yandex.clickhouse.ClickHouseDriver\n+  dbUser: ${SPM_MONITOR_CLICKHOUSE_DB_USER}\n+  dbPassword: ${SPM_MONITOR_CLICKHOUSE_DB_PASSWORD}\n+  #  dbVerticalModel=\"true\" - because output of `SELECT * FROM events;` query gives each attribute in its own row\n+  # (1st column being attribute name, 2nd column being attribute value)\n+  dbVerticalModel: true\n+\n+observation:\n+  # ProfileEvents counts number of happened events - for example, how many times queries was executed\n+  - name: events\n+    metricNamespace: clickhouse\n+\n+    metric:\n+      - name: query.count\n+        source: Query\n+        type: counter\n+        label: Query count\n+        description: Total query count\n+      - name: select.query.count\n+        source: SelectQuery\n+        type: counter\n+        label: Select query count\n+      - name: insert.query.count\n+        source: InsertQuery\n+        type: counter\n+        label: Insert query count\n+      - name: file.opens.failed\n+        source: FileOpenFailed\n+        type: counter\n+        label: Failed file opens\n+      - name: read.buffer.fd.failed\n+        source: ReadBufferFromFileDescriptorReadFailed\n+        type: counter\n+        label: Read buffer failed file reads\n+        description: Failed reads from file in ReadBuffer\n+      - name: write.buffer.fd.failed\n+        source: WriteBufferFromFileDescriptorWriteFailed\n+        type: counter\n+        label: Write buffer failed file writes\n+        description: Failed writes to file in WriteBuffer\n+      - name: inserted.rows\n+        source: InsertedRows\n+        type: counter\n+        label: Inserted rows\n+      - name: inserted.bytes\n+        source: InsertedBytes\n+        type: counter\n+        label: Inserted bytes\n+        unit: bytes\n+      - name: merged.rows\n+        source: MergedRows\n+        type: counter\n+        label: Merged rows\n+      - name: mark.cache.hits\n+        source: MarkCacheHits\n+        type: counter\n+        label: Mark cache hits\n+        description: \"Mark cache - Cache of 'marks' for merge tree storage engine. Marks is an index structure that addresses ranges in column file, corresponding to ranges of primary key\"\n+      - name: mark.cache.misses\n+        source: MarkCacheMisses\n+        type: counter\n+        label: Mark cache misses\n+        description: \"Mark cache - Cache of 'marks' for merge tree storage engine. Marks is an index structure that addresses ranges in column file, corresponding to ranges of primary key\"\n+      - name: repl.part.fetches\n+        source: ReplicatedPartFetches\n+        type: counter\n+        label: Replicated part fetches\n+      - name: repl.part.failed.fetches\n+        source: ReplicatedPartFailedFetches\n+        type: counter\n+        label: Failed replicated part fetches\n+      - name: repl.obsolete.parts\n+        source: ObsoleteReplicatedParts\n+        type: counter\n+        label: Obsolete replicated parts\n+        description: Replicated parts that are replaced/rendered obsolete by fetching new parts\n+      - name: repl.part.merges\n+        source: ReplicatedPartMerges\n+        type: counter\n+        label: Replicated part merges\n+      - name: repl.part.fetches.merged\n+        source: ReplicatedPartFetchesOfMerged\n+        type: counter\n+        label: Fetches of merged replicated parts\n+      - name: repl.part.checks\n+        source: ReplicatedPartChecks\n+        type: counter\n+        label: Replicated part checks\n+      - name: repl.part.checks.failed\n+        source: ReplicatedPartChecksFailed\n+        type: counter\n+        label: Failed replicated part checks\n+      - name: repl.data.loss","path":"clickhouse/db-system-events.yml","position":97,"original_position":97,"commit_id":"718afdfa4c82af21515b802ae09f3e3c4feb2dbc","original_commit_id":"718afdfa4c82af21515b802ae09f3e3c4feb2dbc","user":{"login":"bsmid","id":2103074,"node_id":"MDQ6VXNlcjIxMDMwNzQ=","avatar_url":"https://avatars3.githubusercontent.com/u/2103074?v=4","gravatar_id":"","url":"https://api.github.com/users/bsmid","html_url":"https://github.com/bsmid","followers_url":"https://api.github.com/users/bsmid/followers","following_url":"https://api.github.com/users/bsmid/following{/other_user}","gists_url":"https://api.github.com/users/bsmid/gists{/gist_id}","starred_url":"https://api.github.com/users/bsmid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bsmid/subscriptions","organizations_url":"https://api.github.com/users/bsmid/orgs","repos_url":"https://api.github.com/users/bsmid/repos","events_url":"https://api.github.com/users/bsmid/events{/privacy}","received_events_url":"https://api.github.com/users/bsmid/received_events","type":"User","site_admin":false},"body":"Maybe ```repl.part.lost```?","created_at":"2018-07-27T06:24:08Z","updated_at":"2018-07-27T06:36:45Z","html_url":"https://github.com/sematext/sematext-agent-integrations/pull/5#discussion_r205678261","pull_request_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/comments/205678261"},"html":{"href":"https://github.com/sematext/sematext-agent-integrations/pull/5#discussion_r205678261"},"pull_request":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5"}}},"pull_request":{"url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5","id":204321923,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA0MzIxOTIz","html_url":"https://github.com/sematext/sematext-agent-integrations/pull/5","diff_url":"https://github.com/sematext/sematext-agent-integrations/pull/5.diff","patch_url":"https://github.com/sematext/sematext-agent-integrations/pull/5.patch","issue_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/5","number":5,"state":"open","locked":false,"title":"Clickhouse integration - YAMLs","user":{"login":"sivasamyk","id":1464186,"node_id":"MDQ6VXNlcjE0NjQxODY=","avatar_url":"https://avatars0.githubusercontent.com/u/1464186?v=4","gravatar_id":"","url":"https://api.github.com/users/sivasamyk","html_url":"https://github.com/sivasamyk","followers_url":"https://api.github.com/users/sivasamyk/followers","following_url":"https://api.github.com/users/sivasamyk/following{/other_user}","gists_url":"https://api.github.com/users/sivasamyk/gists{/gist_id}","starred_url":"https://api.github.com/users/sivasamyk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sivasamyk/subscriptions","organizations_url":"https://api.github.com/users/sivasamyk/orgs","repos_url":"https://api.github.com/users/sivasamyk/repos","events_url":"https://api.github.com/users/sivasamyk/events{/privacy}","received_events_url":"https://api.github.com/users/sivasamyk/received_events","type":"User","site_admin":false},"body":"This PR contains the following changes\r\n1) YAML configs for CH metrics, async metrics, dicts, events & replicas\r\n2) JDBC driver for CH","created_at":"2018-07-27T03:41:34Z","updated_at":"2018-07-27T06:36:45Z","closed_at":null,"merged_at":null,"merge_commit_sha":"9253f7d6eaa12c651e37314714dd14ec6e083033","assignee":null,"assignees":[],"requested_reviewers":[{"login":"wawanawna","id":1091862,"node_id":"MDQ6VXNlcjEwOTE4NjI=","avatar_url":"https://avatars0.githubusercontent.com/u/1091862?v=4","gravatar_id":"","url":"https://api.github.com/users/wawanawna","html_url":"https://github.com/wawanawna","followers_url":"https://api.github.com/users/wawanawna/followers","following_url":"https://api.github.com/users/wawanawna/following{/other_user}","gists_url":"https://api.github.com/users/wawanawna/gists{/gist_id}","starred_url":"https://api.github.com/users/wawanawna/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wawanawna/subscriptions","organizations_url":"https://api.github.com/users/wawanawna/orgs","repos_url":"https://api.github.com/users/wawanawna/repos","events_url":"https://api.github.com/users/wawanawna/events{/privacy}","received_events_url":"https://api.github.com/users/wawanawna/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5/commits","review_comments_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5/comments","review_comment_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/comments{/number}","comments_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/5/comments","statuses_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/statuses/718afdfa4c82af21515b802ae09f3e3c4feb2dbc","head":{"label":"sematext:clickhouse_integration","ref":"clickhouse_integration","sha":"718afdfa4c82af21515b802ae09f3e3c4feb2dbc","user":{"login":"sematext","id":332582,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMzMjU4Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/332582?v=4","gravatar_id":"","url":"https://api.github.com/users/sematext","html_url":"https://github.com/sematext","followers_url":"https://api.github.com/users/sematext/followers","following_url":"https://api.github.com/users/sematext/following{/other_user}","gists_url":"https://api.github.com/users/sematext/gists{/gist_id}","starred_url":"https://api.github.com/users/sematext/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sematext/subscriptions","organizations_url":"https://api.github.com/users/sematext/orgs","repos_url":"https://api.github.com/users/sematext/repos","events_url":"https://api.github.com/users/sematext/events{/privacy}","received_events_url":"https://api.github.com/users/sematext/received_events","type":"Organization","site_admin":false},"repo":{"id":129094997,"node_id":"MDEwOlJlcG9zaXRvcnkxMjkwOTQ5OTc=","name":"sematext-agent-integrations","full_name":"sematext/sematext-agent-integrations","owner":{"login":"sematext","id":332582,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMzMjU4Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/332582?v=4","gravatar_id":"","url":"https://api.github.com/users/sematext","html_url":"https://github.com/sematext","followers_url":"https://api.github.com/users/sematext/followers","following_url":"https://api.github.com/users/sematext/following{/other_user}","gists_url":"https://api.github.com/users/sematext/gists{/gist_id}","starred_url":"https://api.github.com/users/sematext/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sematext/subscriptions","organizations_url":"https://api.github.com/users/sematext/orgs","repos_url":"https://api.github.com/users/sematext/repos","events_url":"https://api.github.com/users/sematext/events{/privacy}","received_events_url":"https://api.github.com/users/sematext/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/sematext/sematext-agent-integrations","description":null,"fork":false,"url":"https://api.github.com/repos/sematext/sematext-agent-integrations","forks_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/forks","keys_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/teams","hooks_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/hooks","issue_events_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/events{/number}","events_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/events","assignees_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/assignees{/user}","branches_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/branches{/branch}","tags_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/tags","blobs_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/refs{/sha}","trees_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/statuses/{sha}","languages_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/languages","stargazers_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/stargazers","contributors_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/contributors","subscribers_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/subscribers","subscription_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/subscription","commits_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/commits{/sha}","git_commits_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/commits{/sha}","comments_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/comments{/number}","issue_comment_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/comments{/number}","contents_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/contents/{+path}","compare_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/merges","archive_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/downloads","issues_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues{/number}","pulls_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls{/number}","milestones_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/milestones{/number}","notifications_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/labels{/name}","releases_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/releases{/id}","deployments_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/deployments","created_at":"2018-04-11T13:06:15Z","updated_at":"2018-07-09T12:33:02Z","pushed_at":"2018-07-27T03:41:35Z","git_url":"git://github.com/sematext/sematext-agent-integrations.git","ssh_url":"git@github.com:sematext/sematext-agent-integrations.git","clone_url":"https://github.com/sematext/sematext-agent-integrations.git","svn_url":"https://github.com/sematext/sematext-agent-integrations","homepage":null,"size":5577,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"sematext:master","ref":"master","sha":"45bf1e154b840b010dba325fca500e707f4b3491","user":{"login":"sematext","id":332582,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMzMjU4Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/332582?v=4","gravatar_id":"","url":"https://api.github.com/users/sematext","html_url":"https://github.com/sematext","followers_url":"https://api.github.com/users/sematext/followers","following_url":"https://api.github.com/users/sematext/following{/other_user}","gists_url":"https://api.github.com/users/sematext/gists{/gist_id}","starred_url":"https://api.github.com/users/sematext/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sematext/subscriptions","organizations_url":"https://api.github.com/users/sematext/orgs","repos_url":"https://api.github.com/users/sematext/repos","events_url":"https://api.github.com/users/sematext/events{/privacy}","received_events_url":"https://api.github.com/users/sematext/received_events","type":"Organization","site_admin":false},"repo":{"id":129094997,"node_id":"MDEwOlJlcG9zaXRvcnkxMjkwOTQ5OTc=","name":"sematext-agent-integrations","full_name":"sematext/sematext-agent-integrations","owner":{"login":"sematext","id":332582,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMzMjU4Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/332582?v=4","gravatar_id":"","url":"https://api.github.com/users/sematext","html_url":"https://github.com/sematext","followers_url":"https://api.github.com/users/sematext/followers","following_url":"https://api.github.com/users/sematext/following{/other_user}","gists_url":"https://api.github.com/users/sematext/gists{/gist_id}","starred_url":"https://api.github.com/users/sematext/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sematext/subscriptions","organizations_url":"https://api.github.com/users/sematext/orgs","repos_url":"https://api.github.com/users/sematext/repos","events_url":"https://api.github.com/users/sematext/events{/privacy}","received_events_url":"https://api.github.com/users/sematext/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/sematext/sematext-agent-integrations","description":null,"fork":false,"url":"https://api.github.com/repos/sematext/sematext-agent-integrations","forks_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/forks","keys_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/teams","hooks_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/hooks","issue_events_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/events{/number}","events_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/events","assignees_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/assignees{/user}","branches_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/branches{/branch}","tags_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/tags","blobs_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/refs{/sha}","trees_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/statuses/{sha}","languages_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/languages","stargazers_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/stargazers","contributors_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/contributors","subscribers_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/subscribers","subscription_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/subscription","commits_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/commits{/sha}","git_commits_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/git/commits{/sha}","comments_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/comments{/number}","issue_comment_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/comments{/number}","contents_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/contents/{+path}","compare_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/merges","archive_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/downloads","issues_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues{/number}","pulls_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls{/number}","milestones_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/milestones{/number}","notifications_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/labels{/name}","releases_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/releases{/id}","deployments_url":"https://api.github.com/repos/sematext/sematext-agent-integrations/deployments","created_at":"2018-04-11T13:06:15Z","updated_at":"2018-07-09T12:33:02Z","pushed_at":"2018-07-27T03:41:35Z","git_url":"git://github.com/sematext/sematext-agent-integrations.git","ssh_url":"git@github.com:sematext/sematext-agent-integrations.git","clone_url":"https://github.com/sematext/sematext-agent-integrations.git","svn_url":"https://github.com/sematext/sematext-agent-integrations","homepage":null,"size":5577,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5"},"html":{"href":"https://github.com/sematext/sematext-agent-integrations/pull/5"},"issue":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/5"},"comments":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/issues/5/comments"},"review_comments":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5/comments"},"review_comment":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/pulls/5/commits"},"statuses":{"href":"https://api.github.com/repos/sematext/sematext-agent-integrations/statuses/718afdfa4c82af21515b802ae09f3e3c4feb2dbc"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"bsmid"}}