{"action":"created","comment":{"url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/comments/189591761","pull_request_review_id":121796411,"id":189591761,"diff_hunk":"@@ -0,0 +1,69 @@\n+test_duration: 90\n+stress_cmd_no_mv: \"cassandra-stress user profile=/tmp/cs_no_mv_basic_profile.yaml ops'(insert=1)' cl=QUORUM duration=30m -pop seq=1..10000000 -port jmx=6868 -mode cql3 native -rate threads=100\"\n+stress_cmd_no_mv_profile: 'data_dir/cs_no_mv_basic_profile.yaml'\n+stress_cmd_mv:\n+  - cmd: \"cassandra-stress user profile=/tmp/cs_mv_basic_profile_by_id_firstname.yaml ops'(insert=1)' cl=QUORUM duration=5m -pop seq=10000000..20000000 -port jmx=6868 -mode cql3 native -rate threads=100\"\n+    profile: 'data_dir/cs_mv_basic_profile_by_id_firstname.yaml'\n+  - cmd: \"cassandra-stress user profile=/tmp/cs_mv_basic_profile_by_firstname_id.yaml ops'(insert=1)' cl=QUORUM duration=5m -pop seq=20000000..30000000 -port jmx=6868 -mode cql3 native -rate threads=100\"\n+    profile: 'data_dir/cs_mv_basic_profile_by_firstname_id.yaml'\n+n_db_nodes: 4\n+n_loaders: 4\n+n_monitor_nodes: 1\n+#user_prefix: 'perf-regression-mv'\n+user_prefix: 'perf-regression-mv-VERSION'\n+failure_post_behavior: keep\n+space_node_threshold: 6442450\n+ip_ssh_connections: 'public'\n+experimental: 'true'\n+\n+backends: !mux\n+    gce: !mux\n+        cluster_backend: 'gce'\n+        user_credentials_path: '~/.ssh/scylla-test'\n+        gce_user_credentials: '~/Scylla-c41b78923a54.json'\n+        gce_service_account_email: 'skilled-adapter-452@appspot.gserviceaccount.com'\n+        gce_project: 'skilled-adapter-452'\n+        gce_network: 'qa-vpc'\n+        gce_image: 'https://www.googleapis.com/compute/v1/projects/centos-cloud/global/images/family/centos-7'\n+        gce_image_username: 'scylla-test'\n+        gce_instance_type_db: 'n1-highmem-16'\n+        gce_root_disk_type_db: 'pd-ssd'\n+        gce_root_disk_size_db: 50\n+        gce_n_local_ssd_disk_db: 8\n+        gce_instance_type_loader: 'n1-highmem-8'\n+        gce_root_disk_type_loader: 'pd-standard'\n+        gce_n_local_ssd_disk_loader: 0\n+        gce_instance_type_monitor: 'n1-standard-4'\n+        gce_root_disk_type_monitor: 'pd-ssd'\n+        gce_root_disk_size_monitor: 50\n+        gce_n_local_ssd_disk_monitor: 0\n+#        scylla_repo: 'https://s3.amazonaws.com/downloads.scylladb.com/rpm/unstable/centos/c4af043ef720901248a4c327d923699f5bb8103c-1910a0080048fa342c7d65b2556d8a367bcf24d3-9215bf9e716e3ac9910458ce7e92a6e1a7d91079/21/scylla.repo'\n+        scylla_repo: 'REPO_FILE_PATH'\n+        us_east_1:\n+          gce_datacenter: 'us-east1-b'\n+    aws: !mux\n+        cluster_backend: 'aws'\n+        instance_type_loader: 'c4.8xlarge'\n+        instance_type_monitor: 'c4.2xlarge'\n+        instance_type_db: 'i3.8xlarge'","path":"tests/perf-regression-2mv.yaml","position":48,"original_position":48,"commit_id":"138f4e99bc4f69ec4eee31699be87cf61a890f4e","original_commit_id":"138f4e99bc4f69ec4eee31699be87cf61a890f4e","user":{"login":"roydahan","id":20959584,"avatar_url":"https://avatars3.githubusercontent.com/u/20959584?v=4","gravatar_id":"","url":"https://api.github.com/users/roydahan","html_url":"https://github.com/roydahan","followers_url":"https://api.github.com/users/roydahan/followers","following_url":"https://api.github.com/users/roydahan/following{/other_user}","gists_url":"https://api.github.com/users/roydahan/gists{/gist_id}","starred_url":"https://api.github.com/users/roydahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roydahan/subscriptions","organizations_url":"https://api.github.com/users/roydahan/orgs","repos_url":"https://api.github.com/users/roydahan/repos","events_url":"https://api.github.com/users/roydahan/events{/privacy}","received_events_url":"https://api.github.com/users/roydahan/received_events","type":"User","site_admin":false},"body":"please change to i3.4xlarge and check the CPU utlization with it","created_at":"2018-05-21T13:40:44Z","updated_at":"2018-05-21T13:49:52Z","html_url":"https://github.com/scylladb/scylla-cluster-tests/pull/559#discussion_r189591761","pull_request_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/comments/189591761"},"html":{"href":"https://github.com/scylladb/scylla-cluster-tests/pull/559#discussion_r189591761"},"pull_request":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559"}}},"pull_request":{"url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559","id":186284472,"html_url":"https://github.com/scylladb/scylla-cluster-tests/pull/559","diff_url":"https://github.com/scylladb/scylla-cluster-tests/pull/559.diff","patch_url":"https://github.com/scylladb/scylla-cluster-tests/pull/559.patch","issue_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues/559","number":559,"state":"open","locked":false,"title":"Mv performance tests","user":{"login":"juliayakovlev","id":34435448,"avatar_url":"https://avatars1.githubusercontent.com/u/34435448?v=4","gravatar_id":"","url":"https://api.github.com/users/juliayakovlev","html_url":"https://github.com/juliayakovlev","followers_url":"https://api.github.com/users/juliayakovlev/followers","following_url":"https://api.github.com/users/juliayakovlev/following{/other_user}","gists_url":"https://api.github.com/users/juliayakovlev/gists{/gist_id}","starred_url":"https://api.github.com/users/juliayakovlev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juliayakovlev/subscriptions","organizations_url":"https://api.github.com/users/juliayakovlev/orgs","repos_url":"https://api.github.com/users/juliayakovlev/repos","events_url":"https://api.github.com/users/juliayakovlev/events{/privacy}","received_events_url":"https://api.github.com/users/juliayakovlev/received_events","type":"User","site_admin":false},"body":"1. New function test_mv that runs performance test profile with materialized view\r\n2. MV performance test profile (test will take 90 min): \r\n   - create table without MV and run inserts for 30 min\r\n   - create first MV and run insert a for 30 min\r\n   - drop first MV\r\n   - create second MV (with different partition key) and run insert a for 30 min","created_at":"2018-05-07T08:16:27Z","updated_at":"2018-05-21T13:49:52Z","closed_at":null,"merged_at":null,"merge_commit_sha":"5014c3c65ddc21617f7505f074a576b5ed4911fc","assignee":null,"assignees":[],"requested_reviewers":[{"login":"amoskong","id":309708,"avatar_url":"https://avatars0.githubusercontent.com/u/309708?v=4","gravatar_id":"","url":"https://api.github.com/users/amoskong","html_url":"https://github.com/amoskong","followers_url":"https://api.github.com/users/amoskong/followers","following_url":"https://api.github.com/users/amoskong/following{/other_user}","gists_url":"https://api.github.com/users/amoskong/gists{/gist_id}","starred_url":"https://api.github.com/users/amoskong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amoskong/subscriptions","organizations_url":"https://api.github.com/users/amoskong/orgs","repos_url":"https://api.github.com/users/amoskong/repos","events_url":"https://api.github.com/users/amoskong/events{/privacy}","received_events_url":"https://api.github.com/users/amoskong/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559/commits","review_comments_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559/comments","review_comment_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/comments{/number}","comments_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues/559/comments","statuses_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/statuses/138f4e99bc4f69ec4eee31699be87cf61a890f4e","head":{"label":"juliayakovlev:mv_performance_tests","ref":"mv_performance_tests","sha":"138f4e99bc4f69ec4eee31699be87cf61a890f4e","user":{"login":"juliayakovlev","id":34435448,"avatar_url":"https://avatars1.githubusercontent.com/u/34435448?v=4","gravatar_id":"","url":"https://api.github.com/users/juliayakovlev","html_url":"https://github.com/juliayakovlev","followers_url":"https://api.github.com/users/juliayakovlev/followers","following_url":"https://api.github.com/users/juliayakovlev/following{/other_user}","gists_url":"https://api.github.com/users/juliayakovlev/gists{/gist_id}","starred_url":"https://api.github.com/users/juliayakovlev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juliayakovlev/subscriptions","organizations_url":"https://api.github.com/users/juliayakovlev/orgs","repos_url":"https://api.github.com/users/juliayakovlev/repos","events_url":"https://api.github.com/users/juliayakovlev/events{/privacy}","received_events_url":"https://api.github.com/users/juliayakovlev/received_events","type":"User","site_admin":false},"repo":{"id":129606114,"name":"scylla-cluster-tests","full_name":"juliayakovlev/scylla-cluster-tests","owner":{"login":"juliayakovlev","id":34435448,"avatar_url":"https://avatars1.githubusercontent.com/u/34435448?v=4","gravatar_id":"","url":"https://api.github.com/users/juliayakovlev","html_url":"https://github.com/juliayakovlev","followers_url":"https://api.github.com/users/juliayakovlev/followers","following_url":"https://api.github.com/users/juliayakovlev/following{/other_user}","gists_url":"https://api.github.com/users/juliayakovlev/gists{/gist_id}","starred_url":"https://api.github.com/users/juliayakovlev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juliayakovlev/subscriptions","organizations_url":"https://api.github.com/users/juliayakovlev/orgs","repos_url":"https://api.github.com/users/juliayakovlev/repos","events_url":"https://api.github.com/users/juliayakovlev/events{/privacy}","received_events_url":"https://api.github.com/users/juliayakovlev/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/juliayakovlev/scylla-cluster-tests","description":"Tests for Scylla Clusters","fork":true,"url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests","forks_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/forks","keys_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/keys{/key_id}","collaborators_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/teams","hooks_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/hooks","issue_events_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/issues/events{/number}","events_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/events","assignees_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/assignees{/user}","branches_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/branches{/branch}","tags_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/tags","blobs_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/git/refs{/sha}","trees_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/git/trees{/sha}","statuses_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/statuses/{sha}","languages_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/languages","stargazers_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/stargazers","contributors_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/contributors","subscribers_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/subscribers","subscription_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/subscription","commits_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/commits{/sha}","git_commits_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/git/commits{/sha}","comments_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/comments{/number}","issue_comment_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/issues/comments{/number}","contents_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/contents/{+path}","compare_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/compare/{base}...{head}","merges_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/merges","archive_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/downloads","issues_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/issues{/number}","pulls_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/pulls{/number}","milestones_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/milestones{/number}","notifications_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/labels{/name}","releases_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/releases{/id}","deployments_url":"https://api.github.com/repos/juliayakovlev/scylla-cluster-tests/deployments","created_at":"2018-04-15T12:04:08Z","updated_at":"2018-04-15T12:04:10Z","pushed_at":"2018-05-21T08:35:19Z","git_url":"git://github.com/juliayakovlev/scylla-cluster-tests.git","ssh_url":"git@github.com:juliayakovlev/scylla-cluster-tests.git","clone_url":"https://github.com/juliayakovlev/scylla-cluster-tests.git","svn_url":"https://github.com/juliayakovlev/scylla-cluster-tests","homepage":"","size":3648,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0"},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"scylladb:master","ref":"master","sha":"6ba8c615ff2bb81c3b8f6fb49aac63bdb28c6342","user":{"login":"scylladb","id":14364730,"avatar_url":"https://avatars2.githubusercontent.com/u/14364730?v=4","gravatar_id":"","url":"https://api.github.com/users/scylladb","html_url":"https://github.com/scylladb","followers_url":"https://api.github.com/users/scylladb/followers","following_url":"https://api.github.com/users/scylladb/following{/other_user}","gists_url":"https://api.github.com/users/scylladb/gists{/gist_id}","starred_url":"https://api.github.com/users/scylladb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scylladb/subscriptions","organizations_url":"https://api.github.com/users/scylladb/orgs","repos_url":"https://api.github.com/users/scylladb/repos","events_url":"https://api.github.com/users/scylladb/events{/privacy}","received_events_url":"https://api.github.com/users/scylladb/received_events","type":"Organization","site_admin":false},"repo":{"id":48770856,"name":"scylla-cluster-tests","full_name":"scylladb/scylla-cluster-tests","owner":{"login":"scylladb","id":14364730,"avatar_url":"https://avatars2.githubusercontent.com/u/14364730?v=4","gravatar_id":"","url":"https://api.github.com/users/scylladb","html_url":"https://github.com/scylladb","followers_url":"https://api.github.com/users/scylladb/followers","following_url":"https://api.github.com/users/scylladb/following{/other_user}","gists_url":"https://api.github.com/users/scylladb/gists{/gist_id}","starred_url":"https://api.github.com/users/scylladb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scylladb/subscriptions","organizations_url":"https://api.github.com/users/scylladb/orgs","repos_url":"https://api.github.com/users/scylladb/repos","events_url":"https://api.github.com/users/scylladb/events{/privacy}","received_events_url":"https://api.github.com/users/scylladb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/scylladb/scylla-cluster-tests","description":"Tests for Scylla Clusters","fork":false,"url":"https://api.github.com/repos/scylladb/scylla-cluster-tests","forks_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/forks","keys_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/keys{/key_id}","collaborators_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/teams","hooks_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/hooks","issue_events_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues/events{/number}","events_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/events","assignees_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/assignees{/user}","branches_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/branches{/branch}","tags_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/tags","blobs_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/git/refs{/sha}","trees_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/git/trees{/sha}","statuses_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/statuses/{sha}","languages_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/languages","stargazers_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/stargazers","contributors_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/contributors","subscribers_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/subscribers","subscription_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/subscription","commits_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/commits{/sha}","git_commits_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/git/commits{/sha}","comments_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/comments{/number}","issue_comment_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues/comments{/number}","contents_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/contents/{+path}","compare_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/compare/{base}...{head}","merges_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/merges","archive_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/downloads","issues_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues{/number}","pulls_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls{/number}","milestones_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/milestones{/number}","notifications_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/labels{/name}","releases_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/releases{/id}","deployments_url":"https://api.github.com/repos/scylladb/scylla-cluster-tests/deployments","created_at":"2015-12-29T23:03:42Z","updated_at":"2018-05-21T13:24:30Z","pushed_at":"2018-05-21T13:24:27Z","git_url":"git://github.com/scylladb/scylla-cluster-tests.git","ssh_url":"git@github.com:scylladb/scylla-cluster-tests.git","clone_url":"https://github.com/scylladb/scylla-cluster-tests.git","svn_url":"https://github.com/scylladb/scylla-cluster-tests","homepage":"","size":3664,"stargazers_count":18,"watchers_count":18,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":13,"mirror_url":null,"archived":false,"open_issues_count":21,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0"},"forks":13,"open_issues":21,"watchers":18,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559"},"html":{"href":"https://github.com/scylladb/scylla-cluster-tests/pull/559"},"issue":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues/559"},"comments":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/issues/559/comments"},"review_comments":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559/comments"},"review_comment":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/pulls/559/commits"},"statuses":{"href":"https://api.github.com/repos/scylladb/scylla-cluster-tests/statuses/138f4e99bc4f69ec4eee31699be87cf61a890f4e"}},"author_association":"NONE"}}
{"actor":{"display_login":"roydahan"}}