{"action":"created","issue":{"url":"https://api.github.com/repos/firehol/netdata/issues/1454","repository_url":"https://api.github.com/repos/firehol/netdata","labels_url":"https://api.github.com/repos/firehol/netdata/issues/1454/labels{/name}","comments_url":"https://api.github.com/repos/firehol/netdata/issues/1454/comments","events_url":"https://api.github.com/repos/firehol/netdata/issues/1454/events","html_url":"https://github.com/firehol/netdata/issues/1454","id":197680839,"number":1454,"title":"YOUR HELP NEEDED: define mysql/mariadb alarms in netdata","user":{"login":"ktsaou","id":2662304,"avatar_url":"https://avatars.githubusercontent.com/u/2662304?v=3","gravatar_id":"","url":"https://api.github.com/users/ktsaou","html_url":"https://github.com/ktsaou","followers_url":"https://api.github.com/users/ktsaou/followers","following_url":"https://api.github.com/users/ktsaou/following{/other_user}","gists_url":"https://api.github.com/users/ktsaou/gists{/gist_id}","starred_url":"https://api.github.com/users/ktsaou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ktsaou/subscriptions","organizations_url":"https://api.github.com/users/ktsaou/orgs","repos_url":"https://api.github.com/users/ktsaou/repos","events_url":"https://api.github.com/users/ktsaou/events{/privacy}","received_events_url":"https://api.github.com/users/ktsaou/received_events","type":"User","site_admin":false},"labels":[{"id":360861569,"url":"https://api.github.com/repos/firehol/netdata/labels/your%20help%20needed","name":"your help needed","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-12-27T10:19:20Z","updated_at":"2016-12-29T15:23:24Z","closed_at":null,"body":"If you use **mysql** or **mariadb** in a production environment, please help me identify the alarms netdata should have to ensure you have a healthy database installation.\r\n\r\nJust post here your needs - I'll try to build alarms to satisfy them. I only expect from you to help me figure them out and test them once we have them.\r\n"},"comment":{"url":"https://api.github.com/repos/firehol/netdata/issues/comments/269645084","html_url":"https://github.com/firehol/netdata/issues/1454#issuecomment-269645084","issue_url":"https://api.github.com/repos/firehol/netdata/issues/1454","id":269645084,"user":{"login":"ktsaou","id":2662304,"avatar_url":"https://avatars.githubusercontent.com/u/2662304?v=3","gravatar_id":"","url":"https://api.github.com/users/ktsaou","html_url":"https://github.com/ktsaou","followers_url":"https://api.github.com/users/ktsaou/followers","following_url":"https://api.github.com/users/ktsaou/following{/other_user}","gists_url":"https://api.github.com/users/ktsaou/gists{/gist_id}","starred_url":"https://api.github.com/users/ktsaou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ktsaou/subscriptions","organizations_url":"https://api.github.com/users/ktsaou/orgs","repos_url":"https://api.github.com/users/ktsaou/repos","events_url":"https://api.github.com/users/ktsaou/events{/privacy}","received_events_url":"https://api.github.com/users/ktsaou/received_events","type":"User","site_admin":false},"created_at":"2016-12-29T15:23:24Z","updated_at":"2016-12-29T15:23:24Z","body":"ok, let me check:\r\n\r\n## slow queries\r\n\r\n![image](https://cloud.githubusercontent.com/assets/2662304/21546723/83dfd37e-cde9-11e6-9218-fcd000eeab04.png)\r\n\r\nYou suggest ` > 10`.\r\n\r\nWould that be:\r\n\r\n1. warning when `sum of slow queries over the last 10 seconds > 10`\r\n2. critical when `sum of slow queries over the last 10 seconds > 20`\r\n\r\n## lock wait\r\n\r\n![image](https://cloud.githubusercontent.com/assets/2662304/21546785/3540e82e-cdea-11e6-9053-96db0aade6cd.png)\r\n\r\nI see on my machine this reaches up to 100:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/2662304/21546747/d6d1f328-cde9-11e6-942d-4ab2b72a8c79.png)\r\n\r\nWould it be better to check for a ratio, like `abs(waited) * 100 / (immediate + abs(waited)) > 20` as an average over the last 10 seconds?\r\n\r\nI would suggest `warn > 20%`, `critical > 50%`.\r\n\r\n## threads connected\r\n\r\n![image](https://cloud.githubusercontent.com/assets/2662304/21546882/12311dc6-cdeb-11e6-9bee-564a8aa0164f.png)\r\n\r\nhm... I have 3 times the threshold of ServerDensity on my server.\r\nHow that can be a static number?\r\n\r\n\r\n"}}
{"actor":{"display_login":"ktsaou"}}