{"id":634,"date":"2015-03-30T09:02:06","date_gmt":"2015-03-30T00:02:06","guid":{"rendered":"http:\/\/nsb.homeip.net\/wp\/?p=634"},"modified":"2015-03-30T09:02:06","modified_gmt":"2015-03-30T00:02:06","slug":"zabbix-2-2-1-%e3%81%a7%e4%bd%bf%e7%94%a8%e3%81%97%e3%81%a6%e3%81%84%e3%82%8bmysql%e3%82%92%e3%83%81%e3%83%a5%e3%83%bc%e3%83%8b%e3%83%b3%e3%82%b0%e3%81%97%e3%81%a6%e3%81%bf%e3%82%8b","status":"publish","type":"post","link":"https:\/\/nsb.homeip.net\/wp\/?p=634","title":{"rendered":"Zabbix 2.2.1 \u3067\u4f7f\u7528\u3057\u3066\u3044\u308bMySQL\u3092\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3057\u3066\u307f\u308b"},"content":{"rendered":"<h3>Zabbix 2.2.1 \u3067\u4f7f\u7528\u3057\u3066\u3044\u308bMySQL\u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u30e1\u30e2<\/h3>\n<pre>[root@zabbix2 ~]# find \/ -name my.cnf\r\n\/etc\/my.cnf\r\n[root@zabbix2 ~]# mysql zabbix\r\nmysql&gt; show variables like \"innodb_%_size\"\r\n-&gt; ;\r\n+---------------------------------+---------+\r\n| Variable_name | Value |\r\n+---------------------------------+---------+\r\n| innodb_additional_mem_pool_size | 1048576 |\r\n| innodb_buffer_pool_size | 8388608 |\r\n| innodb_log_buffer_size | 1048576 |\r\n| innodb_log_file_size | 5242880 |\r\n+---------------------------------+---------+\r\n4 rows in set (0.00 sec)\r\n[root@zabbix2 ~]# service mysqld restart\r\nmysqld \u3092\u505c\u6b62\u4e2d: [ OK ]\r\nmysqld \u3092\u8d77\u52d5\u4e2d: [ OK ]\r\n[root@zabbix2 ~]# service mysqld stop\r\nmysqld \u3092\u505c\u6b62\u4e2d: [ OK ]\r\n[root@zabbix2 ~]# vi \/etc\/my.cnf\r\n[root@zabbix2 ~]#\r\n[root@zabbix2 ~]#\r\n[root@zabbix2 ~]# service mysqld start\r\nmysqld \u3092\u8d77\u52d5\u4e2d: [ OK ]\r\n[root@zabbix2 ~]# mysql\r\nmysql&gt; set global innodb_fast_shutdown=0;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nmysql&gt; Ctrl-C -- exit!\r\nAborted\r\n[root@zabbix2 ~]# service mysqld stop\r\nmysqld \u3092\u505c\u6b62\u4e2d: [ OK ]\r\n[root@zabbix2 ~]# df\r\nFilesystem 1K-\u30d6\u30ed\u30c3\u30af \u4f7f\u7528 \u4f7f\u7528\u53ef \u4f7f\u7528% \u30de\u30a6\u30f3\u30c8\u4f4d\u7f6e\r\n\/dev\/xvda1 18864128 13283108 5581020 71% \/\r\ntmpfs 250736 176 250560 1% \/dev\/shm\r\n[root@zabbix2 ~]# vi \/etc\/my.cnf\r\n\r\n[mysqld]\r\ndatadir=\/var\/lib\/mysql\r\nsocket=\/var\/lib\/mysql\/mysql.sock\r\nuser=mysql\r\n# Disabling symbolic-links is recommended to prevent assorted security risks\r\nsymbolic-links=0\r\ncharacter-set-server=utf8\r\ninnodb_buffer_pool_size=64M\r\ninnodb_log_file_size=32M\r\ninnodb_log_files_in_group=2\r\ninnodb_flush_method=O_DIRECT\r\n[mysqld_safe]\r\nlog-error=\/var\/log\/mysqld.log\r\npid-file=\/var\/run\/mysqld\/mysqld.pid\r\n\r\n[mysqldump]\r\ndefault-character-set=utf8\r\n\r\n[mysql]\r\ndefault-character-set=utf8\r\n[root@zabbix2 ~]# cd \/var\/lib\/mysql\/\r\n[root@zabbix2 mysql]# ls -al\r\n\u5408\u8a08 10235928\r\ndrwxr-xr-x 5 mysql mysql 92 2\u6708 4 15:20 2014 .\r\ndrwxr-xr-x 22 root root 4096 11\u6708 14 23:16 2013 ..\r\n-rw-rw---- 1 mysql mysql 5242880 2\u6708 4 15:20 2014 ib_logfile0\r\n-rw-rw---- 1 mysql mysql 5242880 2\u6708 4 15:20 2014 ib_logfile1\r\n-rw-rw---- 1 mysql mysql 10471079936 2\u6708 4 15:20 2014 ibdata1\r\ndrwx------ 2 mysql mysql 4096 11\u6708 14 22:43 2013 mysql\r\ndrwx------ 2 mysql mysql 6 11\u6708 14 22:43 2013 test\r\ndrwx------ 2 mysql mysql 4096 11\u6708 14 23:39 2013 zabbix\r\n[root@zabbix2 mysql]# rm -f ib_logfile0\r\n[root@zabbix2 mysql]# rm -f ib_logfile1\r\n[root@zabbix2 mysql]#\r\n[root@zabbix2 mysql]# service mysqld start\r\nmysqld \u3092\u8d77\u52d5\u4e2d: [ OK ]\r\n[root@zabbix2 mysql]# ls -al\r\n\u5408\u8a08 10291224\r\ndrwxr-xr-x 5 mysql mysql 109 2\u6708 4 15:56 2014 .\r\ndrwxr-xr-x 22 root root 4096 11\u6708 14 23:16 2013 ..\r\n-rw-rw---- 1 mysql mysql 33554432 2\u6708 4 15:56 2014 ib_logfile0\r\n-rw-rw---- 1 mysql mysql 33554432 2\u6708 4 15:56 2014 ib_logfile1\r\n-rw-rw---- 1 mysql mysql 10471079936 2\u6708 4 15:20 2014 ibdata1\r\ndrwx------ 2 mysql mysql 4096 11\u6708 14 22:43 2013 mysql\r\nsrwxrwxrwx 1 mysql mysql 0 2\u6708 4 15:56 2014 mysql.sock\r\ndrwx------ 2 mysql mysql 6 11\u6708 14 22:43 2013 test\r\ndrwx------ 2 mysql mysql 4096 11\u6708 14 23:39 2013 zabbix\r\n[root@zabbix2 mysql]# service zabbix-server start\r\nStarting Zabbix server: [ OK ]\r\n[root@zabbix2 mysql]#\r\n\r\n[root@zabbix2 mysql]# mysql zabbix\r\nmysql&gt; show variables like \"innodb_%_size\";\r\n+---------------------------------+----------+\r\n| Variable_name | Value |\r\n+---------------------------------+----------+\r\n| innodb_additional_mem_pool_size | 1048576 |\r\n| innodb_buffer_pool_size | 67108864 |\r\n| innodb_log_buffer_size | 1048576 |\r\n| innodb_log_file_size | 33554432 |\r\n+---------------------------------+----------+\r\n4 rows in set (0.00 sec)<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Views: 10<\/p>","protected":false},"excerpt":{"rendered":"<p>Zabbix 2.2.1 \u3067\u4f7f\u7528\u3057\u3066\u3044\u308bMySQL\u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u30e1\u30e2 [root@zabbix2 ~]# find \/ -name my.cnf \/etc\/my.cnf [root@zabbix2 ~]# mysql z &hellip; <a href=\"https:\/\/nsb.homeip.net\/wp\/?p=634\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[11,1],"tags":[24],"class_list":["post-634","post","type-post","status-publish","format-standard","hentry","category-zabbix","category-1","tag-mysql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=634"}],"version-history":[{"count":0,"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/634\/revisions"}],"wp:attachment":[{"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nsb.homeip.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}