{"id":653,"date":"2015-04-05T22:43:29","date_gmt":"2015-04-06T07:43:29","guid":{"rendered":"http:\/\/blog.box.kr\/?p=653"},"modified":"2015-04-05T22:43:29","modified_gmt":"2015-04-06T07:43:29","slug":"%ed%8e%8ctoo-many-connection-%eb%ac%b8%ec%a0%9c-%ed%95%b4%ea%b2%b0","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=653","title":{"rendered":"[\ud38c]Too many connection \ubb38\uc81c \ud574\uacb0"},"content":{"rendered":"

http:\/\/netholic.tistory.com\/116<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

\uc774\ubc88\ud574 \ucd08\ubd80\ud130 \uc2dc\uc791\ub41c too many connection \ubb38\uc81c\uac00 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 mysql \uc744 \ubed7\uac8c \ub9cc\ub4e4\uc5c8\ub2e4.
\n\ub418\ub294\ub300\ub85c… \uc544\ubb34\uac83\ub3c4 \ubaa8\ub978\ucc44\ub85c \ub9cc\ub4e0 \uc6b4\uc601\ud234\uc774 \uadf8 \uc6d0\uc778… \ucffc\ub9ac\ub3c4 10\ucd08 \uc774\uc0c1 \uac78\ub9ac\ub294 \uac83\ub3c4 \uc874\uc7ac\ud588\uace0..\uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uc548\uac78\ub824\uc788\uace0..
\n\uadf8\ub798\uc11c \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \uc7a1\uace0 \uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uac78\uc5b4\uc11c…\uadf8\ub7f0 \ucffc\ub9ac\ubb38\uc81c\ub97c \uc5c6\uc570\uc73c\ub85c\uc11c \ucee4\ub125\uc158 \ubb38\uc81c\ub294 \uc5c6\uc5b4\uc9c8 \uc904 \uc54c\uc558\ub2e4.
\n\uadf8\ub7f0\ub370 \uc5ec\uc804\ud788 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529…\uc11c\ubc84\ub97c \ub0b4\ub838\ub2e4 \uc62c\ub9ac\ub294 \uac78 \ubc18\ubcf5\ud574\uc57c \ud588\uc73c\ub2c8…. \uadf8\ub798\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uc0bd\uc9c8 \uacb8.. \uc7ac\uc124\uc815 \uc2dc\uc791..
\n\uc774\uc820 \uadf8\ub9cc \uc7a1\ud600\ub2ec\ub77c\uace0~~~~! \u3160\u3160<\/p>\n

Too many connections?
\n<\/span><\/strong>\ubaa8\ub4e0 \uc5f0\uacb0 \uac00\ub2a5\ud55c connections \uc774 \ub2e4\ub978 clients \ub4e4\uc5d0 \uc758\ud574 \uc4f0\uc774\uace0 \uc788\ub2e4\ub294 \uc758\ubbf8.. \uacb0\uad6d \uc774 \uc774\ud6c4\uc758 \ucee4\ub125\uc158 \uc5f0\uacb0\uc740 \uc2e4\ud328\ud558\uac8c \ub418\uace0 max_connect_errors \ub3d9\uc548 \ucee4\ub125\uc158\uc5d0 \uc2e4\ud328\ud558\uac8c \ub418\uba74 \uc774 \uc774\ud6c4\uc758 \ubaa8\ub4e0 \ucee4\ub125\uc158\uc774 \ube14\ub7ec\ud0b9\uc774 \ub41c\ub2e4.<\/p>\n

\ud574\uacb0\ubc29\ubc95 1.<\/p>\n

<\/span><\/span>\uc2ac\ub85c\uc6b0 \ucffc\ub9ac\uc758 \uc81c\uac70, connection \uc744 \uc9c0\uc18d\uc2dc\ud0a4\ub294 \ubd88\ud544\uc694\ud55c \uac83\ub4e4\uc744 \uc81c\uac70\ud55c\ub2e4.
\nconnection \uc5f0\uacb0 \uc2dc\uac04\uc744 \ucd5c\ub300\ud55c \uc904\uc778\ub2e4. jdbc \uc124\uc815\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucee4\ub125\uc158\ud480\uc744 \ub9cc\ub4e4\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4. \uc774\ub54c \uc774\ubbf8 \uc788\ub294 \ucee4\ub125\uc158\uc744 \uc7ac\uc0dd\ud558\uc5ec \uc7ac \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc0c8 \ucee4\ub125\uc158\uc744 \uac00\uc838\uc624\ub294 \uac83\ubcf4\ub2e4 \ud6a8\uc728\uc801\uc778\ub370 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc11c \uc774\ub4e4 \ucee4\ub125\uc158\uc744 \ub2eb\uc9c0 \ubabb\ud558\uac8c \ub418\uba74 \ub2e4\uc2dc \uc7ac\uc0ac\uc6a9\ud560 \uc218\uac00 \uc5c6\uac8c \ub41c\ub2e4. \uc774\ub97c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 Jakarta-Commns DBCP \uc774\ub2e4. \uc5ec\uae30\uc11c\ub294 \ubc84\ub824\uc9c4 \ucee4\ub125\uc158\uc744 \ucd94\uc801\ud574\uc11c \ubcf5\uad6c\ud558\ub3c4\ub85d \uc124\uc815\ud560 \uc218 \uc788\ub294\ub370 \uc774 \uc124\uc815\uc740 DBCP DataSoure \uc124\uc815\uc73c\ub85c \ud560 \uc218 \uc788\ub2e4.<\/p>\n

\ub610\ud55c mysql_connect() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ud574\ub2f9 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \uc885\ub8cc\uc640 \ud568\uaed8 \uc790\ub3d9\uc73c\ub85c \uc5f0\uacb0\uc774 \uc885\ub8cc\ub41c\ub2e4\uace0 \ud558\uc9c0\ub9cc \uc2e4\uc81c\ub85c \uc0b4\ud3b4\ubcf4\uba74 \ucee4\ub125\uc158\uc740 \uadf8\ub300\ub85c \uc0b4\uc544\uc788\ub2e4. ( ” .\/mysqladmin -u -p processlist ”\u00a0 \uba85\ub839\uc5b4\ub85c \ud655\uc778) \uc774\uac83\uc740 mysql \uc758\uc2dc\uc791\uc635\uc158 \uc911 wait_timeout \uacfc \uc5f0\uad00\ub41c\ub2e4. \uc774 \uac12\ub9cc\ud07c \uc11c\ubc84\uc5d0 \uadf8\ub300\ub85c \uc5f0\uacb0\uc744 \uc720\uc9c0\ud55c \ucc44 \ub0a8\uc544\uc788\ub294 \uac83\uc774\ub2e4.<\/p>\n

– datasource \uc124\uc815<\/p>\n\n\n\n
\u00a0\u00a0\u00a0 \/\/ db connection \uc744 \uc7ac \uc0ac\uc6a9\ud558\uaca0\ub2e4\uace0 \uc120\uc5b8 (default\ub294 false \uc774\ub2e4)
\nadmin.datasource.master.jdbc.removeAbandoned=true<\/strong>
\n\/\/\ubc84\ub824\uc9c4 connection \uc73c\ub85c \uac04\uc8fc\ud558\ub294 \uc2dc\uac04\uc740\u00a01\ubd84\uc73c\ub85c \uc124\uc815
\nadmin.datasource.master.jdbc.removeAbandonedTimeout = 60<\/strong>
\n\/\/ \uc7ac\uc0ac\uc6a9\ud558\ub294 \ucee4\ub125\uc158\uc5d0 \ub300\ud55c \ub85c\uadf8\ub97c \ub0a8\uae30\uaca0\ub2e4\uace0 \uc120\uc5b8(defaul\ub294 false \uc774\ub2e4)
\nadmin.datasource.master.jdbc.logAbandoned = true<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

– wait-timeout \uc124\uc815<\/p>\n\n\n\n
\u00a0\u00a0#mysql server \uc124\uc815
\n<\/span>\u00a0\u00a0 port =3306
\nsocket = \/tmp\/mysql.sock
\n…….\uae30\ud0c0 \uc124\uc815\ub4e4
\n…….
\nwait_timeout = 50
\n#wait_timeout \uc744 50\uc73c\ub85c\u00a0\uc904\uc784<\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

=> \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \uc81c\uac70\ud558\ub294\uac8c \uc6b0\uc120\uc801\uc73c\ub85c \ud589\ud574\uc838\uc57c \ud55c\ub2e4. \ucee4\ub125\uc158\uc744 \uc9c0\uc18d\uc2dc\ud0a4\ub294 \uac00\uc7a5 \ud070 \uc6d0\uc778\uc774\ubbc0\ub85c \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \ud574\uacb0\ud558\uba74 \ucee4\ub125\uc158 \uc218\ub97c \uac10\uc18c\uc2dc\ud0ac \uc218 \uc788\ub2e4. \ub610\ud55c DB \uc11c\ubc84\uc758 \uc811\uc18d\uc774 \ub9ce\uc740 \uacbd\uc6b0 wait_timeout \uc744 \ucd5c\ub300\ud55c \uc801\uac8c(10~20 \uc815\ub3c4..) \uc124\uc815\ud558\uc5ec \ubd88\ud544\uc694\ud55c \uc5f0\uacb0\uc744 \ube68\ub9ac \uc815\ub9ac\ud558\ub294 \uac83\uc774 \uc88b\ub2e4. \ud558\uc9c0\ub9cc Connection Miss Rate(%) \uac00 1% \uc774\uc0c1\uc774\ub77c\uba74(\uc544\ub798 \ud29c\ub2dd \ubd80\ubd84\uc5d0\uc11c \uc124\uba85)\u00a0\uc880 \ub354 \uae38\uac8c \uc7a1\uc744 \ud544\uc694\uac00 \uc788\ub2e4.<\/span><\/p>\n

\ud574\uacb0\ubc29\ubc95 2.<\/p>\n

<\/span><\/span>max_connection \uc218\ub97c \uc99d\uac00 \uc2dc\ucf1c connection \uac1c\uc218\ub97c \ud655\ubcf4\ud55c\ub2e4.
\n\uc774 \ub54c \ucee4\ub125\uc158\ud480\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4\uba74 java \uc124\uc815\uc5d0\uc11c jdbc \uc758 connection-pool \uc758 \ucd5c\ub300 \ub3c4 \uac19\uc774 \uc99d\uac00\uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/p>\n

– mysql \uc11c\ubc84\uc758 my.cnf \uc5d0\u00a0 max-connection \uac1c\uc218 \uc124\uc815<\/p>\n\n\n\n
\u00a0\u00a0#mysql server \uc124\uc815
\nport =3306
\nsocket = \/tmp\/mysql.sock
\n…….\uae30\ud0c0 \uc124\uc815\ub4e4
\n…….
\nmax_connections = 200
\n#\ucee4\ub125\uc158\uc744 200\uc73c\ub85c \uc62c\ub9bc<\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

– jdbc pool-max \uc124\uc815<\/p>\n\n\n\n
\u00a0\u00a0 \/\/\ucd5c\uc18c connection pool\u00a0\uac1c\uc218
\nadmin.datasource.master.jdbc.pool-min=3 \uc544\ub798 \ubb38\uc81c \ubc1c\uc0dd!\u00a0\ucc38\uace0\ud558\uc138\uc694 .<\/span>
\n<\/strong>\u00a0\u00a0 \/\/\ucd5c\ub300 connection pool \uac1c\uc218
\nadmin.datasource.master.jdbc.pool-max=100<\/strong>\u00a0 \/\/max_connections \uc640 \ube44\ub840\ud574\uc11c \uc99d\uac10\uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

=> \ubb38\uc81c: \ud558\ub8e8\uc5d0 \ubcf4\ud1b5 \uc0ac\uc6a9\ud558\ub294 connection \uc218\ub294 \uae30\ubcf8 4~50 \uc774\uc5c8\ub2e4. \uadf8\ub7f0\ub370 \uc774 \uc5f0\uacb0\uc774 \uc5b4\ub290 \ud55c \uc21c\uac04 150~180 \uc774\ub807\uac8c \uce58\uc19f\uac8c \ub41c\ub2e4. \uc774\ub54c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uac83… \uae30\ubcf8\uc801\uc73c\ub85c connection \uc218\uac00 \ub9ce\ub2e4\uba74 max connection \uc744 \uc99d\uac00 \uc2dc\ud0a4\ub294 \uac83\uc774 \ub9de\uc9c0\ub9cc \uc5b4\ub290 \uc21c\uac04 \uce58\uc19f\ub294 \ucee4\ub125\uc158\uc774\ub77c\uba74 max\ub97c \uc99d\uac00\ud55c\ub2e4\uace0 \ud574\uacb0\ub418\uc9c0\ub294 \uc54a\ub294\ub2e4. <\/span><\/p>\n

\ud574\uacb0\ubc29\ubc95 3.
\n<\/span>
\n<\/span>connection \uc5d0 \ub300\ud55c \ud29c\ub2dd\uc744 \ud55c\ub2e4.<\/p>\n

1. status<\/span><\/p>\n

    \n
  • Aborted_clients – \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc774 \ube44 \uc815\uc0c1\uc801\uc73c\ub85c \uc885\ub8cc\ub41c \uc218<\/li>\n
  • Aborted_connects – MySQL \uc11c\ubc84\uc5d0 \uc811\uc18d\uc774 \uc2e4\ud328\ub41c \uc218<\/li>\n
  • Max_used_connections – \ucd5c\ub300\ub85c \ub3d9\uc2dc\uc5d0 \uc811\uc18d\ud55c \uc218<\/li>\n
  • Threads_cached – Thread Cache\uc758 Thread \uc218<\/li>\n
  • Threads_connected – \ud604\uc7ac \uc5f0\uacb0\ub41c Thread \uc218<\/li>\n
  • Threads_created – \uc811\uc18d\uc744 \uc704\ud574 \uc0dd\uc131\ub41c Thread \uc218<\/li>\n
  • Threads_running – Sleeping \ub418\uc5b4 \uc788\uc9c0 \uc54a\uc740 Thread \uc218<\/li>\n<\/ul>\n

    2. system variables<\/span><\/p>\n

      \n
    • wait_timeout – \uc885\ub8cc\uc804\uae4c\uc9c0 \uc694\uccad\uc774 \uc5c6\uc774 \uae30\ub2e4\ub9ac\ub294 \uc2dc\uac04 ( TCP\/IP \uc5f0\uacb0, Shell \uc0c1\uc758 \uc811\uc18d\uc774 \uc544\ub2cc \uacbd\uc6b0 )<\/li>\n
    • thread_cache_size – thread \uc7ac \uc0ac\uc6a9\uc744 \uc704\ud55c Thread Cache\u00a0\uc218\ub85c\uc368, Cache \uc5d0 \uc788\ub294 Thread \uc218\ubcf4\ub2e4 \uc811\uc18d\uc774 \ub9ce\uc73c\uba74 \uc0c8\ub86d\uac8c Thread\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/li>\n
    • max_connections – \ucd5c\ub300 \ub3d9\uc2dc \uc811\uc18d \uac00\ub2a5 \uc218<\/li>\n<\/ul>\n

      <\ud604\uc7ac \ub0b4 mysql \uc815\ubcf4><\/p>\n\n\n\n
      \u00a0mysql> show variables like ‘%max_connection%’;
      \n+—————–+——-+
      \n| Variable_name\u00a0\u00a0 | Value |
      \n+—————–+——-+
      \n| max_connections | 200\u00a0\u00a0 |
      \n+—————–+——-+
      \n1 row in set (0.00 sec)<\/p>\n

      mysql> show status like ‘%connect%’;
      \n+———————-+——-+
      \n| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value |
      \n+———————-+——-+
      \n| Aborted_connects\u00a0\u00a0\u00a0\u00a0 | 8\u00a0\u00a0\u00a0\u00a0 |
      \n| Connections\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 10558 |
      \n| Max_used_connections | 32\u00a0\u00a0\u00a0 |
      \n| Threads_connected\u00a0\u00a0\u00a0 | 12\u00a0\u00a0\u00a0 |
      \n+———————-+——-+
      \n4 rows in set (0.01 sec)<\/p>\n

      mysql> show status like ‘%clients%’;
      \n+—————–+——-+
      \n| Variable_name\u00a0\u00a0 | Value |
      \n+—————–+——-+
      \n| Aborted_clients | 680\u00a0\u00a0 |
      \n+—————–+——-+
      \n1 row in set (0.01 sec)<\/p>\n

      mysql> show status like ‘%thread%’;
      \n+————————+——-+
      \n| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value |
      \n+————————+——-+
      \n| Delayed_insert_threads | 0\u00a0\u00a0\u00a0\u00a0 |
      \n| Slow_launch_threads\u00a0\u00a0\u00a0 | 0\u00a0\u00a0\u00a0\u00a0 |
      \n| Threads_cached\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 4\u00a0\u00a0\u00a0\u00a0 |
      \n| Threads_connected\u00a0\u00a0\u00a0\u00a0\u00a0 | 14\u00a0\u00a0\u00a0 |
      \n| Threads_created\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 246\u00a0\u00a0 |
      \n| Threads_running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 1\u00a0\u00a0\u00a0\u00a0 |
      \n+————————+——-+
      \n6 rows in set (0.02 sec)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      <\uacc4\uc0b0\uc2dd>
      \nCache Miss Rate(%) =\u00a0 (Threads_created \/ Connections) * 100
      \nConnection Miss Rate(%) = (Aborted_connects \/ Connections) * 100
      \nConnection Usage(%) = (Threads_connected \/ max_connections) * 100<\/span><\/p>\n

      (\ub098\uc758\u00a0\uacbd\uc6b0\ub294 Cache Miss Rate(%) = 2.3%, Connection Miss Rate(%) = 0.08%, Connection Usage(%) = 7% \uc774\ub2e4.
      \npeak time \ub54c \uacc4\uc0b0\ud574\ubcf4\ub294 \uac83\uc774 \uc911\uc694…)<\/p>\n

      – > \uc124\uba85<\/span><\/p>\n

       <\/p>\n

        \n
      • Connection Usage(%)\uac00 100% \ub77c\uba74 max_connections \uc218\ub97c \uc99d\uac00\uc2dc\ucf1c \uc8fc\uc2ed\uc2dc\uc694. Connection \uc218\uac00 \ubd80\uc871\ud560 \uacbd\uc6b0 Too many connection\u00a0\ubb38\uc81c\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/li>\n
      • DB \uc11c\ubc84\uc758 \uc811\uc18d\uc774 \ub9ce\uc740 \uacbd\uc6b0\ub294\u00a0wait_timeout \uc744 \ucd5c\ub300\ud55c \uc801\uac8c (10~20 \uc815\ub3c4\ub97c \ucd94\ucc9c) \uc124\uc815\ud558\uc5ec \ubd88\ud544\uc694\ud55c \uc5f0\uacb0\uc744 \ube68\ub9ac \uc815\ub9ac\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 Connection Miss Rate(%) \uac00 1% \uc774\uc0c1\uc774 \ub41c\ub2e4\uba74 wait_timeout \uc744 \uc880 \ub354 \uae38\uac8c \uc7a1\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n
      • Cache Miss Rate(%) \uac00 \ub192\ub2e4\uba74 thread_cache_size\ub97c \uae30\ubcf8\uac12\uc778 8\u00a0\ubcf4\ub2e4 \ub192\uac8c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c threads_connected \uac00 Peak-time \uc2dc \ubcf4\ub2e4 \uc57d\uac04 \ub0ae\uc740 \uc218\uce58\ub85c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n
      • MySQL \uc11c\ubc84\ub294 \uc678\ubd80\ub85c \ubd80\ud130 \uc811\uc18d \uc694\uccad\uc744 \ubc1b\uc744 \uacbd\uc6b0 \uc778\uc99d\uc744 \uc704\ud574 IP \uc8fc\uc18c\ub97c \ud638\uc2a4\ud2b8\ub124\uc784\uc73c\ub85c \ubc14\uafb8\ub294 \uacfc\uc815\uc744 \uc218\ud589\ud558\uc5ec \uc811\uc18d\uc2dc\uc5d0 \ubd88\ud544\uc694\ud55c \ubd80\ud558\uac00 \ubc1c\uc0dd\ud558\uac8c \ub429\ub2c8\ub2e4. skip-name-resolve\ub97c \uc124\uc815\ud558\uc2dc\uace0 \uc811\uc18d\uc2dc\uc5d0 IP \uae30\ubc18\uc73c\ub85c \uc811\uc18d\uc744 \ud558\uac8c \ub418\uba74 hostname lookup \uacfc\uc815\uc744 \uc0dd\ub7b5\ud558\uac8c \ub418\uc5b4 \uc880 \ub354 \ube60\ub974\uac8c \uc811\uc18d\uc744 \ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n

        =============================================================================
        \n<\/span>\ubb38\uc81c \ud574\uacb0!!<\/span><\/strong><\/span><\/li>\n<\/ul>\n

         <\/p>\n

        \ub0b4 \uacbd\uc6b0\ub294 wait_timeout \uacfc Cache Miss Rate\u00a0\uc5d0 \ubb38\uc81c\uac00 \uc788\uc5c8\ub2e4.
        \n\uc6d0\ub798 wait_timeout \uc774 28800 \uc73c\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc5c8\uace0 Threads_cashed \uac00 0 \uc73c\ub85c \ub418\uc5b4\uc788\uc5c8\uae30\uc5d0 thread_created \uac00 connection \uc218\ub9cc\ud07c \uc99d\uac00\ud558\uc600\ub358 \uac83..
        \n\uc774\ub807\uac8c \uc124\uc815 \ud6c4 mysql\uc744 \uc7ac\uc2dc\uc791 \ud558\uac8c \ud55c \uc9c0\uae08\uc740 connection \uc774 \uce58\uc19f\ub294 \ud604\uc0c1\uc740 \uc5c6\ub294 \ub4ef\ud558\ub2e4.
        \n\uc544\uc9c1\uc740…\uc870\uae08 \ub354 \uc9c0\ucf1c\ubd10\uc57c\uaca0\uc9c0\ub9cc \uc608\uc804\uc5d0 \ube44\ud574 \uc5f0\uacb0 \uc815\ub3c4\uac00 \uc548\uc815\uc801\uc778\uac83 \uac19\ub2e4. \uc774\uac83\uc73c\ub85c \ub354\uc774\uc0c1 500 Too many connection \uc774\ub780 \uae00\uc790\ub97c \uc548 \ubd24\uc73c\uba74 \ud55c\ub2e4.. \u3160\u3160 \uc2dc\ub2ec\ub9b0\ub2e4 \uc815\ub9d0….
        \n======================================================<\/p>\n

        !!! \ud574\uacb0 \ud55c \uc904 \uc54c\uc558\ub358 \ubb38\uc81c \ub610 \ubc1c\uc0dd!!<\/span><\/strong><\/p>\n

        \uc774\ubc88\uc5d4…oraqle \uc774\ub2e4…\uc5b4\ud734 \uc774\uac74 DB \uc124\uc815 \ubabb \uac74\ub4e4\uc774\ub294\ub370….
        \n\uc790\uafb8 \uc694\uccad\uc774 \uc62c \ub54c \ub9c8\ub2e4 \uce58\uc19f\ub294 connection \uc218.. \uc678\ubd80\uc11c \ubc30\uce58\ub85c 2\ub9cc\uac1c\uc758 \ucffc\ub9ac\uac00 \ub0a0\ub77c\uc624\ub294 \uac83 \ub55c\uc5d0 \ub9ac\uc2a4\ub108\uac00 \ub9db\uc774 \uac08 \uc815\ub3c4\uc600\ub2e4..<\/p>\n

        DB \uc124\uc815\uacfc jdbc \uc124\uc815\uc774 \uc548 \ub9de\ub294\uac8c \uc774\uc0c1\ud558\uc5ec \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uc558\ub2e4.
        \njdbc \uc124\uc815 \uace0\uce58\uae30..
        \n\ucee4\ub125\uc158 \ud480 \uc758 \uc18d\uc131 \uc740 \uc544\ub798\uc640 \uac19\ub2e4.
        \n<\/span><\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        \uc18d\uc131<\/span><\/b><\/td>\n\uc124\uba85<\/span><\/b><\/td>\n<\/tr>\n
        maxActive<\/span><\/td>\n\ucee4\ub125\uc158 \ud480\uc774 \uc81c\uacf5\ud560 \ucd5c\ub300 \ucee4\ub125\uc158 \uac1c\uc218<\/span><\/td>\n<\/tr>\n
        whenExhaustedAction<\/span><\/td>\n\ucee4\ub125\uc158 \ud480\uc5d0\uc11c \uac00\uc838\uc62c \uc218 \uc788\ub294 \ucee4\ub125\uc158\uc774 \uc5c6\uc744 \ub54c \uc5b4\ub5bb\uac8c \ub3d9\uc791\ud560\uc9c0\ub97c \uc9c0\uc815\ud55c\ub2e4. 1\uc77c \uacbd\uc6b0 maxWait \uc18d\uc131\uc5d0\uc11c \uc9c0\uc815\ud55c \uc2dc\uac04\ub9cc\ud07c \ucee4\ub125\uc158\uc744 \uad6c\ud560 \ub54c \uae4c\uc9c0 \uae30\ub2e4\ub9ac\uba70, 0\uc77c \uacbd\uc6b0 \uc5d0\ub7ec\ub97c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4. 2\uc77c \uacbd\uc6b0\uc5d0\ub294 \uc77c\uc2dc\uc801\uc73c\ub85c \ucee4\ub125\uc158\uc744 \uc0dd\uc131\ud574\uc11c \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n
        maxWait<\/span><\/td>\nwhenExhaustedAction \uc18d\uc131\uc758 \uac12\uc774 1\uc77c \ub54c \uc0ac\uc6a9\ub418\ub294 \ub300\uae30 \uc2dc\uac04. \ub2e8\uc704\ub294 1\/1000\ucd08\uc774\uba70, 0 \ubcf4\ub2e4 \uc791\uc744 \uacbd\uc6b0 \ubb34\ud55c\ud788 \ub300\uae30\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n
        maxIdle<\/span><\/td>\n\uc0ac\uc6a9\ub418\uc9c0 \uc54a\uace0 \ud480\uc5d0 \uc800\uc7a5\ub420 \uc218 \uc788\ub294 \ucd5c\ub300 \ucee4\ub125\uc158 \uac1c\uc218. \uc74c\uc218\uc77c \uacbd\uc6b0 \uc81c\ud55c\uc774 \uc5c6\ub2e4.<\/span><\/td>\n<\/tr>\n
        minIdle<\/span><\/td>\n\uc0ac\uc6a9\ub418\uc9c0 \uc54a\uace0 \ud480\uc5d0 \uc800\uc7a5\ub420 \uc218 \uc788\ub294 \ucd5c\uc18c \ucee4\ub125\uc158 \uac1c\uc218.<\/span><\/td>\n<\/tr>\n
        testOnBorrow<\/span><\/td>\ntrue\uc77c \uacbd\uc6b0 \ucee4\ub125\uc158 \ud480\uc5d0\uc11c \ucee4\ub125\uc158\uc744 \uac00\uc838\uc62c \ub54c \ucee4\ub125\uc158\uc774 \uc720\ud6a8\ud55c\uc9c0\uc758 \uc5ec\ubd80\ub97c \uac80\uc0ac\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n
        testOnReturn<\/span><\/td>\ntrue\uc77c \uacbd\uc6b0 \ucee4\ub125\uc158 \ud480\uc5d0 \ucee4\ub125\uc158\uc744 \ubc18\ud658\ud560 \ub54c \ucee4\ub125\uc158\uc774 \uc720\ud6a8\ud55c\uc9c0\uc758 \uc5ec\ubd80\ub97c \uac80\uc0ac\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n
        timeBetweenEvctionRunsMillis<\/span><\/td>\n\uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc740 \ucee4\ub125\uc158\uc744 \ucd94\ucd9c\ud558\ub294 \uc4f0\ub808\ub4dc\uc758 \uc2e4\ud589 \uc8fc\uae30\ub97c \uc9c0\uc815\ud55c\ub2e4. \uc591\uc218\uac00 \uc544\ub2d0 \uacbd\uc6b0 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294\ub2e4. \ub2e8\uc704\ub294 1\/1000 \ucd08\uc774\ub2e4.<\/span><\/td>\n<\/tr>\n
        numTestsPerEvictionRun<\/span><\/td>\n\uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \ucee4\ub125\uc158\uc744 \uba87 \uac1c \uac80\uc0ac\ud560\uc9c0 \uc9c0\uc815\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n
        minEvictableIdleTimeMillis<\/span><\/td>\n\uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \ucee4\ub125\uc158\uc744 \ucd94\ucd9c\ud560 \ub54c \uc774 \uc18d\uc131\uc5d0\uc11c \uc9c0\uc815\ud55c \uc2dc\uac04 \uc774\uc0c1 \ube44\ud65c\uc131\ud654 \uc0c1\ud0dc\uc778 \ucee4\ub125\uc158\ub9cc \ucd94\ucd9c\ud55c\ub2e4. \uc591\uc218\uac00 \uc544\ub2cc \uacbd\uc6b0 \ube44\ud65c\uc131\ud654\ub41c \uc2dc\uac04\uc73c\ub85c\ub294 \ud480\uc5d0\uc11c \uc81c\uac70\ub418\uc9c0 \uc54a\ub294\ub2e4. \uc2dc\uac04 \ub2e8\uc704\ub294 1\/1000\ucd08\uc774\ub2e4.<\/span><\/td>\n<\/tr>\n
        testWhileIdle<\/span><\/td>\ntrue\uc77c \uacbd\uc6b0 \ube44\ud65c\uc131\ud654 \ucee4\ub125\uc158\uc744 \ucd94\ucd9c\ud560 \ub54c \ucee4\ub125\uc158\uc774 \uc720\ud6a8\ud55c\uc9c0\uc758 \uc5ec\ubd80\ub97c \uac80\uc0ac\ud574\uc11c \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \ucee4\ub125\uc158\uc740 \ud480\uc5d0\uc11c \uc81c\uac70\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


        \n\uc774 \uc911..minIdle \uc740 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uace0 \ud480\uc5d0 \uc800\uc7a5\ub420 \uc218 \uc788\ub294 \ucd5c\uc18c \ucee4\ub125\uc158\uc774\ub780\ub2e4..\uadf8\ub798 \ucd5c\uc18c\ub2c8\uae4c \ucd5c\uc18c\ud55c\uc73c\ub85c \ub04a\uc9c0 \uc54a\uace0 \uc5f0\uacb0\ud574\ub450\uba74 \ub098\uc911\uc5d0 \ucee4\ub125\uc158 \uc694\uccad \uc2dc \ub2e4\uc2dc \ub9fa\uc9c0 \uc54a\uace0 \uc788\ub294 \uac78 \uc4f8\ud14c\ub2c8 \ud6a8\uc728\uc801\uc774\uaca0\uc9c0…\ub77c\uace0 \uc0dd\uac01\ud588\ub2e4\ub9cc!! \uc774\uac8c \ucee4\ub125\uc158\uc744 \uc904\uc5b4\ub4e4\uc9c0 \uc54a\uac8c \ub9cc\ub4e0 \uc6d0\uc778\uc774 \ub418\uace0 \uc788\uc5c8\ub2e4. \uc65c\uadf8\ub7f4\uae4c \uc758\uad6c\uc2ec\uc740 \uc99d\ud3ed.. \ud639\uc2dc pool \uc790\uccb4\uac00 \ud558\ub098\uac00 \uc544\ub2c8\uace0 \uc5ec\ub7ec\uac1c\uac00 \uc0dd\uc131\uc774 \ub418\ub098 \ud558\ub294 \uc758\uc2ec\uc744 \ud558\uac8c \ub41c\ub2e4.
        \n\uac01 pool \ub9c8\ub2e4 \ucd5c\uc18c \ucee4\ub125\uc158\uc744 \uc720\uc9c0\ud558\ub2e4\ubcf4\ub2c8 \ucee4\ub125\uc158\uc774 \uc904\uc9c0 \uc54a\ub294 \uac8c \uc544\ub2d0\uae4c… \uadfc\ub370 \uadf8\ub7fc \uc774\uac8c \uc788\ub294 \uc758\ubbf8\uac00 \uc5c6\uc796\uc544…\u3160\u3160<\/p>\n

        \ud5e4\uace0..\uc77c\ub2e8 minIdle\uc744 0\uc73c\ub85c \uacfc\uac10\ud788 \uc138\ud305\ud574\ubc84\ub838\ub2e4..\ubb34\uc2dd\ud558\uc9c0\ub9cc…\uc77c\ub2e8 \ud6a8\uc728\ubcf4\ub2e4 DB\uac00 \uc8fd\uc5b4\ub098\uac8c \uc0dd\uacbc\ub2e4…
        \n– jdbc pool-max \uc124\uc815\uc744 \uc544\ub798\uc640 \uac19\uc774 \ubc14\uafd4\ubcf4\uc790
        \n<\/span><\/span><\/p>\n\n\n\n
        \u00a0\u00a0 \/\/\ucd5c\uc18c connection pool\u00a0\uac1c\uc218
        \nadmin.datasource.master.jdbc.pool-min=0<\/span><\/strong>\u00a0\u00a0 \/\/ \ucee4\ub125\uc158 \ud480 \uc5d0 \ub0a8\uc544\uc788\uc9c0 \uc54a\uac8c \ubc14\uafc8..
        \nadmin.datasource.master.jdbc.pool-max=20<\/strong>\u00a0 \/\/max_connections \uc640 \ube44\ub840\ud574\uc11c \uc99d\uac10\uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


        \n\ucc38\uace0! \uc704\uc5d0\uc11c \ub9d0\ud55c DB \uc124\uc815 \ud574\uacb0\ubc29\ubc95\uc740 DB \uc5d0\uc11c \uac15\uc81c\ub85c \ucee4\ub125\uc158\uc744 \ub04a\uc5b4\uc8fc\ub294 \uac83\uc5d0 \ubc18\ud558\uc5ec \uc544\ub798\ub294 DB \uc811\uc18d\ud558\ub294 \uce21\uc5d0\uc11c connection \uc744 \uadf8\ub54c \uadf8\ub54c \ub04a\uc5b4\uc8fc\uba74\uc11c \uc811\uadfc\ud558\ub2c8\uae4c \uc544\ub798 \ubc29\ubc95\uc774 \uc77c\ub2e8 \ub354 \ub0ab\ub2e4\uace0 \ubcf8\ub2e4..
        \n<\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

        http:\/\/netholic.tistory.com\/116     \uc774\ubc88\ud574 \ucd08\ubd80\ud130 \uc2dc\uc791\ub41c too many connection \ubb38\uc81c\uac00 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 mysql \uc744 \ubed7\uac8c \ub9cc\ub4e4\uc5c8\ub2e4. \ub418\ub294\ub300\ub85c… \uc544\ubb34\uac83\ub3c4 \ubaa8\ub978\ucc44\ub85c \ub9cc\ub4e0 \uc6b4\uc601\ud234\uc774 \uadf8 \uc6d0\uc778… \ucffc\ub9ac\ub3c4 10\ucd08 \uc774\uc0c1 \uac78\ub9ac\ub294 \uac83\ub3c4 \uc874\uc7ac\ud588\uace0..\uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uc548\uac78\ub824\uc788\uace0.. \uadf8\ub798\uc11c \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \uc7a1\uace0 \uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uac78\uc5b4\uc11c…\uadf8\ub7f0 \ucffc\ub9ac\ubb38\uc81c\ub97c \uc5c6\uc570\uc73c\ub85c\uc11c \ucee4\ub125\uc158 \ubb38\uc81c\ub294 \uc5c6\uc5b4\uc9c8 \uc904 \uc54c\uc558\ub2e4. \uadf8\ub7f0\ub370 \uc5ec\uc804\ud788 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529…\uc11c\ubc84\ub97c \ub0b4\ub838\ub2e4 \uc62c\ub9ac\ub294 \uac78 \ubc18\ubcf5\ud574\uc57c \ud588\uc73c\ub2c8…. \uadf8\ub798\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uc0bd\uc9c8 \uacb8.. \uc7ac\uc124\uc815 \uc2dc\uc791.. \uc774\uc820 \uadf8\ub9cc \uc7a1\ud600\ub2ec\ub77c\uace0~~~~! \u3160\u3160 Too many connections? \ubaa8\ub4e0 \uc5f0\uacb0 \uac00\ub2a5\ud55c connections \uc774 \ub2e4\ub978 clients \ub4e4\uc5d0 \uc758\ud574 \uc4f0\uc774\uace0 \uc788\ub2e4\ub294 \uc758\ubbf8.. \uacb0\uad6d \uc774 \uc774\ud6c4\uc758 \ucee4\ub125\uc158 \uc5f0\uacb0\uc740 \uc2e4\ud328\ud558\uac8c \ub418\uace0 max_connect_errors \ub3d9\uc548 \ucee4\ub125\uc158\uc5d0 \uc2e4\ud328\ud558\uac8c \ub418\uba74 \uc774 \uc774\ud6c4\uc758 \ubaa8\ub4e0 \ucee4\ub125\uc158\uc774 \ube14\ub7ec\ud0b9\uc774 \ub41c\ub2e4. \ud574\uacb0\ubc29\ubc95 1. \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\uc758 \uc81c\uac70, connection \uc744 \uc9c0\uc18d\uc2dc\ud0a4\ub294 \ubd88\ud544\uc694\ud55c \uac83\ub4e4\uc744 \uc81c\uac70\ud55c\ub2e4. connection \uc5f0\uacb0 \uc2dc\uac04\uc744 \ucd5c\ub300\ud55c \uc904\uc778\ub2e4. jdbc \uc124\uc815\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucee4\ub125\uc158\ud480\uc744 \ub9cc\ub4e4\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4. \uc774\ub54c \uc774\ubbf8 \uc788\ub294 \ucee4\ub125\uc158\uc744 \uc7ac\uc0dd\ud558\uc5ec \uc7ac \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc0c8 \ucee4\ub125\uc158\uc744 \uac00\uc838\uc624\ub294 \uac83\ubcf4\ub2e4 \ud6a8\uc728\uc801\uc778\ub370 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc11c \uc774\ub4e4 \ucee4\ub125\uc158\uc744 \ub2eb\uc9c0 \ubabb\ud558\uac8c \ub418\uba74 \ub2e4\uc2dc \uc7ac\uc0ac\uc6a9\ud560 \uc218\uac00 \uc5c6\uac8c \ub41c\ub2e4. \uc774\ub97c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 Jakarta-Commns DBCP \uc774\ub2e4. \uc5ec\uae30\uc11c\ub294 \ubc84\ub824\uc9c4 \ucee4\ub125\uc158\uc744 \ucd94\uc801\ud574\uc11c \ubcf5\uad6c\ud558\ub3c4\ub85d \uc124\uc815\ud560 \uc218 \uc788\ub294\ub370 \uc774 \uc124\uc815\uc740 DBCP DataSoure \uc124\uc815\uc73c\ub85c \ud560 \uc218 \uc788\ub2e4. \ub610\ud55c mysql_connect() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ud574\ub2f9 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \uc885\ub8cc\uc640 \ud568\uaed8 \uc790\ub3d9\uc73c\ub85c \uc5f0\uacb0\uc774 \uc885\ub8cc\ub41c\ub2e4\uace0 \ud558\uc9c0\ub9cc \uc2e4\uc81c\ub85c \uc0b4\ud3b4\ubcf4\uba74 \ucee4\ub125\uc158\uc740 \uadf8\ub300\ub85c \uc0b4\uc544\uc788\ub2e4. ( ” .\/mysqladmin -u -p processlist ”\u00a0 \uba85\ub839\uc5b4\ub85c \ud655\uc778) \uc774\uac83\uc740 mysql \uc758\uc2dc\uc791\uc635\uc158 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-ax","jetpack-related-posts":[{"id":720,"url":"https:\/\/blog.box.kr\/?p=720","url_meta":{"origin":653,"position":0},"title":"[\ud38c]Java \uc5d0\uc11c DataBase Replication Master\/Slave (write\/read) \ubd84\uae30 \ucc98\ub9ac\ud558\uae30","date":"2015-04-15","format":false,"excerpt":"http:\/\/kwon37xi.egloos.com\/ \ub300\uaddc\ubaa8 \uc11c\ube44\uc2a4 \uac1c\ubc1c\uc2dc\uc5d0 \uac00\uc7a5 \uae30\ubcf8\uc801\uc73c\ub85c \ud558\ub294 \ud29c\ub2dd\uc740 \ubc14\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c Write\uc640 Read DB\ub97c Replication(\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158)\ud558\uace0 \uc4f0\uae30 \uc791\uc5c5\uc740 Master(Write)\ub85c \ubcf4\ub0b4\uace0 \uc77d\uae30 \uc791\uc5c5\uc740 Slave(Read)\ub85c \ubcf4\ub0b4\uc5b4 \ubd80\ud558\ub97c \ubd84\uc0b0 \uc2dc\ud0a4\ub294 \uac83\uc774\ub2e4. \ud2b9\ud788 \ub300\ubd80\ubd84\uc758 \uc11c\ube44\uc2a4\ub294 \uc77d\uae30\uac00 \uc555\ub3c4\uc801\uc73c\ub85c \ub9ce\uae30 \ub54c\ubb38\uc5d0\u00a0 Slave\ub294 \uc5ec\ub7ec \ub300\ub97c \ub450\uc5b4 \uc77d\uae30 \ubd80\ud558\ub97c \ubd84\uc0b0 \uc2dc\ud0a8\ub2e4. \uadf8\ub7f0\ub370 \ub610 \ud558\ub098 \uae30\uc5b5\ud574\uc57c \ud560 \uac83\uc774 Replication\uc740 \ube44\ub85d \uc9e7\ub354\ub77c\ub3c4\u2026","rel":"","context":"In "JAVA"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":590,"url":"https:\/\/blog.box.kr\/?p=590","url_meta":{"origin":653,"position":1},"title":"[\ud38c]Java \uc5d0\uc11c DataBase Replication Master\/Slave (write\/read) \ubd84\uae30 \ucc98\ub9ac\ud558\uae30 \ud504\ub85c\uadf8\ub798\ubc0d","date":"2015-01-30","format":false,"excerpt":"Cloud\ud658\uacbd\uc5d0\uc11c DB\ub97c \uc0ac\uc6a9\ud558\ub2e4\ubcf4\ub2c8 Disk I\/O\ub098 \ub108\ubb34 \ub290\ub824\uc11c \ub9ce\uc740 \uace0\ubbfc\uc744 \ud558\uac8c \ub410\ub2e4. \uc77c\ub2e8 \uc0dd\uac01\ub098\ub294\uac83\uc774 \ub9ce\uc774 \ub4e4 \ud558\ub294 Replication\uc744 \uc774\uc6a9\ud55c \ubd80\ud558\ubd84\uc0b0 ( Master\ub294 Insert\/Update\ub9cc, Slave\ub294 SELECT\ub9cc ) \uadf8\ub7f0\ub370 \ub9c9\uc0c1 \ud560\ub824\uba74 \uc774\uac83 \uc800\uac83 \uc190\uc774 \ub9ce\uc774 \uac04\ub2e4.. \uadf8\ub798\uc11c.. \uc0dd\uac01\ub9cc \ud558\uace0 \uc801\uc6a9\uc744 \uc548\ud588\uc5c8\ub294\ub370.. \u00a0 \uc6f9\uc11c\ud551\uc744 \ud558\ub2e4\uac00 \uc774\ub7f0 \uae00\uc744 \ubc1c\uacac.. \uc544!! \uc774\ub807\uac8c \uc88b\uc744 \uc218\uac00.. \u00a0 \uc5ed\uc2dc\u2026","rel":"","context":"In "JAVA"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":592,"url":"https:\/\/blog.box.kr\/?p=592","url_meta":{"origin":653,"position":2},"title":"[\ud38c]Spring ChainedTransactionManager \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud574\uc57c \ud558\ub098?","date":"2015-01-30","format":false,"excerpt":"\ub2e4\uc911\ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc88b\uc744 \uae00.. \u00a0 \u00a0 http:\/\/kwon37xi.egloos.com\/4886947 \u00a0 Spring ChainedTransactionManager \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud574\uc57c \ud558\ub098? \ud504\ub85c\uadf8\ub798\ubc0d by \uad8c\ub0a8 2014\/07\/12 18:13 kwon37xi.egloos.com\/4886947 \ub367\uae00\uc218 : 0 Spring Data Commons 1.6\uc5d0\ub294 ChainedTransactionManager\ub77c\ub294 \uac83\uc774 \ucd94\uac00 \ub3fc \uc788\ub2e4 \ud558\ub098\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c @Transactional \uc560\ub178\ud14c\uc774\uc158\uc744 \ud1b5\ud574 \ud2b8\ub79c\uc7ad\uc158\uc744 \uc7a1\uc544\uc904 \ub54c \uc5ec\ub7ec \ub370\uc774\ud130\uc18c\uc2a4(DataSource)\uc758 \ud2b8\ub79c\uc7ad\uc158 \ub9e4\ub2c8\uc800(Transaction Manager)\ub97c \ub530\ub85c\ub530\ub85c \uc9c0\uc815\ud574\uc11c\u2026","rel":"","context":"In "JAVA"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":61,"url":"https:\/\/blog.box.kr\/?p=61","url_meta":{"origin":653,"position":3},"title":"WebtoB + JEUS + web application","date":"2014-06-12","format":false,"excerpt":"WebtoB + JEUS + web application webgosu.egloos.com\/9123240 1. WebtoB \uc124\uce58 1.1 \uc124\uce58\ud30c\uc77c, \ub77c\uc774\uc13c\uc2a4(license.dat)\uc900\ube44 1.2 \ub77c\uc774\uc13c\uc2a4 \uc801\uc6a9 : webtoB4.1licenselicense.dat 2. WebToB \uc2e4\ud589 2.1 \uc2e4\ud589\ud30c\uc77c\uc0dd\uc131(wsconfig) --> \ud658\uacbd\ud30c\uc77c \ucef4\ud30c\uc77c : wscfl -i [\ud658\uacbd\ud30c\uc77c] 2.2 \uc2e4\ud589 : wsboot --> wsboot -w (handler\uac00 process\ub4e4\uc744 \ud655\uc778\ud558\uba70 booting->\uc548\uc815\uc801\uc778 booting) 2.3 \uc885\ub8cc : wsdown --> wsdown -i (\uc9c8\uc758\ub97c\u2026","rel":"","context":"In "JEUS & WEBToB"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":649,"url":"https:\/\/blog.box.kr\/?p=649","url_meta":{"origin":653,"position":4},"title":"[\ud38c]Tomcat7 tomcat-jdbc \uc124\uc815 – Broken pipe \uc5d0\ub7ec \ud68c\ud53c","date":"2015-04-05","format":false,"excerpt":"tomcat-jdbc\ub85c MySQL\uc5d0 \uc5f0\uacb0\ud55c \uacbd\uc6b0 \"java.net.SocketException: Broken pipe\" \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\ub97c \uac00\ub054 \ubcfc \uc218 \uc788\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 connection idle time\uc774 MySQL\uc5d0 \uc124\uc815\ub41c wait_timeout\uc744 \uc9c0\ub098\uc11c DB\uc5d0\uc11c \uc5f0\uacb0\uc744 \ub04a\uc740 \uac83\uc774\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\ub824\uba74 connection\uc774 \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 close\ub418\ub3c4\ub85d \uc124\uc815\ud558\uac70\ub098 connection \ub300\uc5ec\uc2dc\uc5d0 connection\uc744 \uccb4\ud06c\ud558\ub3c4\ub85d \ud558\uba74 \ub41c\ub2e4. \uc124\uc815 1 - \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 connection\uc744\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":375,"url":"https:\/\/blog.box.kr\/?p=375","url_meta":{"origin":653,"position":5},"title":"spring mybatis @Repository","date":"2014-09-15","format":false,"excerpt":"\u00a0 http:\/\/blog.naver.com\/PostView.nhn?blogId=vikong&logNo=60180414100 application-context.xml \u00a0 1) @Respository \ub85c DAO scanning \ubc0f bean \uc124\uc815 \ubb38\uc7a5 <\/context:component-scan> \u00a0 2) @Transactional \uc744 \uc704\ud55c \uc124\uc815 \ubb38\uc7a5 \u00a0 \u2026","rel":"","context":"In "\ucc38\uace0\ub97c \uc704\ud55c \uc800\uc7a5\ubb3c"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/653"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=653"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/653\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}