{"id":2548,"date":"2015-11-21T02:08:51","date_gmt":"2015-11-20T17:08:51","guid":{"rendered":"http:\/\/higherhope.net\/?p=2548"},"modified":"2015-12-13T01:30:03","modified_gmt":"2015-12-12T16:30:03","slug":"zabbix%e3%81%a7mysql%ef%bc%88mariadb%ef%bc%89%e3%81%ae%e3%82%b9%e3%83%86%e3%83%bc%e3%82%bf%e3%82%b9%e3%82%92%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b%e3%80%82","status":"publish","type":"post","link":"https:\/\/higherhope.net\/?p=2548","title":{"rendered":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002"},"content":{"rendered":"

zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u53d6\u5f97\u3092\u3084\u3063\u305f\u306e\u3067\u30e1\u30e2
\n\u5225\u306bmysql\u3068MariaDB\u3067\u306e\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u3067\u306e\u8a2d\u5b9a\u306e\u9055\u3044\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3059\u3002<\/p>\n

\u307e\u305a\u306f\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u306bconf\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n

\n# vim \/etc\/zabbix\/zabbix_agentd.d\/userparameter_mysql.conf<\/p>\n

\u2193\u30b3\u30e1\u30f3\u30c8\u89e3\u9664
\nUserParameter=mysql.status[*],echo “show global status where Variable_name=’$1′;” | HOME=\/var\/lib\/zabbix mysql -N | awk ‘{print $$2}’
\n#\u8ffd\u8a18
\nUserParameter=mysql.size[*],echo “select sum($(case “$3″ in both|””) echo “data_length+index_length”;; data|index) echo “$3_length”;; free) echo “data_free”;; esac)) from information_schema.tables$([[ “$1” = “all” || ! “$1″ ]] || echo ” where table_schema=’$1′”)$([[ “$2” = “all” || ! “$2” ]] || echo “and table_name=’$2′”);” | HOME=\/var\/lib\/zabbix mysql -N
\nUserParameter=mysql.ping,HOME=\/var\/lib\/zabbix mysqladmin ping | grep -c alive
\nUserParameter=mysql.version,mysql -V<\/p><\/blockquote>\n

\u6b21\u306bzabbix agent \u304cmysql\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3048\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n

\n# vim \/var\/lib\/zabbix\/.my.cnf
\n[client]
\nuser = zabbixagent
\npassword = password<\/p><\/blockquote>\n

\u6b21\u306bmysql\uff08MariaDB\uff09\u306bzabbixagent\u30e6\u30fc\u30b6\u30fc\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n

\n# mysql -u root -p
\nuse mysql
\ngrant process on *.* to zabbixagent@localhost identified by ‘password’;
\ngrant REPLICATION CLIENT on *.* to zabbixagent@localhost;
\nshow grants for ‘zabbixagent’@’localhost’;<\/p><\/blockquote>\n

\u6a29\u9650\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n

MariaDB [(none)]> show grants for ‘zabbixagent’@’localhost’;
\n+———————————————————————————————————————-+
\n| Grants for zabbixagent@localhost |
\n+———————————————————————————————————————-+
\n| GRANT PROCESS ON *.* TO ‘zabbixagent’@’localhost’ IDENTIFIED BY PASSWORD ‘*hogehogehogehogehogehoge’ |
\n+———————————————————————————————————————-+\n<\/p><\/blockquote>\n

\u8a2d\u5b9a\u304c\u6b63\u3057\u3044\u304b\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u30b5\u30fc\u30d0\u30fc\u3067\u78ba\u8a8d<\/p>\n

# mysqladmin –defaults-extra-file=\/var\/lib\/zabbix\/.my.cnf ping
\nmysqld is alive<\/p><\/blockquote>\n

\u6b21\u306b\u6b63\u3057\u304fzabbix\u30b5\u30fc\u30d0\u30fc\u5074\u3067\u5024\u304c\u53d6\u308c\u308b\u304b\u78ba\u8a8d<\/p>\n

# zabbix_get -s \u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u306eIP -k mysql.version
\nmysql Ver 15.1 Distrib 10.0.11-MariaDB, for Linux (x86_64) using readline 5.1<\/p><\/blockquote>\n

