{"id":3229,"date":"2026-08-18T15:55:34","date_gmt":"2026-08-18T06:55:34","guid":{"rendered":"https:\/\/www.blowfish.co.jp\/?p=3229"},"modified":"2026-08-18T15:55:34","modified_gmt":"2026-08-18T06:55:34","slug":"jboss%e5%8b%95%e4%bd%9c%e9%81%85%e5%bb%b6%e3%83%bb%e3%83%a1%e3%83%a2%e3%83%aa%e6%bb%9e%e7%95%99-%e8%aa%bf%e6%9f%bb%e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89%e9%9b%86","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=3229","title":{"rendered":"JBoss\u52d5\u4f5c\u9045\u5ef6\u30fb\u30e1\u30e2\u30ea\u6ede\u7559 \u8abf\u67fb\u30b3\u30de\u30f3\u30c9\u96c6"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\"><\/h1>\n\n\n\n<p>JBoss\uff08+ MySQL\u7b49\u306eRDBMS\uff09\u3067\u69cb\u6210\u3055\u308c\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u300c\u52d5\u4f5c\u304c\u91cd\u3044\u300d\u300c\u30e1\u30e2\u30ea\u4f7f\u7528\u7387\u304c\u4e0a\u304c\u3063\u305f\u307e\u307e\u4e0b\u304c\u3089\u306a\u3044\u300d\u3068\u3044\u3063\u305f\u969c\u5bb3\u304c\u767a\u751f\u3057\u305f\u969b\u306e\u3001\u6c4e\u7528\u7684\u306a\u8abf\u67fb\u30b3\u30de\u30f3\u30c9\u96c6\u3002\u7279\u5b9a\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30fb\u30c6\u30fc\u30d6\u30eb\u540d\u306b\u306f\u4f9d\u5b58\u3057\u306a\u3044\u5f62\u306b\u307e\u3068\u3081\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u63d0<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b5\u30fc\u30d0\u30fc\uff1aJBoss\uff08EAP\/AS\u7cfb\u3002GC\u30ed\u30b0\u30fbserver.log\u306e\u30d1\u30b9\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u69cb\u6210\u306b\u4f9d\u5b58\u3059\u308b\u305f\u3081\u3001\u4ee5\u4e0b\u306f\u4e00\u4f8b\uff09<\/li>\n\n\n\n<li>DB\u30b5\u30fc\u30d0\u30fc\uff1aMySQL\uff085.6\u7cfb\u3092\u60f3\u5b9a\u3057\u305f\u8a18\u6cd5\u3092\u542b\u3080\u304c\u3001\u8003\u3048\u65b9\u81ea\u4f53\u306f5.7\/8.0\u7cfb\u3067\u3082\u6d41\u7528\u53ef\u80fd\uff09<\/li>\n\n\n\n<li>\u969c\u5bb3\u8abf\u67fb\u306f\u57fa\u672c\u7684\u306b\u300c\u4e8b\u5f8c\u8abf\u67fb\u300d\uff08\u65e2\u306bJBoss\u3092\u518d\u8d77\u52d5\u6e08\u307f\u3067\u3001\u5f53\u6642\u306e\u30d7\u30ed\u30bb\u30b9\u72b6\u614b\u306f\u76f4\u63a5\u898b\u3089\u308c\u306a\u3044\u72b6\u614b\uff09\u3092\u524d\u63d0\u3068\u3057\u305f\u5185\u5bb9\u3092\u542b\u3080<\/li>\n\n\n\n<li>\u30b3\u30de\u30f3\u30c9\u4e2d\u306e\u30d1\u30b9\u30fb\u63a5\u7d9a\u60c5\u5831\uff08<code>\/var\/log\/jboss\/<\/code>\u3001<code>\/var\/lib\/mysql\/data\/<\/code>\u3001<code>mysql -u root -p<\/code>\u7b49\uff09\u306f\u74b0\u5883\u3054\u3068\u306b\u8aad\u307f\u66ff\u3048\u308b\u3053\u3068<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b5\u30fc\u30d0\u30fc\uff08JBoss\uff09\u8abf\u67fb<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1-1. \u73fe\u5728\u306eJVM\u8d77\u52d5\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d<\/h3>\n\n\n\n<p>GC\u95a2\u9023\u306eJVM\u30aa\u30d7\u30b7\u30e7\u30f3\uff08PermGen\/Metaspace\u5bfe\u7b56\u3001GC\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u306a\u3069\uff09\u304c\u610f\u56f3\u3057\u305f\u8a2d\u5b9a\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3059\u308b\u3002\u904e\u53bb\u306b\u985e\u4f3c\u969c\u5bb3\u304c\u3042\u308a\u3001\u6052\u4e45\u5bfe\u7b56\u3068\u3057\u3066\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u8ffd\u52a0\u3057\u305f\u3053\u3068\u304c\u3042\u308b\u5834\u5408\u3001\u305d\u308c\u304c\u5b9f\u969b\u306b\u53cd\u6620\u3055\u308c\u3066\u3044\u308b\u304b\u306e\u78ba\u8a8d\u306b\u3082\u4f7f\u3048\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ps aux | grep java | grep -o 'CMSClassUnloadingEnabled\\|UseConcMarkSweepGC\\|MaxPermSize=&#91;0-9A-Za-z]*\\|MaxMetaspaceSize=&#91;0-9A-Za-z]*'<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a\u8d77\u52d5\u4e2d\u306ejava\u30d7\u30ed\u30bb\u30b9\u306e\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u3001\u6307\u5b9a\u3057\u305fJVM\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u6709\u7121\u3092\u62bd\u51fa\u3059\u308b\u3002<code>grep -o<\/code>\u3067\u8a72\u5f53\u30d1\u30bf\u30fc\u30f3\u306b\u30de\u30c3\u30c1\u3057\u305f\u90e8\u5206\u3060\u3051\u3092\u8868\u793a\u3059\u308b\u3002\u78ba\u8a8d\u3057\u305f\u3044\u30aa\u30d7\u30b7\u30e7\u30f3\u540d\u306f\u74b0\u5883\u306b\u5fdc\u3058\u3066<code>|<\/code>\u3067\u8ffd\u52a0\u30fb\u5909\u66f4\u3059\u308b\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MaxPermSize=1G\nUseConcMarkSweepGC\nCMSClassUnloadingEnabled<\/code><\/pre>\n\n\n\n<p>\u2192 \u610f\u56f3\u3057\u305fJVM\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u5b9f\u969b\u306b\u9069\u7528\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">1-2. GC\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u5b58\u5728\u30fb\u66f4\u65b0\u72b6\u6cc1\u306e\u78ba\u8a8d<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ls -la \/var\/log\/jboss\/gc.log*<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1aGC\u30ed\u30b0\u306e\u30d5\u30a1\u30a4\u30eb\u4e00\u89a7\u3068\u30b5\u30a4\u30ba\u30fb\u66f4\u65b0\u65e5\u6642\u3092\u78ba\u8a8d\u3059\u308b\u3002JBoss\u518d\u8d77\u52d5\u5f8c\u306f\u65b0\u3057\u3044\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306b\u5207\u308a\u66ff\u308f\u308b\u8a2d\u5b9a\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u591a\u304f\u3001\u305d\u306e\u5834\u5408\u3001\u518d\u8d77\u52d5\u524d\u306eGC\u72b6\u6cc1\u306f\u3053\u306e\u6642\u70b9\u3067\u306f\u8ffd\u3048\u306a\u3044\u3053\u3068\u304c\u5206\u304b\u308b\uff08\uff1d\u518d\u8d77\u52d5\u524d\u306b\u30ed\u30b0\u3092\u9000\u907f\u3057\u3066\u304a\u304f\u91cd\u8981\u6027\u304c\u5206\u304b\u308b\uff09\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-rw-r--r-- 1 root root 18039  8\u6708 18 13:55 \/var\/log\/jboss\/gc.log.0.current<\/code><\/pre>\n\n\n\n<p>\u2192 \u518d\u8d77\u52d5\u5f8c\u306e\u65b0\u3057\u3044\u30ed\u30b0\u306e\u307f\u5b58\u5728\u3057\u3001\u969c\u5bb3\u767a\u751f\u6642\uff08\u518d\u8d77\u52d5\u524d\uff09\u306eGC\u30ed\u30b0\u306f\u65e2\u306b\u4e0a\u66f8\u304d\u30fb\u6d88\u5931\u3057\u3066\u3044\u308b\u3001\u3068\u3044\u3063\u305f\u72b6\u6cc1\u304c\u5206\u304b\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">1-3. server.log\u304b\u3089\u7279\u5b9a\u6642\u9593\u5e2f\u306e\u30a8\u30e9\u30fc\u30fb\u8b66\u544a\u3092\u62bd\u51fa<\/h3>\n\n\n\n<p>\u969c\u5bb3\u767a\u751f\u6642\u9593\u5e2f\u3092\u7d5e\u308a\u8fbc\u3093\u3067\u30a8\u30e9\u30fc\u30fb\u8b66\u544a\u306e\u307f\u3092\u62bd\u51fa\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grep -n \"12:0&#91;0-9]:\\|12:1&#91;0-9]:\\|12:2&#91;0-4]:\" \/var\/log\/jboss\/server.log | grep -i \"error\\|warn\\|exception\"<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a<code>grep -n<\/code>\u3067\u884c\u756a\u53f7\u4ed8\u304d\u3067\u6642\u523b\u30d1\u30bf\u30fc\u30f3\u306b\u30de\u30c3\u30c1\u3059\u308b\u884c\u3092\u62bd\u51fa\u3057\u3001\u3055\u3089\u306b<code>error<\/code>\/<code>warn<\/code>\/<code>exception<\/code>\u3092\u542b\u3080\u884c\u3060\u3051\u306b\u7d5e\u308a\u8fbc\u3080\u3002\u6642\u523b\u306e\u7bc4\u56f2\u306f\u6b63\u898f\u8868\u73fe\u306e\u6587\u5b57\u30af\u30e9\u30b9\uff08<code>[0-9]<\/code>\u7b49\uff09\u3067\u6307\u5b9a\u3059\u308b\u3002\u8abf\u67fb\u3057\u305f\u3044\u6642\u9593\u5e2f\u306b\u5fdc\u3058\u3066\u30d1\u30bf\u30fc\u30f3\u3092\u5909\u66f4\u3059\u308b\uff08\u4f8b\uff1a13\u6642\u53f0\u306a\u3089<code>13:0[0-9]:<\/code>\u7b49\uff09\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff08\u7740\u76ee\u3059\u3079\u304d\u30ed\u30b0\u306e\u7a2e\u985e\u306e\u4f8b\uff09\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>... WARN  &#91;org.jboss.as.ee] (ContainerBackgroundProcessor...) JBAS011005: \u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9...\u306e\u7834\u68c4\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002: java.lang.NullPointerException\n... ERROR &#91;org.jboss.as.ejb3.invocation] (...) \u3042\u308b\u696d\u52d9\u30b5\u30fc\u30d3\u30b9...: \u4f55\u3089\u304b\u306e\u5fc5\u9808\u9805\u76ee\u304cnull\u3067\u3042\u308b\u65e8\u306e\u4f8b\u5916\n... WARN  &#91;com.arjuna.ats.arjuna] (Transaction Reaper Worker N) ARJUNA012113: ...missed interrupt when cancelling TX ... exiting as zombie<\/code><\/pre>\n\n\n\n<p>\u2192 \u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u7834\u68c4\u5931\u6557\uff08NPE\uff09\u3001\u696d\u52d9\u30ed\u30b8\u30c3\u30af\u4e0a\u306enull\u30c1\u30a7\u30c3\u30af\u4f8b\u5916\u3001<code>TransactionReaper<\/code>\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5f37\u5236\u30ad\u30e3\u30f3\u30bb\u30eb\u5931\u6557\uff08\u30be\u30f3\u30d3\u5316\uff09\u306a\u3069\u3001\u52d5\u4f5c\u9045\u5ef6\u30fb\u30ea\u30bd\u30fc\u30b9\u6ede\u7559\u306e\u624b\u304c\u304b\u308a\u3068\u306a\u308b\u30ed\u30b0\u30d1\u30bf\u30fc\u30f3\u3092\u767a\u898b\u3067\u304d\u308b\u3002\u7279\u306b\u300cTransactionReaper\u306e\u30be\u30f3\u30d3\u5316\u300d\u306f\u3001\u9577\u6642\u9593\u5b9f\u884c\u3055\u308c\u305f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\uff08\u591a\u304f\u306fDB\u5074\u306e\u91cd\u3044\u30af\u30a8\u30ea\uff09\u304c\u5b58\u5728\u3057\u305f\u3053\u3068\u3092\u793a\u3059\u5f37\u3044\u30b7\u30b0\u30ca\u30eb\u306b\u306a\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. DB\u30b5\u30fc\u30d0\u30fc\uff08MySQL\uff09\u8abf\u67fb<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">2-1. \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u30fb\u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u8a2d\u5b9a\u78ba\u8a8d<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p -e \"SHOW VARIABLES LIKE 'slow_query_log'; SHOW VARIABLES LIKE 'long_query_time'; SHOW VARIABLES LIKE 'slow_query_log_file'; SHOW VARIABLES LIKE 'log_error'; SHOW GLOBAL STATUS LIKE 'Slow_queries';\"<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u304c\u6709\u52b9\u304b\u3001\u95be\u5024\uff08\u4f55\u79d2\u4ee5\u4e0a\u3092\u300c\u9045\u3044\u300d\u3068\u307f\u306a\u3059\u304b\uff09\u3001\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u3001\u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u5834\u6240\u3001\u30b5\u30fc\u30d0\u30fc\u8d77\u52d5\u304b\u3089\u306e\u7d2f\u7a4d\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u6570\u3092\u78ba\u8a8d\u3059\u308b\u3002\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308c\u3070\u3001\u4ee5\u964d\u306e\u8abf\u67fb\u3067\u6700\u3082\u91cd\u8981\u306a\u60c5\u5831\u6e90\u306b\u306a\u308b\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>slow_query_log      = ON\nlong_query_time      = 10.000000\nslow_query_log_file  = \/var\/lib\/mysql\/data\/slow.log\nlog_error            = \/var\/lib\/mysql\/data\/mysqld.log\nSlow_queries         = 240174<\/code><\/pre>\n\n\n\n<p>\u2192 \u4e00\u5b9a\u79d2\u6570\u4ee5\u4e0a\u304b\u304b\u3063\u305f\u30af\u30a8\u30ea\u304c\u3059\u3079\u3066\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306b\u8a18\u9332\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2-2. \u7279\u5b9a\u30c6\u30fc\u30d6\u30eb\u30fb\u51e6\u7406\u3092\u542b\u3080\u30af\u30a8\u30ea\u306e\u7d2f\u7a4d\u5b9f\u884c\u7d71\u8a08<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p -e \"SELECT DIGEST_TEXT, COUNT_STAR AS exec_count, ROUND(AVG_TIMER_WAIT\/1000000000, 1) AS avg_ms, ROUND(MAX_TIMER_WAIT\/1000000000, 1) AS max_ms, ROUND(SUM_TIMER_WAIT\/1000000000, 1) AS total_ms, FIRST_SEEN, LAST_SEEN FROM performance_schema.events_statements_summary_by_digest WHERE DIGEST_TEXT LIKE '%\u5bfe\u8c61\u30c6\u30fc\u30d6\u30eb\u540d%' ORDER BY AVG_TIMER_WAIT DESC LIMIT 20;\" --table<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a<code>performance_schema<\/code>\u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u300c\u30af\u30a8\u30ea\u306e\u578b\uff08\u30c0\u30a4\u30b8\u30a7\u30b9\u30c8\uff09\u3054\u3068\u306e\u7d2f\u7a4d\u5b9f\u884c\u7d71\u8a08\u300d\u304b\u3089\u3001\u7591\u308f\u3057\u3044\u30c6\u30fc\u30d6\u30eb\u3092\u53c2\u7167\u3059\u308b\u30af\u30a8\u30ea\u3092\u5e73\u5747\u5b9f\u884c\u6642\u9593\u306e\u964d\u9806\u3067\u62bd\u51fa\u3059\u308b\u3002\u500b\u3005\u306e\u5b9f\u884c\u30bf\u30a4\u30df\u30f3\u30b0\u306f\u5206\u304b\u3089\u306a\u3044\u304c\u3001\u300c\u305d\u3082\u305d\u3082\u91cd\u3044\u30af\u30a8\u30ea\u304c\u3069\u308c\u304b\u300d\u306e\u5f53\u305f\u308a\u3092\u3064\u3051\u308b\u306e\u306b\u4f7f\u3048\u308b\u3002\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff08<code>mysqldump<\/code>\u7b49\uff09\u7531\u6765\u306e<code>SELECT SQL_NO_CACHE * FROM ...<\/code>\u306e\u3088\u3046\u306a\u3001\u696d\u52d9\u3068\u306f\u7121\u95a2\u4fc2\u306a\u5b9a\u671f\u51e6\u7406\u3082\u6df7\u5728\u3059\u308b\u305f\u3081\u3001<code>FIRST_SEEN<\/code>\/<code>LAST_SEEN<\/code>\u3084\u5b9f\u884c\u983b\u5ea6\u304b\u3089\u898b\u5206\u3051\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff08\u7740\u76ee\u30d1\u30bf\u30fc\u30f3\u306e\u4f8b\uff09\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u5b9a\u671f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u7531\u6765\u306e\u5168\u4ef6\u53d6\u5f97\u30af\u30a8\u30ea    exec_count=25    avg_ms=92750.4  \uff08\u591c\u9593\u306e\u6c7a\u307e\u3063\u305f\u6642\u9593\u5e2f\u306b\u306e\u307f\u5b9f\u884c\u3001\u969c\u5bb3\u3068\u306f\u7121\u95a2\u4fc2\u3068\u5224\u65ad\u3067\u304d\u308b\uff09\n\u4e00\u89a7\u7cfb\u306e\u96c6\u8a08\u30af\u30a8\u30ea                    exec_count=81267  avg_ms=1624.5  max_ms=20370.5\uff08\u5e73\u5747\u306f\u8efd\u3044\u304c\u6700\u5927\u5024\u304c\u7a81\u51fa\uff09\nJOIN\u3092\u542b\u3080\u96c6\u8a08\u30af\u30a8\u30ea                  exec_count=1433   avg_ms=1138.7  max_ms=60225.4\uff08\u540c\u4e0a\uff09<\/code><\/pre>\n\n\n\n<p>\u2192 \u7d2f\u7a4d\u7d71\u8a08\u3060\u3051\u3067\u306f\u300c\u3044\u3064\u300d\u9045\u304b\u3063\u305f\u304b\u306f\u5206\u304b\u3089\u306a\u3044\u305f\u3081\u3001\u6b21\u306b\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u672c\u4f53\u306e\u8abf\u67fb\u306b\u9032\u3080\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2-3. \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u6642\u523b\u66f8\u5f0f\u306e\u78ba\u8a8d<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>head -n 20 \/var\/lib\/mysql\/data\/slow.log<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a\u30ed\u30b0\u306e\u5148\u982d\u3092\u898b\u3066\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u66f8\u5f0f\u3092\u78ba\u8a8d\u3059\u308b\u3002MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3084\u8a2d\u5b9a\u306b\u3088\u3063\u3066\u66f8\u5f0f\u304c\u7570\u306a\u308b\u305f\u3081\uff08\u4f8b\uff1a<code>YYYY-MM-DDTHH:MM:SS<\/code>\u306eISO\u5f62\u5f0f\u304b\u3001<code>YYMMDD H:MM:SS<\/code>\u306e\u3088\u3046\u306a\u53e4\u3044\u66f8\u5f0f\u304b\uff09\u3001grep\u7b49\u3067\u7d5e\u308a\u8fbc\u3080\u524d\u306b\u5fc5\u305a\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Time: 260818  0:05:14<\/code><\/pre>\n\n\n\n<p>\u2192 <code>YYMMDD H:MM:SS<\/code>\u3068\u3044\u3046\u66f8\u5f0f\uff08ISO\u5f62\u5f0f\u3067\u306f\u306a\u3044\uff09\u3067\u3042\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u308b\u3002\u3053\u306e\u66f8\u5f0f\u3092\u78ba\u8a8d\u305b\u305a\u306bISO\u5f62\u5f0f\u3067grep\u3059\u308b\u3068\u3001\u8a72\u5f53\u4ef6\u6570\u304c0\u4ef6\u306b\u306a\u308a\u6642\u9593\u3092\u6d6a\u8cbb\u3059\u308b\u305f\u3081\u3001\u5fc5\u305a\u6700\u521d\u306b\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2-4. \u7279\u5b9a\u6642\u9593\u5e2f\u306e\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u4ef6\u6570\u3092\u5206\u5e03\u3067\u78ba\u8a8d<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>for m in 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19; do\n  c=$(grep -c \"# Time: &lt;\u65e5\u4ed8&gt; 12:$m:\" \/var\/lib\/mysql\/data\/slow.log)\n  echo \"12:$m -&gt; $c\"\ndone<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a1\u5206\u5358\u4f4d\u3067\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u767a\u751f\u4ef6\u6570\u3092\u30eb\u30fc\u30d7\u3067\u96c6\u8a08\u3057\u3001\u7279\u5b9a\u306e\u5206\u306b\u96c6\u4e2d\u3057\u3066\u3044\u308b\u304b\u3001\u6642\u9593\u5e2f\u5168\u4f53\u3067\u3070\u3089\u3064\u3044\u3066\u3044\u308b\u304b\u3092\u898b\u308b\u3002<code>&lt;\u65e5\u4ed8&gt;<\/code>\u306f\u30ed\u30b0\u306e\u66f8\u5f0f\u306b\u5408\u308f\u305b\u3066\u7f6e\u304d\u63db\u3048\u308b\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>12:00 -&gt; 1\n12:06 -&gt; 2\n12:08 -&gt; 4\n...<\/code><\/pre>\n\n\n\n<p>\u2192 \u7279\u5b9a\u306e1\u5206\u306b\u6975\u7aef\u306b\u96c6\u4e2d\u3057\u3066\u3044\u308b\u304b\u3001\u6642\u9593\u5e2f\u5168\u4f53\u3067\u7d99\u7d9a\u7684\u306b\u9ad8\u8ca0\u8377\u3060\u3063\u305f\u304b\u3092\u5224\u65ad\u3059\u308b\u6750\u6599\u306b\u306a\u308b\u3002\u524d\u8005\u306a\u3089\u5358\u767a\u306e\u91cd\u3044\u30af\u30a8\u30ea\u3001\u5f8c\u8005\u306a\u3089\u540c\u6642\u5b9f\u884c\u3055\u308c\u308b\u4ed6\u51e6\u7406\u3068\u306e\u7af6\u5408\u3084\u3001\u5168\u4f53\u7684\u306a\u30ea\u30bd\u30fc\u30b9\u4e0d\u8db3\u3092\u7591\u3046\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2-5. \u7279\u5b9a\u6642\u9593\u5e2f\u306e\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u5185\u5bb9\u3092\u62bd\u51fa<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>grep -A15 \"# Time: &lt;\u65e5\u4ed8&gt; 12:0&#91;5-9]\\|# Time: &lt;\u65e5\u4ed8&gt; 12:10\" \/var\/lib\/mysql\/data\/slow.log<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a\u6642\u523b\u306e\u884c\u306b\u30de\u30c3\u30c1\u3057\u305f\u7b87\u6240\u304b\u3089\u3001\u5f8c\u7d9aN\u884c\uff08\u30af\u30a8\u30ea\u672c\u4f53\u306e\u5148\u982d\u90e8\u5206\uff09\u3092\u8868\u793a\u3059\u308b\u3002<code>-A<\/code>\uff08after\uff09\u306e\u884c\u6570\u306f\u30af\u30a8\u30ea\u306e\u9577\u3055\u306b\u5fdc\u3058\u3066\u8abf\u6574\u304c\u5fc5\u8981\uff08\u77ed\u3059\u304e\u308b\u3068\u30af\u30a8\u30ea\u306e\u672c\u8cea\u90e8\u5206\u304c\u898b\u3048\u306a\u3044\uff09\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff08\u7740\u76ee\u3059\u3079\u304d\u5024\u306e\u4f8b\uff09\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Time: &lt;\u65e5\u4ed8&gt; 12:06:53\n# Query_time: 1914.730925  Lock_time: 0.000601 Rows_sent: 135  Rows_examined: 3045121049\nselect\n    ...<\/code><\/pre>\n\n\n\n<p>\u2192 <code>Query_time<\/code>\uff08\u5b9f\u884c\u6642\u9593\uff09\u3084<code>Rows_examined<\/code>\uff08\u8aad\u307f\u53d6\u308a\u884c\u6570\uff09\u304c\u7570\u5e38\u306b\u5927\u304d\u3044\u30af\u30a8\u30ea\u3092\u767a\u898b\u3067\u304d\u308c\u3070\u3001\u305d\u308c\u304c\u52d5\u4f5c\u9045\u5ef6\u306e\u76f4\u63a5\u7684\u306a\u8a3c\u62e0\u306b\u306a\u308b\u3002<code>Rows_sent<\/code>\uff08\u8fd4\u5374\u884c\u6570\uff09\u306b\u5bfe\u3057\u3066<code>Rows_examined<\/code>\u304c\u6975\u7aef\u306b\u5927\u304d\u3044\u5834\u5408\u306f\u3001\u975e\u52b9\u7387\u306aJOIN\u3084\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u672a\u4f7f\u7528\u304c\u7591\u308f\u308c\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2-6. \u7279\u5b9a\u30af\u30a8\u30ea\u306e\u5168\u6587\uff08WHERE\u53e5\u542b\u3080\uff09\u3092\u6b63\u78ba\u306b\u62bd\u51fa<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>awk '\/^# Time: &lt;\u65e5\u4ed8&gt; 12:06:53\/{flag=1} flag; \/^# Time: &lt;\u65e5\u4ed8&gt; 12:07:15\/{exit}' \/var\/lib\/mysql\/data\/slow.log<\/code><\/pre>\n\n\n\n<p><strong>\u610f\u5473<\/strong>\uff1a<code>awk<\/code>\u3067\u300c\u958b\u59cb\u306e\u6642\u523b\u884c\u304c\u6765\u305f\u3089\u51fa\u529b\u958b\u59cb\uff08<code>flag=1<\/code>\uff09\u300d\u300c\u6b21\u306e\u30af\u30a8\u30ea\u306e\u6642\u523b\u884c\u304c\u6765\u305f\u3089\u7d42\u4e86\uff08<code>exit<\/code>\uff09\u300d\u3068\u3044\u3046\u7bc4\u56f2\u6307\u5b9a\u3092\u884c\u3044\u30011\u4ef6\u5206\u306e\u30ed\u30b0\u30a8\u30f3\u30c8\u30ea\u3092\u4e38\u3054\u3068\u6b63\u78ba\u306b\u629c\u304d\u51fa\u3059\u3002<code>grep -A<\/code>\u3067\u306f\u884c\u6570\u6307\u5b9a\u304c\u5fc5\u8981\u3067\u9577\u3044\u30af\u30a8\u30ea\u3092\u9014\u4e2d\u3067\u5207\u3063\u3066\u3057\u307e\u3046\u305f\u3081\u3001\u6b63\u78ba\u306b1\u30a8\u30f3\u30c8\u30ea\u3092\u629c\u304d\u51fa\u3057\u305f\u3044\u5834\u5408\u306f\u3053\u306e\u65b9\u6cd5\u304c\u78ba\u5b9f\u3002\u7d42\u4e86\u6761\u4ef6\u306e\u6642\u523b\u306f\u3001\u5bfe\u8c61\u30af\u30a8\u30ea\u306e\u6b21\u306b\u51fa\u73fe\u3059\u308b<code># Time:<\/code>\u306e\u5024\u3092\u6307\u5b9a\u3059\u308b\u3002<\/p>\n\n\n\n<p><strong>\u5b9f\u884c\u7d50\u679c\u4f8b<\/strong>\uff1aWHERE\u53e5\u3092\u542b\u3080\u5168\u6587\u304c\u53d6\u5f97\u3067\u304d\u3001\u526f\u554f\u3044\u5408\u308f\u305b\uff08derived table\uff09\u306e\u7d5e\u308a\u8fbc\u307f\u6761\u4ef6\u304c\u5916\u5074\u306e\u30af\u30a8\u30ea\u306e\u7d5e\u308a\u8fbc\u307f\u6761\u4ef6\u3068\u4e00\u81f4\u3057\u3066\u3044\u306a\u3044\u3001\u3068\u3044\u3063\u305fSQL\u306e\u69cb\u9020\u4e0a\u306e\u554f\u984c\u3092\u7279\u5b9a\u3067\u304d\u308b\u5834\u5408\u304c\u3042\u308b\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081\uff1a\u8abf\u67fb\u306e\u6d41\u308c\uff08\u4e00\u822c\u5316\uff09<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30a2\u30d7\u30ea\u30b5\u30fc\u30d0\u30fc\u3067JVM\u8d77\u52d5\u30aa\u30d7\u30b7\u30e7\u30f3\uff08GC\u8a2d\u5b9a\uff09\u3068\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u78ba\u8a8d\u3057\u3001\u904e\u53bb\u306e\u985e\u4f3c\u969c\u5bb3\u3068\u540c\u7cfb\u7d71\u304b\u3069\u3046\u304b\u3092\u5224\u65ad\u3059\u308b<\/li>\n\n\n\n<li>DB\u30b5\u30fc\u30d0\u30fc\u3067\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u8a2d\u5b9a\uff08\u6709\u52b9\u304b\u3001\u95be\u5024\u306f\u4f55\u79d2\u304b\uff09\u3092\u78ba\u8a8d\u3059\u308b<\/li>\n\n\n\n<li><code>performance_schema<\/code>\u306e\u7d2f\u7a4d\u7d71\u8a08\u3067\u300c\u91cd\u305d\u3046\u306a\u30af\u30a8\u30ea\u300d\u306e\u5f53\u305f\u308a\u3092\u3064\u3051\u308b\uff08\u305f\u3060\u3057\u3044\u3064\u767a\u751f\u3057\u305f\u304b\u306f\u5206\u304b\u3089\u306a\u3044\uff09<\/li>\n\n\n\n<li>\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u6642\u523b\u66f8\u5f0f\u3092\u78ba\u8a8d\u3057\u3001\u5bfe\u8c61\u6642\u9593\u5e2f\u306e\u4ef6\u6570\u5206\u5e03\u3092\u898b\u3066\u300c\u5358\u767a\u306e\u7570\u5e38\u300d\u304b\u300c\u6642\u9593\u5e2f\u5168\u4f53\u306e\u9ad8\u8ca0\u8377\u300d\u304b\u3092\u5224\u65ad\u3059\u308b<\/li>\n\n\n\n<li>\u8a72\u5f53\u6642\u9593\u5e2f\u306e\u30af\u30a8\u30ea\u672c\u4f53\u3092<code>grep -A<\/code>\u3067\u78ba\u8a8d\u3057\u3001<code>Query_time<\/code>\u3084<code>Rows_examined<\/code>\u304c\u6975\u7aef\u306b\u5927\u304d\u3044\u7570\u5e38\u306a\u30af\u30a8\u30ea\u3092\u767a\u898b\u3059\u308b<\/li>\n\n\n\n<li><code>awk<\/code>\u3067\u8a72\u5f53\u30af\u30a8\u30ea\u306e\u5168\u6587\uff08WHERE\u53e5\u542b\u3080\uff09\u3092\u6b63\u78ba\u306b\u629c\u304d\u51fa\u3057\u3001SQL\u306e\u69cb\u9020\u4e0a\u306e\u554f\u984c\u70b9\u3092\u7279\u5b9a\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p>\u3053\u306e\u30d7\u30ed\u30bb\u30b9\u306f\u3001JBoss\u5074\u306e\u30ed\u30b0\u3060\u3051\u3067\u306f\u300c\u4f55\u304c\u8d77\u304d\u305f\u304b\u300d\u307e\u3067\u3057\u304b\u5206\u304b\u3089\u305a\u3001\u300c\u306a\u305c\u8d77\u304d\u305f\u304b\u300d\u3092\u7279\u5b9a\u3059\u308b\u306b\u306f\u3001\u5bfe\u306b\u306a\u3063\u3066\u3044\u308bDB\u5074\u306e\u30ed\u30b0\uff08\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\uff09\u307e\u3067\u8e0f\u307f\u8fbc\u3080\u5fc5\u8981\u304c\u3042\u308b\u3001\u3068\u3044\u3046\u70b9\u304c\u30dd\u30a4\u30f3\u30c8\u306b\u306a\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>JBoss\uff08+ MySQL\u7b49\u306eRDBMS\uff09\u3067\u69cb\u6210\u3055\u308c\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u300c\u52d5\u4f5c\u304c\u91cd\u3044\u300d\u300c\u30e1\u30e2\u30ea\u4f7f\u7528\u7387\u304c\u4e0a\u304c\u3063\u305f\u307e\u307e\u4e0b\u304c\u3089\u306a\u3044\u300d\u3068\u3044\u3063\u305f\u969c\u5bb3\u304c\u767a\u751f\u3057\u305f\u969b\u306e\u3001\u6c4e\u7528\u7684\u306a\u8abf\u67fb\u30b3\u30de\u30f3\u30c9\u96c6\u3002\u7279\u5b9a\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30fb\u30c6\u30fc\u30d6\u30eb\u540d\u306b\u306f\u4f9d\u5b58 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[9,92,4],"tags":[],"class_list":["post-3229","post","type-post","status-publish","format-standard","hentry","category-java","category-jboss","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/3229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3229"}],"version-history":[{"count":1,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/3229\/revisions"}],"predecessor-version":[{"id":3230,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/3229\/revisions\/3230"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}