{"id":1318,"date":"2016-09-08T10:58:48","date_gmt":"2016-09-08T01:58:48","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=1318"},"modified":"2020-05-21T17:47:06","modified_gmt":"2020-05-21T08:47:06","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%83%95%e3%82%a3%e3%83%ab%e3%82%bf%e3%83%bc%e3%81%8c%e6%a9%9f%e8%83%bd%e3%81%97%e3%81%aa%e3%81%84mysql","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=1318","title":{"rendered":"\u3010\u4e0d\u5177\u5408\u3011\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u6a5f\u80fd\u3057\u306a\u3044(MySQL)"},"content":{"rendered":"<p><strong>[\u4e8b\u8c61]<\/strong><\/p>\n[\u8a2d\u5b9a] -&gt; [\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a3\u30eb\u30bf\u30fc]\u304b\u3089\u8a2d\u5b9a\u53ef\u80fd\u306a<a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=1163\" target=\"_blank\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a3\u30eb\u30bf\u30fc<\/a>\u306b\u3066<br \/>\n\u6761\u4ef6\u306b\u65e5\u672c\u8a9e\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u6587\u5b57\u30b3\u30fc\u30c9\u304c\u6b63\u3057\u304f\u8aad\u307f\u8fbc\u307e\u308c\u306a\u3044\u3053\u3068\u3067<br \/>\n\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u6a5f\u80fd\u3057\u306a\u3044\u3068\u3044\u3046\u4e0d\u5177\u5408\u304c\u3054\u3056\u3044\u307e\u3059\u3002<\/p>\n<p><strong>[\u5bfe\u8c61]<\/strong><\/p>\n<p>MySQL\u304c\u4f7f\u7528\u3055\u308c\u3066\u3044\u308bEventLog Analyzer<\/p>\n<p><strong>[\u56de\u907f\u7b56]<\/strong><\/p>\n<p>\u672c\u4e8b\u8c61\u306b\u3064\u304d\u307e\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u304b\u3089\u30a8\u30f3\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3044\u305f\u3060\u304f\u3053\u3068\u3067<br \/>\n\u4fee\u6b63\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u624b\u9806\uff1a<\/p>\n<p>1\uff0e[\u8a2d\u5b9a]-&gt;[\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9]\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30a8\u30ea\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001<br \/>\n\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<br \/>\n<strong> show create table laexpression<\/strong><\/p>\n<p>\u51fa\u529b\u7d50\u679c\u306b\u4ee5\u4e0b\u306e\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002<br \/>\n<strong>DEFAULT CHARSET=utf8<\/strong><\/p>\n<p>2\uff0e\"&lt;ELA_Home&gt;\\conf\\database_params.conf\"\u3092\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u958b\u304d\u307e\u3059\u3002<br \/>\n\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u304c\"ISO-8859-1\"\u3068\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\"UTF8\"\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<br \/>\n&lt;\u4fee\u6b63\u524d&gt;<\/p>\n<blockquote><p>url=jdbc:mysql:\/\/localhost:33335\/eventlog?useUnicode=false&amp;characterEncoding=<strong><span style=\"color: red\">ISO-8859-1<\/span><\/strong>&amp;zeroDateTimeBehavior=convertToNull<\/p><\/blockquote>\n<p>&lt;\u4fee\u6b63\u5f8c&gt;<\/p>\n<blockquote><p>url=jdbc:mysql:\/\/localhost:33335\/eventlog?useUnicode=false&amp;characterEncoding=<strong><span style=\"color: red\">UTF8<\/span><\/strong>&amp;zeroDateTimeBehavior=convertToNull<\/p><\/blockquote>\n<p>3\uff0e\"&lt;ELA_Home&gt;\\bin\\startDB.bat\"\u3092\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u958b\u304d\u3001\u592a\u6587\u5b57\u90e8\u5206\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<blockquote><p>if \"%DB_PORT%x\" == \"x\" set DB_PORT=33335<\/p>\n<p>@start \"MySQL\" \/B %DB_HOME%\\bin\\mysqld-nt --standalone --basedir=%DB_HOME% --port=%DB_PORT% --datadir=%DB_HOME%\\data --innodb_buffer_pool_size=180M --innodb_file_per_table --innodb_flush_log_at_trx_commit=0 --log-error <strong>--default-character-set=utf8<\/strong><\/p><\/blockquote>\n<p>4\uff0eEventLog Analyzer\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u624b\u9806\u306f\u4ee5\u4e0a\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[\u4e8b\u8c61] [\u8a2d\u5b9a] -&gt; [\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a3\u30eb\u30bf\u30fc]\u304b\u3089\u8a2d\u5b9a\u53ef\u80fd\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a3\u30eb\u30bf\u30fc\u306b\u3066 \u6761\u4ef6\u306b\u65e5\u672c\u8a9e\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u6587\u5b57\u30b3\u30fc\u30c9\u304c\u6b63\u3057\u304f\u8aad\u307f\u2026 <a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=1318\" class=\"more\">\uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[14],"tags":[301,232,233,219,231],"class_list":["post-1318","post","type-post","status-publish","format-standard","hentry","category-knownissue-ela","tag-all","tag-db","tag-233","tag-db-filter","tag-231"],"modified_by":null,"_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts\/1318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1318"}],"version-history":[{"count":18,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts\/1318\/revisions"}],"predecessor-version":[{"id":4019,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts\/1318\/revisions\/4019"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}