MariaDB 10.1 still ships the tool "mysql_zap.sh" on the "scripts/" directory.
This tool basically does what the "pkill" tool does with the "-f" switch : killing processes whose name match a certain string.
The way the script match the processes it needs to kill isnt clean (using the output of a "ps" command), it outputs an stty error message when executed, doesnt output any warning after trying to kill processes the user doesnt own and waits at least 2 seconds after each kills which renders it unpractical.
The script doesnt seems to be called at any point on the MariaDB sources, doesnt do any MariaDB related job and is most probably not used anymore.
Attachments
Issue Links
relates to
MDEV-9594Document removal of mysql_zap and mysqlbug
serg, please review patch for this task. Did monty agree with this clean-up?
Sorry for stealing it, I assume you don't have it implemented in your tree.
Sergey Vojtovich
added a comment - serg , please review patch for this task. Did monty agree with this clean-up?
Sorry for stealing it, I assume you don't have it implemented in your tree.
A important distinction between pkill and mysql_zap is that mysql_zap kills the server 'gently' first (with signal 15) and only if the server doesn't die in a limited time then tries -9.
To use pkill one must run it twice; pkill --signal 15 mysqld ; sleep(10) ; pkill -f --signal 9 pattern
So in the end, pkill is more cumbersome and slower to use than mysql_zap to kill the mysqld server.
Michael Widenius
added a comment - Just a note:
A important distinction between pkill and mysql_zap is that mysql_zap kills the server 'gently' first (with signal 15) and only if the server doesn't die in a limited time then tries -9.
To use pkill one must run it twice; pkill --signal 15 mysqld ; sleep(10) ; pkill -f --signal 9 pattern
So in the end, pkill is more cumbersome and slower to use than mysql_zap to kill the mysqld server.
People
Sergey Vojtovich
Jean Weisbuch
Votes:
0Vote for this issue
Watchers:
4Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":1501.6999998092651,"ttfb":731.5,"pageVisibility":"visible","entityId":49473,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b32ee4d0-d301-4dcd-b859-b26fd53057e4","navigationType":0,"readyForUser":1569.0999994277954,"redirectCount":0,"resourceLoadedEnd":1693.1999998092651,"resourceLoadedStart":736.8999996185303,"resourceTiming":[{"duration":231.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":736.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":736.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":968.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":231.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":737.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":737.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":968.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":284.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":737.3000001907349,"connectEnd":737.3000001907349,"connectStart":737.3000001907349,"domainLookupEnd":737.3000001907349,"domainLookupStart":737.3000001907349,"fetchStart":737.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":737.3000001907349,"responseEnd":1022.0999994277954,"responseStart":1022.0999994277954,"secureConnectionStart":737.3000001907349},{"duration":337.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":737.5,"connectEnd":737.5,"connectStart":737.5,"domainLookupEnd":737.5,"domainLookupStart":737.5,"fetchStart":737.5,"redirectEnd":0,"redirectStart":0,"requestStart":737.5,"responseEnd":1075.0999994277954,"responseStart":1075.0999994277954,"secureConnectionStart":737.5},{"duration":340.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":737.8999996185303,"connectEnd":737.8999996185303,"connectStart":737.8999996185303,"domainLookupEnd":737.8999996185303,"domainLookupStart":737.8999996185303,"fetchStart":737.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":737.8999996185303,"responseEnd":1078.5999994277954,"responseStart":1078.5999994277954,"secureConnectionStart":737.8999996185303},{"duration":341.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":738.0999994277954,"connectEnd":738.0999994277954,"connectStart":738.0999994277954,"domainLookupEnd":738.0999994277954,"domainLookupStart":738.0999994277954,"fetchStart":738.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":738.0999994277954,"responseEnd":1079.1999998092651,"responseStart":1079.1999998092651,"secureConnectionStart":738.0999994277954},{"duration":341.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":738.3000001907349,"connectEnd":738.3000001907349,"connectStart":738.3000001907349,"domainLookupEnd":738.3000001907349,"domainLookupStart":738.3000001907349,"fetchStart":738.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":738.3000001907349,"responseEnd":1079.5,"responseStart":1079.5,"secureConnectionStart":738.3000001907349},{"duration":427.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":738.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":738.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1166.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":341.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":738.5999994277954,"connectEnd":738.5999994277954,"connectStart":738.5999994277954,"domainLookupEnd":738.5999994277954,"domainLookupStart":738.5999994277954,"fetchStart":738.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":738.5999994277954,"responseEnd":1080,"responseStart":1080,"secureConnectionStart":738.5999994277954},{"duration":427.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":738.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":738.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1166.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":341.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":738.8999996185303,"connectEnd":738.8999996185303,"connectStart":738.8999996185303,"domainLookupEnd":738.8999996185303,"domainLookupStart":738.8999996185303,"fetchStart":738.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":738.8999996185303,"responseEnd":1080.5999994277954,"responseStart":1080.5999994277954,"secureConnectionStart":738.8999996185303},{"duration":557.2999992370605,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":739.8000001907349,"connectEnd":739.8000001907349,"connectStart":739.8000001907349,"domainLookupEnd":739.8000001907349,"domainLookupStart":739.8000001907349,"fetchStart":739.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":739.8000001907349,"responseEnd":1297.0999994277954,"responseStart":1297.0999994277954,"secureConnectionStart":739.8000001907349},{"duration":929.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":744.0999994277954,"connectEnd":744.0999994277954,"connectStart":744.0999994277954,"domainLookupEnd":744.0999994277954,"domainLookupStart":744.0999994277954,"fetchStart":744.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":744.0999994277954,"responseEnd":1673.5999994277954,"responseStart":1673.5999994277954,"secureConnectionStart":744.0999994277954},{"duration":123.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1178.3000001907349,"connectEnd":1178.3000001907349,"connectStart":1178.3000001907349,"domainLookupEnd":1178.3000001907349,"domainLookupStart":1178.3000001907349,"fetchStart":1178.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1178.3000001907349,"responseEnd":1302,"responseStart":1302,"secureConnectionStart":1178.3000001907349},{"duration":254.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1438.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1438.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1693.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":254.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1439,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1439,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1693.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":281.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1439.8999996185303,"connectEnd":1439.8999996185303,"connectStart":1439.8999996185303,"domainLookupEnd":1439.8999996185303,"domainLookupStart":1439.8999996185303,"fetchStart":1439.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1439.8999996185303,"responseEnd":1721.0999994277954,"responseStart":1721.0999994277954,"secureConnectionStart":1439.8999996185303},{"duration":285.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1440.3000001907349,"connectEnd":1440.3000001907349,"connectStart":1440.3000001907349,"domainLookupEnd":1440.3000001907349,"domainLookupStart":1440.3000001907349,"fetchStart":1440.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1440.3000001907349,"responseEnd":1725.8000001907349,"responseStart":1725.8000001907349,"secureConnectionStart":1440.3000001907349},{"duration":286.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/e0bf5781d46ea69fb123572974cf39de-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1440.5999994277954,"connectEnd":1440.5999994277954,"connectStart":1440.5999994277954,"domainLookupEnd":1440.5999994277954,"domainLookupStart":1440.5999994277954,"fetchStart":1440.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":1440.5999994277954,"responseEnd":1727.0999994277954,"responseStart":1727.0999994277954,"secureConnectionStart":1440.5999994277954}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":583,"responseStart":732,"responseEnd":737,"domLoading":735,"domInteractive":1701,"domContentLoadedEventStart":1701,"domContentLoadedEventEnd":1741,"domComplete":1932,"loadEventStart":1932,"loadEventEnd":1933,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1681.0999994277954},{"name":"bigPipe.sidebar-id.end","time":1682},{"name":"bigPipe.activity-panel-pipe-id.start","time":1682.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1683.3999996185303},{"name":"activityTabFullyLoaded","time":1757.1999998092651}],"measures":[],"correlationId":"ea04b18393f2eb","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":10,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Minor
serg, please review patch for this task. Did monty agree with this clean-up?
Sorry for stealing it, I assume you don't have it implemented in your tree.