)]}'
{"id":"openstack%2Fdevstack~883970","triplet_id":"openstack%2Fdevstack~stable%2Fyoga~I7b223391d3de01e3e81b02076debd01d9d2f097c","project":"openstack/devstack","branch":"stable/yoga","topic":"mysql-mem","attention_set":{},"removed_from_attention_set":{"17685":{"account":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"last_update":"2023-05-30 20:18:13.000000000","reason":"Change was submitted"},"4393":{"account":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"last_update":"2023-05-30 20:18:13.000000000","reason":"Change was submitted"},"8556":{"account":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"last_update":"2023-05-23 22:09:38.000000000","reason":"\u003cGERRIT_ACCOUNT_8556\u003e replied on the change","reason_account":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"}}},"hashtags":[],"change_id":"I7b223391d3de01e3e81b02076debd01d9d2f097c","subject":"Try to reduce mysql memory usage","status":"MERGED","created":"2023-05-23 18:22:47.000000000","updated":"2023-05-30 20:20:12.000000000","submitted":"2023-05-30 20:18:13.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"883970-mysql-mem","meta_rev_id":"e881154602ee4c88b7dbc0285f2a453e94c5f721","_number":883970,"virtual_id_number":883970,"owner":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},{"value":0,"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-05-30 20:18:13.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"recommended":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"all":[{"value":1,"date":"2023-05-30 18:11:39.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":2,"date":"2023-05-30 18:13:55.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},{"value":2,"date":"2023-05-23 22:09:38.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","value":1,"default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":1,"date":"2023-05-30 18:13:55.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},{"value":0,"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},{"value":0,"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}],"reviewers":{"REVIEWER":[{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-05-23 19:51:43.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2023-05-23 19:54:40.000000000","updated_by":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"reviewer":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"state":"REVIEWER"},{"updated":"2023-05-23 19:54:40.000000000","updated_by":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"reviewer":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"state":"REVIEWER"},{"updated":"2023-05-30 18:11:39.000000000","updated_by":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"reviewer":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"state":"REVIEWER"},{"updated":"2023-05-30 18:13:55.000000000","updated_by":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"reviewer":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"state":"REVIEWER"}],"messages":[{"id":"b662e890d52408eb228b078c339e7ce07a5447e9","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"date":"2023-05-23 18:22:47.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"3c4b3a515b0cc8bf197e26080666c5e2935fe7fc","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-23 19:51:43.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0f42b524b8d14ce7a22bfadad3a2985e\n\n- grenade https://zuul.opendev.org/t/openstack/build/f64e0aaf70b84cb5904d74d6b36fd2a4 : SUCCESS in 48m 32s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/f81742915f2647e6bce9e8557b14922b : SUCCESS in 1h 12m 01s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/084a6c705afd49528c9481252cf87cef : SUCCESS in 5m 10s\n- devstack https://zuul.opendev.org/t/openstack/build/24b1f3f7df6748f5a2d770c52f8a6887 : SUCCESS in 21m 30s\n- devstack-ipv6 https://zuul.opendev.org/t/openstack/build/525bd1938bdb46788d6bda7964f54a34 : SUCCESS in 23m 02s\n- devstack-enforce-scope https://zuul.opendev.org/t/openstack/build/c16279f776424f21bb348ca33b8ed6de : SUCCESS in 21m 28s\n- devstack-platform-debian-bullseye https://zuul.opendev.org/t/openstack/build/1084a8c94fc6411f8c7b9572d2d7f19c : SUCCESS in 1h 06m 04s (non-voting)\n- devstack-multinode https://zuul.opendev.org/t/openstack/build/1fe51d0660ae435f9e85f8120bd250b6 : SUCCESS in 33m 31s\n- devstack-unit-tests https://zuul.opendev.org/t/openstack/build/4b704fa9dcec41feac94979eea456a6e : SUCCESS in 3m 55s\n- openstack-tox-bashate https://zuul.opendev.org/t/openstack/build/36a13e07d9f84fe9b9fab7fa5f63ed8a : SUCCESS in 2m 05s\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/f697b8d346ee4496bc2e9332a8e11d6e : SUCCESS in 1h 03m 46s\n- swift-dsvm-functional https://zuul.opendev.org/t/openstack/build/2ec9e43d375d4685843de42963ccbd70 : SUCCESS in 38m 43s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/33d1e65a5b64414496458182f2f4dbb5 : SUCCESS in 46m 52s\n- neutron-linuxbridge-tempest https://zuul.opendev.org/t/openstack/build/d2877101c76541208725c08f5b8cd8ce : SUCCESS in 1h 00m 56s\n- neutron-ovn-tempest-ovs-release https://zuul.opendev.org/t/openstack/build/606a3c6698584592b642cb9a3c9af0a4 : SUCCESS in 1h 04m 57s (non-voting)\n- tempest-multinode-full-py3 https://zuul.opendev.org/t/openstack/build/a6cda63e78784c3483a47126b982ff75 : SUCCESS in 1h 01m 38s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/c3b1e84d5d464fd1baa6e72aa31f69c7 : SUCCESS in 53m 53s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/bfc98d8c8843453095f5ec76cb00a4fe : SUCCESS in 58m 01s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/02158ecc97964a6f9f49d309d9fbcd7c : SUCCESS in 1h 21m 52s","accounts_in_message":[],"_revision_number":1},{"id":"5ae36a2c58bb24c358644189e386647e4f9e952b","author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"date":"2023-05-23 19:55:39.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"7dcc048b659d70bd44abd714d0ad4789379febb1","author":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"date":"2023-05-23 22:09:38.000000000","message":"Patch Set 1: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"29ec7dc4073e77bc605bb9bbe13e603033fadc92","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2023-05-30 18:11:39.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"e2f9b9f63daaf298c7a1dd16d0bbe89532e845df","author":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"date":"2023-05-30 18:13:55.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"feb3057329a169602aa287f52c372354a6938573","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-30 18:14:46.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"17a5b1ec80e916b320d4e72893c23be1105eb9bd","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-30 20:18:13.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/742017b9ffc8499ab786dba3b1a470d1\n\n- grenade https://zuul.opendev.org/t/openstack/build/9cab76d5ab2f45beb0ff8f357484e021 : SUCCESS in 51m 03s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/7dce79a1c40d43779e1477b43c29a76f : SUCCESS in 1h 13m 48s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/965c51c626754f50a1aca7ca0d5e7e3b : SUCCESS in 4m 46s\n- devstack https://zuul.opendev.org/t/openstack/build/d9d639dee3d14e12af2d58df4896c903 : SUCCESS in 23m 07s\n- devstack-ipv6 https://zuul.opendev.org/t/openstack/build/f4cb0513239945c9bd5a911906a31652 : SUCCESS in 21m 01s\n- devstack-enforce-scope https://zuul.opendev.org/t/openstack/build/694b9efe993742439c51078471a27e98 : SUCCESS in 32m 16s\n- devstack-multinode https://zuul.opendev.org/t/openstack/build/604cd39b070b48e4892825df7709a20e : SUCCESS in 35m 35s\n- devstack-unit-tests https://zuul.opendev.org/t/openstack/build/e04580bd20534bc1b643cef2681a8ae5 : SUCCESS in 3m 50s\n- openstack-tox-bashate https://zuul.opendev.org/t/openstack/build/f7d2059793c948768721802e4bdb2dad : SUCCESS in 2m 27s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/19a1bc90af694858bac92f85b9b46eac : SUCCESS in 45m 27s\n- neutron-linuxbridge-tempest https://zuul.opendev.org/t/openstack/build/f2b8e0585e08441e91b5ec425cb3bfd3 : SUCCESS in 51m 29s\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/57de40b80de44cfe8f05f3e84645702d : SUCCESS in 49m 26s\n- swift-dsvm-functional https://zuul.opendev.org/t/openstack/build/f0b42c600b2b4f11b858f05f4eb47d0a : SUCCESS in 41m 05s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/79fcc9e8965648fa9a8c23d47519abdc : SUCCESS in 46m 12s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/ea9bb632b936435bb5143f37b2004d04 : SUCCESS in 46m 11s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/30b1887a5d99474caaffc4f377f43861 : SUCCESS in 1h 06m 11s","accounts_in_message":[],"_revision_number":1},{"id":"361b4f7ce63760b0f4e8d0965aa278bfab155360","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-30 20:18:13.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"e881154602ee4c88b7dbc0285f2a453e94c5f721","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-30 20:20:12.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/a22ec790365845a6a6470b9ba5481e03\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2c29008ad39a4ace94e38eebe6120888 : SUCCESS in 44s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"c4a1f8654826166642880714999b25d00dfe3dfe","revisions":{"c4a1f8654826166642880714999b25d00dfe3dfe":{"kind":"REWORK","_number":1,"created":"2023-05-23 18:22:47.000000000","uploader":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"ref":"refs/changes/70/883970/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/70/883970/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/70/883970/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/70/883970/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/70/883970/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/70/883970/1"}}},"commit":{"parents":[{"commit":"193f3acbf358f42dbe8c764611d0cea53bb1fc5c","subject":"Merge \"git: support git checkout for a commit hash\" into stable/yoga","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/193f3acbf358f42dbe8c764611d0cea53bb1fc5c"}]}],"author":{"name":"Dan Smith","email":"dansmith@redhat.com","date":"2023-02-13 14:41:40.000000000","tz":0},"committer":{"name":"Dan Smith","email":"dansmith@redhat.com","date":"2023-05-23 18:22:35.000000000","tz":-420},"subject":"Try to reduce mysql memory usage","message":"Try to reduce mysql memory usage\n\nThese are a few tweaks I applied to my own memory-constrained cloud\ninstances that seemed to help. I have lower performance requirements\nso this may make things worse and not better, but it\u0027s worth seeing\nwhat the impact is. I\u0027ll admit to not knowing the full impact of these\nas they\u0027re mostly collected from various tutorials on lowering memory\nusage.\n\nEnable this for now on devstack-multinode\n\nChange-Id: I7b223391d3de01e3e81b02076debd01d9d2f097c\n(cherry picked from commit 7567359755a105e7278bbf97541332f28228b87d)\n(cherry picked from commit b12cc4181cd691c121265cf07e274a8021c18754)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/c4a1f8654826166642880714999b25d00dfe3dfe"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/c4a1f8654826166642880714999b25d00dfe3dfe"}]},"branch":"refs/heads/stable/yoga"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dMAX"],"failing_atoms":["label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dMAX"],"failing_atoms":["label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Review-Priority","description":"Review priority","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"-label:Review-Priority\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":[],"failing_atoms":["label:Review-Priority\u003dMIN"],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dMAX"],"failing_atoms":["label:Workflow\u003dMIN"],"atom_explanations":{}}}]}