MySQL별책부록39 3. MySQL에서 배치작업 잘 처리하는 방법 <span class="date">2010. 3. 7.</span> </span> </a> </div> <div class="post-item"> <a href="/36"> <span class="thum"> </span> <span class="title">2. mysqldump시 발생할 수 있는 lock 현상에 대한 정리</span> <span class="excerpt"></span> <span class="meta"> <span class="date">2010. 3. 7.</span> </span> </a> </div> <div class="post-item"> <a href="/54"> <span class="thum"> </span> <span class="title">1. InnoDB에서 Deadlock 발생 내역 분석하기</span> <span class="excerpt"><IFRAME onresizestart="return false" height=250 border=0 src="http://gift.blog.daum.net/widget?entry..</span> <span class="meta"> <span class="date">2010. 3. 7.</span> </span> </a> </div> </div> <div class="pagination"> <a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D?page=9" class="prev ">이전</a> <a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D?page=1"><span class="">1</span></a> <a ><span class="">···</span></a> <a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D?page=7"><span class="">7</span></a> <a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D?page=8"><span class="">8</span></a> <a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D?page=9"><span class="">9</span></a> <a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D?page=10"><span class="selected">10</span></a> <a class="next no-more-next">다음</a> </div> </article> <aside id="aside" class="sidebar"> <div class="sidebar-1"> <!-- 카테고리 --> <nav class="category"> <ul class="tt_category"><li class=""><a href="/category" class="link_tit"> 강의 목록 </a> <ul class="category_list"><li class=""><a href="/category/MySQL%20News%26Article" class="link_item"> MySQL News&Article </a></li> <li class=""><a href="/category/MySQL%20Admin%20Guide" class="link_item"> MySQL Admin Guide </a> <ul class="sub_category_list"><li class=""><a href="/category/MySQL%20Admin%20Guide/MySQL%20Test" class="link_sub_item"> MySQL Test </a></li> <li class=""><a href="/category/MySQL%20Admin%20Guide/MySQL%20Ver.5.1%20Admin%20Guide" class="link_sub_item"> MySQL Ver.5.1 Admin Guide </a></li> <li class=""><a href="/category/MySQL%20Admin%20Guide/MySQL%20Ver.5.6%20Admin%20Guide" class="link_sub_item"> MySQL Ver.5.6 Admin Guide </a></li> <li class=""><a href="/category/MySQL%20Admin%20Guide/MySQL%20Ver.%208.0%20Admin%20Guide" class="link_sub_item"> MySQL Ver. 8.0 Admin Guide </a></li> </ul> </li> <li class=""><a href="/category/MySQL%20Internal" class="link_item"> MySQL Internal </a> <ul class="sub_category_list"><li class=""><a href="/category/MySQL%20Internal/InnoDB%20Internal" class="link_sub_item"> InnoDB Internal </a></li> <li class=""><a href="/category/MySQL%20Internal/MySQL%20Internal" class="link_sub_item"> MySQL Internal </a></li> </ul> </li> <li class=""><a href="/category/MySQL%20HA%20%26%20DR" class="link_item"> MySQL HA & DR </a> <ul class="sub_category_list"><li class=""><a href="/category/MySQL%20HA%20%26%20DR/Replication%20" class="link_sub_item"> Replication </a></li> <li class=""><a href="/category/MySQL%20HA%20%26%20DR/Multi-Source%20Replication" class="link_sub_item"> Multi-Source Replication </a></li> <li class=""><a href="/category/MySQL%20HA%20%26%20DR/Group%20Replication" class="link_sub_item"> Group Replication </a></li> <li class=""><a href="/category/MySQL%20HA%20%26%20DR/%EA%B8%B0%ED%83%80%20" class="link_sub_item"> 기타 </a></li> </ul> </li> <li class=""><a href="/category/MySQL%20Tool%20" class="link_item"> MySQL Tool </a></li> <li class="selected"><a href="/category/MySQL%EB%B3%84%EC%B1%85%EB%B6%80%EB%A1%9D" class="link_item"> MySQL별책부록 </a></li> <li class=""><a href="/category/MySQL%20%EC%97%90%EB%9F%AC%20%EC%B2%98%EB%A6%AC%EB%B2%95" class="link_item"> MySQL 에러 처리법 </a></li> <li class=""><a href="/category/%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC%20%EC%9C%84%ED%95%9C%20MySQL%20" class="link_item"> 개발자를 위한 MySQL </a> <ul class="sub_category_list"><li class=""><a href="/category/%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC%20%EC%9C%84%ED%95%9C%20MySQL%20/Partitioning" class="link_sub_item"> Partitioning </a></li> <li class=""><a href="/category/%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC%20%EC%9C%84%ED%95%9C%20MySQL%20/Query%20Tuning%20%EA%B8%B0%EC%88%A0" class="link_sub_item"> Query Tuning 기술 </a></li> <li class=""><a href="/category/%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC%20%EC%9C%84%ED%95%9C%20MySQL%20/%EA%B8%B0%ED%83%80" class="link_sub_item"> 기타 </a></li> </ul> </li> <li class=""><a href="/category/DBMS%EA%B8%B0%EC%B4%88" class="link_item"> DBMS기초 </a></li> <li class=""><a href="/category/MySQL%20Backup%20Tool%20Reference" class="link_item"> MySQL Backup Tool Reference </a> <ul class="sub_category_list"><li class=""><a href="/category/MySQL%20Backup%20Tool%20Reference/PerconaXtraBackup" class="link_sub_item"> PerconaXtraBackup </a></li> </ul> </li> </ul> </li> </ul> </nav> </div> <div class="sidebar-2"> <!-- 공지사항 --> <div class="notice"> <h2>공지사항</h2> <ul> <li><a href="/notice/365">엉망이 된 홈화면을 변경했습니다.</a></li> <li><a href="/notice/306">MySQL 기술 소개 및 안내 블로그입니다.</a></li> <li><a href="/notice/182">MySQL Ver. 5.6 Admin 강의 시⋯</a></li> <li><a href="/notice/176">요새 글을 못쓰고 있네요.</a></li> <li><a href="/notice/171">작고 조용한 내 사이트에...이게 몬일인지..⋯</a></li> <li><a href="/notice/170">공격사이트라고 해서 처리하고 있습니다.</a></li> <li><a href="/notice/168">스킨변경했어요~~</a></li> <li><a href="/notice/151">Ver.5.5 Semi Synchronus R⋯</a></li> <li><a href="/notice/149">InnoDB 1.1 관련 글 올렸습니다.</a></li> <li><a href="/notice/134">MySQL Partition 올려요.</a></li> </ul> </div> <!-- 최근글/인기글 --> <div class="post-list tab-ui"> <div id="recent" class="tab-list"> <h2>최근글</h2> <ul> </ul> </div> <div id="popular" class="tab-list"> <h2>인기글</h2> <ul> </ul> </div> </div> <!-- 최근댓글 --> <div class="recent-comment"> <h2>최근댓글</h2> <ul> </ul> </div> <!-- Facebook/Twitter --> <div class="social-list tab-ui"> </div> <!-- 태그 --> <div class="tags"> <h2>태그</h2> <a href="/tag/TCmalloc">TCmalloc</a> <a href="/tag/mysql%20%ED%8C%8C%ED%8B%B0%EC%85%98">mysql 파티션</a> <a href="/tag/show%20%EA%B5%AC%EB%AC%B8">show 구문</a> <a href="/tag/privileges">privileges</a> <a href="/tag/mysqldump">mysqldump</a> <a href="/tag/mysql%20partitioning">mysql partitioning</a> <a href="/tag/Spatial%20Data">Spatial Data</a> <a href="/tag/innobackupex">innobackupex</a> <a href="/tag/innodb%201.1">innodb 1.1</a> <a href="/tag/8.0">8.0</a> <a href="/tag/information_schema">information_schema</a> <a href="/tag/xtrabackup">xtrabackup</a> <a href="/tag/mysql%20partition">mysql partition</a> <a href="/tag/mysql%20replication">mysql replication</a> <a href="/tag/replication">replication</a> <a href="/tag/Bug%20Fix">Bug Fix</a> <a href="/tag/innodb">innodb</a> <a href="/tag/timestamp">timestamp</a> <a href="/tag/datetime">datetime</a> <a href="/tag/%EA%B3%B5%EA%B0%84%20%EB%8D%B0%EC%9D%B4%ED%84%B0">공간 데이터</a> <a href="/tag/binary%20log">binary log</a> <a href="/tag/grant">grant</a> <a href="/tag/Spatial%20Function">Spatial Function</a> <a href="/tag/MySQL%20Ver.%205.7">MySQL Ver. 5.7</a> <a href="/tag/partition">partition</a> <a href="/tag/%EA%B3%B5%EA%B0%84%20%ED%95%A8%EC%88%98">공간 함수</a> <a href="/tag/MySQL%20Ver.%208.0">MySQL Ver. 8.0</a> <a href="/tag/mysql">mysql</a> <a href="/tag/View">View</a> <a href="/tag/Mysql%205.5">Mysql 5.5</a> </div> <!-- 전체 방문자 --> <div class="count"> <h2>전체 방문자</h2> <p class="total"></p> <p>Today : </p> <p>Yesterday : </p> </div> <!-- 소셜 채널 --> <div class="social-channel"> <ul> </ul> </div> </div> </aside> </div> </section> <hr> <footer id="footer"> <div class="inner"> <div class="order-menu"> </div> <a href="#" class="page-top">TOP</a> <p class="meta">Designed by 티스토리</p> <p class="copyright">© Kakao Corp.</p> </div> </footer> </div> <script src="https://tistory1.daumcdn.net/tistory/0/BookClub/images/script.js"></script> <div class="#menubar menu_toolbar "> <h2 class="screen_out">티스토리툴바</h2> <div class="btn_tool btn_tool_type1" id="menubar_wrapper"></div><div class="btn_tool"><button class="btn_menu_toolbar btn_subscription #subscribe" data-blog-id="319338" data-url="https://mysqldba.tistory.com" data-device="web_pc"><strong class="txt_tool_id">MySQL DBA를 위한</strong><em class="txt_state">구독하기</em><span class="img_common_tistory ico_check_type1"></span></button></div></div> <div class="layer_tooltip"> <div class="inner_layer_tooltip"> <p class="desc_g"></p> </div> </div> <iframe id="editEntry" style="position:absolute;width:1px;height:1px;left:-100px;top:-100px" src="//mysqldba.tistory.com/api">