{"id":8775,"date":"2023-06-09T15:04:45","date_gmt":"2023-06-09T06:04:45","guid":{"rendered":"https:\/\/www.auctionpro.co.kr\/?p=8775"},"modified":"2025-12-23T16:33:02","modified_gmt":"2025-12-23T07:33:02","slug":"ubuntu-mysql-pool_size","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=8775","title":{"rendered":"ubuntu  mysql pool_size"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Overview :  InnoDB Status Buffer \uc0ac\uc774\uc988 \ub298\ub9ac\uae30<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1.MySQL Workbench -Dashboard &#8211; mysql 5.0 \uc774\uc0c1 \uc9c0\uc6d0<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"579\" src=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize-1024x579.png\" alt=\"\" class=\"wp-image-8776\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize-1024x579.png 1024w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize-300x170.png 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize-768x434.png 768w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize-660x373.png 660w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/ubuntu_buffersize.png 1152w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">2. mysql config \uc218\uc815<\/h2>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">sudo vi \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">3. \uc544\ub798\uc5d0 \ub7a8\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\uace0 \uc801\ub2f9\ud55c buffer \ucd94\uac00 <\/h2>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">innodb_buffer_pool_size  = 1G<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">4. mysql \ubc31\uc5c5\ub85c\uadf8 \uc77c\uc790\ubcc4 \uc800\uc7a5 \uae30\uac04 \ucd95\uc18c (\ud544\uc694\uc2dc)<\/h2>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">expire_logs_days = 2\n<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">4.1  max_connections = 151 default \ub97c 10 \uc73c\ub85c \uc218\uc815 <\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>max_connections = 10<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.1 \uc989\uc2dc(\uc7ac\uc2dc\uc791 \uc5c6\uc774) 10\uc73c\ub85c \ubc14\uafb8\uae30<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET GLOBAL max_connections = 10;\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc989\uc2dc \uc801\uc6a9<\/strong>\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>MySQL \uc7ac\uc2dc\uc791\ud558\uba74 \uc6d0\ub798 \uac12\uc73c\ub85c \ub3cc\uc544\uac08 \uc218<\/strong> \uc788\uc73c\ub2c8, \uc544\ub798 \u201c\uc601\uad6c \uc801\uc6a9\u201d\ub3c4 \uac19\uc774 \ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc774\ubbf8 10\uac1c \ucd08\uacfc\ub85c \uc5f0\uacb0\ub3fc \uc788\uc73c\uba74, \uae30\uc874 \uc5f0\uacb0\uc740 \uc720\uc9c0\ub418\uace0 <strong>\uc0c8 \uc5f0\uacb0\ubd80\ud130<\/strong> \uc81c\ud55c\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud604\uc7ac \uac12 \ud655\uc778:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW VARIABLES LIKE 'max_connections';<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">5. mysql \uc7ac\uc2dc\uc791<\/h2>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">sudo systemctl restart mysqld<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">5.MySQL Workbench -Dashboard \ud655\uc778<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"689\" src=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1-1024x689.png\" alt=\"\" class=\"wp-image-8777\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1-1024x689.png 1024w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1-300x202.png 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1-768x516.png 768w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1-660x444.png 660w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-1.png 1038w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Query<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"481\" src=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2-1024x481.png\" alt=\"\" class=\"wp-image-8779\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2-1024x481.png 1024w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2-300x141.png 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2-768x360.png 768w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2-1536x721.png 1536w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2-660x310.png 660w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/06\/image-2.png 1877w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Overview : InnoDB Status Buffer \uc0ac\uc774\uc988 \ub298\ub9ac\uae30 1.MySQL Workbench -Dashboard &#8211; mysql 5.0 \uc774\uc0c1 \uc9c0\uc6d0 2. mysql config \uc218\uc815 3. \uc544\ub798\uc5d0 \ub7a8\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\uace0 \uc801\ub2f9\ud55c buffer <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=8775\" title=\"ubuntu  mysql pool_size\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[88],"tags":[],"class_list":["post-8775","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8775"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8775\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}