{"action":"created","issue":{"url":"https://api.github.com/repos/turnkeylinux/tracker/issues/1051","repository_url":"https://api.github.com/repos/turnkeylinux/tracker","labels_url":"https://api.github.com/repos/turnkeylinux/tracker/issues/1051/labels{/name}","comments_url":"https://api.github.com/repos/turnkeylinux/tracker/issues/1051/comments","events_url":"https://api.github.com/repos/turnkeylinux/tracker/issues/1051/events","html_url":"https://github.com/turnkeylinux/tracker/issues/1051","id":315779972,"number":1051,"title":"Update mysqltuner script in common (included in all MySQL apps, inc LAMP apps)","user":{"login":"JedMeister","id":818633,"avatar_url":"https://avatars1.githubusercontent.com/u/818633?v=4","gravatar_id":"","url":"https://api.github.com/users/JedMeister","html_url":"https://github.com/JedMeister","followers_url":"https://api.github.com/users/JedMeister/followers","following_url":"https://api.github.com/users/JedMeister/following{/other_user}","gists_url":"https://api.github.com/users/JedMeister/gists{/gist_id}","starred_url":"https://api.github.com/users/JedMeister/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JedMeister/subscriptions","organizations_url":"https://api.github.com/users/JedMeister/orgs","repos_url":"https://api.github.com/users/JedMeister/repos","events_url":"https://api.github.com/users/JedMeister/events{/privacy}","received_events_url":"https://api.github.com/users/JedMeister/received_events","type":"User","site_admin":false},"labels":[{"id":43447465,"url":"https://api.github.com/repos/turnkeylinux/tracker/labels/bug","name":"bug","color":"fc2929","default":true},{"id":68746143,"url":"https://api.github.com/repos/turnkeylinux/tracker/labels/lamp","name":"lamp","color":"eb6420","default":false},{"id":51071266,"url":"https://api.github.com/repos/turnkeylinux/tracker/labels/mysql","name":"mysql","color":"eb6420","default":false}],"state":"open","locked":false,"assignee":{"login":"spaghettimaster","id":2176398,"avatar_url":"https://avatars2.githubusercontent.com/u/2176398?v=4","gravatar_id":"","url":"https://api.github.com/users/spaghettimaster","html_url":"https://github.com/spaghettimaster","followers_url":"https://api.github.com/users/spaghettimaster/followers","following_url":"https://api.github.com/users/spaghettimaster/following{/other_user}","gists_url":"https://api.github.com/users/spaghettimaster/gists{/gist_id}","starred_url":"https://api.github.com/users/spaghettimaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spaghettimaster/subscriptions","organizations_url":"https://api.github.com/users/spaghettimaster/orgs","repos_url":"https://api.github.com/users/spaghettimaster/repos","events_url":"https://api.github.com/users/spaghettimaster/events{/privacy}","received_events_url":"https://api.github.com/users/spaghettimaster/received_events","type":"User","site_admin":false},"assignees":[{"login":"spaghettimaster","id":2176398,"avatar_url":"https://avatars2.githubusercontent.com/u/2176398?v=4","gravatar_id":"","url":"https://api.github.com/users/spaghettimaster","html_url":"https://github.com/spaghettimaster","followers_url":"https://api.github.com/users/spaghettimaster/followers","following_url":"https://api.github.com/users/spaghettimaster/following{/other_user}","gists_url":"https://api.github.com/users/spaghettimaster/gists{/gist_id}","starred_url":"https://api.github.com/users/spaghettimaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spaghettimaster/subscriptions","organizations_url":"https://api.github.com/users/spaghettimaster/orgs","repos_url":"https://api.github.com/users/spaghettimaster/repos","events_url":"https://api.github.com/users/spaghettimaster/events{/privacy}","received_events_url":"https://api.github.com/users/spaghettimaster/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/turnkeylinux/tracker/milestones/17","html_url":"https://github.com/turnkeylinux/tracker/milestone/17","labels_url":"https://api.github.com/repos/turnkeylinux/tracker/milestones/17/labels","id":2595476,"number":17,"title":"15.0","description":"","creator":{"login":"JedMeister","id":818633,"avatar_url":"https://avatars1.githubusercontent.com/u/818633?v=4","gravatar_id":"","url":"https://api.github.com/users/JedMeister","html_url":"https://github.com/JedMeister","followers_url":"https://api.github.com/users/JedMeister/followers","following_url":"https://api.github.com/users/JedMeister/following{/other_user}","gists_url":"https://api.github.com/users/JedMeister/gists{/gist_id}","starred_url":"https://api.github.com/users/JedMeister/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JedMeister/subscriptions","organizations_url":"https://api.github.com/users/JedMeister/orgs","repos_url":"https://api.github.com/users/JedMeister/repos","events_url":"https://api.github.com/users/JedMeister/events{/privacy}","received_events_url":"https://api.github.com/users/JedMeister/received_events","type":"User","site_admin":false},"open_issues":105,"closed_issues":58,"state":"open","created_at":"2017-06-21T08:52:59Z","updated_at":"2018-04-21T06:28:48Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2018-04-19T08:42:14Z","updated_at":"2018-04-22T02:51:12Z","closed_at":null,"author_association":"OWNER","body":"I just noticed that there is a really old (v1.2.0 added Jan 2012; current version is v1.7.9 - April 2018) version of mysqltuner script bundled as part of the [mysql-overlay](https://github.com/turnkeylinux/common/tree/master/overlays/mysql) (in common). I.e. all appliances that include the [mysql.mk](https://github.com/turnkeylinux/common/blob/master/mk/turnkey/mysql.mk) (inc [lamp.mk](https://github.com/turnkeylinux/common/blob/master/mk/turnkey/lamp.mk#L7)) - see https://github.com/turnkeylinux/common/blob/master/overlays/mysql/usr/local/bin/mysqltuner\r\n\r\nWe should at the very least be installing a newer version. Although actually, we would be better off downloading it at build time IMO! Then it will get updated on rebuild.\r\n\r\nSo what needs to happen is remove the file from the mysql overlay and edit the [mysql conf](https://github.com/turnkeylinux/common/blob/master/conf/mysql) to include this (or similar):\r\n```\r\nwget http://mysqltuner.pl -O /usr/local/bin/mysqltuner\r\nchmod +x /usr/local/bin/mysqltuner\r\n```\r\nWe should possibly at least include a link to the [docs](https://github.com/major/MySQLTuner-perl/blob/master/INTERNALS.md) for it somewhere, although perhaps we should include that file in the build too?"},"comment":{"url":"https://api.github.com/repos/turnkeylinux/tracker/issues/comments/383351188","html_url":"https://github.com/turnkeylinux/tracker/issues/1051#issuecomment-383351188","issue_url":"https://api.github.com/repos/turnkeylinux/tracker/issues/1051","id":383351188,"user":{"login":"spaghettimaster","id":2176398,"avatar_url":"https://avatars2.githubusercontent.com/u/2176398?v=4","gravatar_id":"","url":"https://api.github.com/users/spaghettimaster","html_url":"https://github.com/spaghettimaster","followers_url":"https://api.github.com/users/spaghettimaster/followers","following_url":"https://api.github.com/users/spaghettimaster/following{/other_user}","gists_url":"https://api.github.com/users/spaghettimaster/gists{/gist_id}","starred_url":"https://api.github.com/users/spaghettimaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spaghettimaster/subscriptions","organizations_url":"https://api.github.com/users/spaghettimaster/orgs","repos_url":"https://api.github.com/users/spaghettimaster/repos","events_url":"https://api.github.com/users/spaghettimaster/events{/privacy}","received_events_url":"https://api.github.com/users/spaghettimaster/received_events","type":"User","site_admin":false},"created_at":"2018-04-22T02:51:12Z","updated_at":"2018-04-22T02:51:12Z","author_association":"MEMBER","body":"Done!\r\nhttps://github.com/turnkeylinux/common/pull/120"}}
{"actor":{"display_login":"spaghettimaster"}}