\u3053\u3053\u307e\u3067\u78ba\u8a8d\u51fa\u6765\u305f\u3089\u6b21\u306fzabbix\u30b5\u30fc\u30d0\u30fc\u5074\u3067\u306egui\u306e\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002
\nzabbix\u306e\u7ba1\u7406\u753b\u9762\u3067\u5bfe\u8c61\u306e\u30b5\u30fc\u30d0\u30fc\u306b\u300cTemplate App MySQL\u300d\u3092\u9069\u7528\u3059\u308c\u3070\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u53d6\u5f97\u3092\u3084\u3063\u305f\u306e\u3067\u30e1\u30e2 \u5225\u306bmysql\u3068MariaDB\u3067\u306e\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u3067\u306e\u8a2d\u5b9a\u306e\u9055\u3044\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3059\u3002 \u307e\u305a\u306f\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u306bconf\u3092\u4f5c\u308a\u307e\u3059\u3002 # vim \/et… Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,134],"tags":[166,135],"class_list":["post-2548","post","type-post","status-publish","format-standard","hentry","category-linux","category-zabbix","tag-linux","tag-zabbix"],"yoast_head":"\nzabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/higherhope.net\/?p=2548\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"og:description\" content=\"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u53d6\u5f97\u3092\u3084\u3063\u305f\u306e\u3067\u30e1\u30e2 \u5225\u306bmysql\u3068MariaDB\u3067\u306e\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u3067\u306e\u8a2d\u5b9a\u306e\u9055\u3044\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3059\u3002 \u307e\u305a\u306f\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u306bconf\u3092\u4f5c\u308a\u307e\u3059\u3002 # vim \/et... Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/higherhope.net\/?p=2548\" \/>\n<meta property=\"og:site_name\" content=\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-20T17:08:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-12-12T16:30:03+00:00\" \/>\n<meta name=\"author\" content=\"higherhope\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:site\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"higherhope\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/higherhope.net\/?p=2548#article\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/?p=2548\"},\"author\":{\"name\":\"higherhope\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"headline\":\"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002\",\"datePublished\":\"2015-11-20T17:08:51+00:00\",\"dateModified\":\"2015-12-12T16:30:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/higherhope.net\/?p=2548\"},\"wordCount\":198,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"keywords\":[\"linux\",\"zabbix\"],\"articleSection\":[\"linux\",\"zabbix\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/higherhope.net\/?p=2548#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/higherhope.net\/?p=2548\",\"url\":\"https:\/\/higherhope.net\/?p=2548\",\"name\":\"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/#website\"},\"datePublished\":\"2015-11-20T17:08:51+00:00\",\"dateModified\":\"2015-12-12T16:30:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/higherhope.net\/?p=2548#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/higherhope.net\/?p=2548\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/higherhope.net\/?p=2548#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/higherhope.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/higherhope.net\/#website\",\"url\":\"https:\/\/higherhope.net\/\",\"name\":\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"description\":\"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002\",\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/higherhope.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\",\"name\":\"higherhope\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"contentUrl\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"width\":700,\"height\":394,\"caption\":\"higherhope\"},\"logo\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/higherhope5963\"],\"url\":\"https:\/\/higherhope.net\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/higherhope.net\/?p=2548","og_locale":"ja_JP","og_type":"article","og_title":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","og_description":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u53d6\u5f97\u3092\u3084\u3063\u305f\u306e\u3067\u30e1\u30e2 \u5225\u306bmysql\u3068MariaDB\u3067\u306e\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u3067\u306e\u8a2d\u5b9a\u306e\u9055\u3044\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3059\u3002 \u307e\u305a\u306f\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u5074\u306bconf\u3092\u4f5c\u308a\u307e\u3059\u3002 # vim \/et... Continue reading →","og_url":"https:\/\/higherhope.net\/?p=2548","og_site_name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","article_published_time":"2015-11-20T17:08:51+00:00","article_modified_time":"2015-12-12T16:30:03+00:00","author":"higherhope","twitter_card":"summary_large_image","twitter_creator":"@higherhope5963","twitter_site":"@higherhope5963","twitter_misc":{"\u57f7\u7b46\u8005":"higherhope","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/higherhope.net\/?p=2548#article","isPartOf":{"@id":"https:\/\/higherhope.net\/?p=2548"},"author":{"name":"higherhope","@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"headline":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002","datePublished":"2015-11-20T17:08:51+00:00","dateModified":"2015-12-12T16:30:03+00:00","mainEntityOfPage":{"@id":"https:\/\/higherhope.net\/?p=2548"},"wordCount":198,"commentCount":0,"publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"keywords":["linux","zabbix"],"articleSection":["linux","zabbix"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/higherhope.net\/?p=2548#respond"]}]},{"@type":"WebPage","@id":"https:\/\/higherhope.net\/?p=2548","url":"https:\/\/higherhope.net\/?p=2548","name":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","isPartOf":{"@id":"https:\/\/higherhope.net\/#website"},"datePublished":"2015-11-20T17:08:51+00:00","dateModified":"2015-12-12T16:30:03+00:00","breadcrumb":{"@id":"https:\/\/higherhope.net\/?p=2548#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/higherhope.net\/?p=2548"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/higherhope.net\/?p=2548#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/higherhope.net\/"},{"@type":"ListItem","position":2,"name":"zabbix\u3067mysql\uff08MariaDB\uff09\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u53d6\u5f97\u3059\u308b\u3002"}]},{"@type":"WebSite","@id":"https:\/\/higherhope.net\/#website","url":"https:\/\/higherhope.net\/","name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","description":"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002","publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/higherhope.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af","name":"higherhope","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/","url":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","contentUrl":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","width":700,"height":394,"caption":"higherhope"},"logo":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/x.com\/higherhope5963"],"url":"https:\/\/higherhope.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/2548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2548"}],"version-history":[{"count":8,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/2548\/revisions"}],"predecessor-version":[{"id":2556,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/2548\/revisions\/2556"}],"wp:attachment":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}