index.html

<!DOCTYPE html>
<html>

  <head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1">

  <title>FlashSQL 기술 블로그</title>
  <meta name="description" content="">
  
  <meta name="author" content="FlashSQL">
  <meta name="copyright" content="&copy; FlashSQL 2019">
  

  <!-- External libraries -->
  <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css">
  <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.9.0/styles/monokai-sublime.min.css">
  <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/lightbox2/2.7.1/css/lightbox.css">

  <!-- Favicon and other icons (made with http://www.favicon-generator.org/) -->
  <link rel="shortcut icon" href="/assets/icons/favicon.ico" type="image/x-icon">
  <link rel="icon" href="/assets/icons/favicon.ico" type="image/x-icon">
  <link rel="apple-touch-icon" sizes="57x57" href="/assets/icons/apple-icon-57x57.png">
  <link rel="apple-touch-icon" sizes="60x60" href="/assets/icons/apple-icon-60x60.png">
  <link rel="apple-touch-icon" sizes="72x72" href="/assets/icons/apple-icon-72x72.png">
  <link rel="apple-touch-icon" sizes="76x76" href="/assets/icons/apple-icon-76x76.png">
  <link rel="apple-touch-icon" sizes="114x114" href="/assets/icons/apple-icon-114x114.png">
  <link rel="apple-touch-icon" sizes="120x120" href="/assets/icons/apple-icon-120x120.png">
  <link rel="apple-touch-icon" sizes="144x144" href="/assets/icons/apple-icon-144x144.png">
  <link rel="apple-touch-icon" sizes="152x152" href="/assets/icons/apple-icon-152x152.png">
  <link rel="apple-touch-icon" sizes="180x180" href="/assets/icons/apple-icon-180x180.png">
  <link rel="icon" type="image/png" sizes="192x192"  href="/assets/icons/android-icon-192x192.png">
  <link rel="icon" type="image/png" sizes="32x32" href="/assets/icons/favicon-32x32.png">
  <link rel="icon" type="image/png" sizes="96x96" href="/assets/icons/favicon-96x96.png">
  <link rel="icon" type="image/png" sizes="16x16" href="/assets/icons/favicon-16x16.png">
  <link rel="manifest" href="/assets/icons/manifest.json">
  <meta name="msapplication-TileColor" content="#ffffff">
  <meta name="msapplication-TileImage" content="/assets/icons/ms-icon-144x144.png">
  <meta name="theme-color" content="#ffffff">

  
  <!-- Facebook OGP cards -->
  <meta property="og:description" content="" />
  <meta property="og:url" content="http://flashsql.github.io" />
  <meta property="og:site_name" content="FlashSQL 기술 블로그" />
  <meta property="og:title" content="FlashSQL 기술 블로그" />
  <meta property="og:type" content="website" />
  <meta property="og:image" content="http://flashsql.github.io/assets/vldb_logo.png" />
  <meta property="og:image:type" content="image/png" />
  <meta property="og:image:width" content="612" />
  <meta property="og:image:height" content="605" />
  

  <!-- Site styles -->
  <link rel="stylesheet" href="/css/main.css">
  <link rel="canonical" href="http://flashsql.github.io/">
  <link rel="alternate" type="application/rss+xml" title="FlashSQL 기술 블로그" href="http://flashsql.github.io/feed.xml" />
</head>


  <body>

    <header class="navigation" role="banner">
  <div class="navigation-wrapper">
    <a href="/" class="logo">
      
      <img src="/assets/vldb_web_logo.png" alt="FlashSQL 기술 블로그">
      
    </a>
    <a href="javascript:void(0)" class="navigation-menu-button" id="js-mobile-menu">
      <i class="fa fa-bars"></i>
    </a>
    <nav role="navigation">
      <ul id="js-navigation-menu" class="navigation-menu show">
        
          
          <li class="nav-link"><a href="/category/mysql/">MySQL</a>
          
        
          <li class="nav-link"><a href="/category/rocksdb/">RocksDB</a>
          
        
          <li class="nav-link"><a href="/category/flash/">Flash</a>
          
        
      </ul>
    </nav>
  </div>
</header>


    <div class="page-content">
        <div class="home">

<div class="site-header-container has-cover" style="background-image: url(/assets/header_image.jpg);">
  <div class="scrim has-cover">
    <header class="site-header">
      <h1 class="title">FlashSQL 기술 블로그</h1>
      <p class="subtitle">비휘발성 메모리 기반 개방형 고성능 DBMS 개발</p>
    </header>
  </div>
</div>

<div class="wrapper">
<ul class="post-list">
  
  <li>
    <h2>
      <a class="post-link" href="/mysql/2018/04/18/test9.html">Punch Hole</a>
    </h2>
    <section class="post-author">
      <i class="fa fa-user"></i>
      By <font color="#e74c3c">Mijin An</font>
    </section>
    <section class="post-excerpt" itemprop="description">
      <p>Punch hole 아래 두 자료 참고해서 정리 InnoDB Transparent Page Compression MySQL 5.7 Manual Transparent Page Compression InnoDB는 file-per-table 테이블스페이스에 존재하는 테이블에 대해 페이지 레벨 압축을 지원한다. 이는 Transparent Page Compression 라 불린다. 페이지 압축은 CREATE TABLE 또는 ALTER TABLE 문에 COMPRESSION attribute를 명시하여 사용할 수 있으며, Zlib과 LZ4 압축...</p>
    </section>
    <section class="post-meta">
      <div class="post-date">2018-04-18</div>
      <div class="post-categories">
       
        
        <a href="/category/mysql" class="tag">MySQL</a>
        
      
      </div>
    </section>
  </li>
  
  <hr>
  
  
  <li>
    <h2>
      <a class="post-link" href="/mysql/flash/2018/04/18/test.html">Test</a>
    </h2>
    <section class="post-author">
      <i class="fa fa-user"></i>
      By <font color="#e74c3c">Mijin An</font>
    </section>
    <section class="post-excerpt" itemprop="description">
      <p>Linux 시스템에서 파일 시스템의 블록 크기는 hole punching에 사용되는 단위 크기다. 따라서, 페이지 압축은 InnoDB 페이지 크기 - 파일 시스템 블록 크기보다 작거나 같은 크기로 압축될 수 있는 경우에만 작동한다. 예를 들어, innodb_page_size가 16KB고 파일 시스템 블록 크기가 4KB인 경우, hole punching을 가능하게 하려면 페이지 데이터를 12KB 이하로 압축해야 한다....</p>
    </section>
    <section class="post-meta">
      <div class="post-date">2018-04-18</div>
      <div class="post-categories">
       
        
        <a href="/category/mysql" class="tag">MySQL</a>
        
      
        <a href="/category/flash" class="tag">Flash</a>
        
      
      </div>
    </section>
  </li>
  
  <hr>
  
  
  <li>
    <h2>
      <a class="post-link" href="/mysql/rocksdb/2015/04/18/dummy.html">Dummy Post</a>
    </h2>
    <section class="post-author">
      <i class="fa fa-user"></i>
      By <font color="#e74c3c">Ben Centra</font>
    </section>
    <section class="post-excerpt" itemprop="description">
      <p>This is just a dummy post. Lorem ipsum and all the rest. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute...</p>
    </section>
    <section class="post-meta">
      <div class="post-date">2015-04-18</div>
      <div class="post-categories">
       
        
        <a href="/category/mysql" class="tag">MySQL</a>
        
      
        <a href="/category/rocksdb" class="tag">RocksDB</a>
        
      
      </div>
    </section>
  </li>
  
  
</ul>

<nav class="pagination" role="navigation">
  
  <li class="page-prev">
    <i class="fa fa-chevron-left" aria-hidden="true"></i>
  </li>
  

    <li class="page-number active">1</li>
    
  
  <li class="page-next">
    <i class="fa fa-chevron-right" aria-hidden="true"></i>
  </li>
  
</nav>

</div>
</div>

    </div>

    <footer class="site-footer">
  <ul class="links">
    
      
      <li>
        <a href="https://github.com/flashsql" title="Fork me on GitHub">
          <i class="fa fa-github"></i>
        </a>
      </li>
      
    
    <li>
        <a href="/feed.xml">
            <i class="fa fa-rss"></i>
        </a>
    </li>
    <li>
      <a href="mailto:vldb.skku@gmail.com">
        <i class="fa fa-envelope-o"></i>
      </a>
    </li>
  </ul>

  <ul class="footer-menu">
    <li><a href="http://flashsql.skku.ac.kr">FlashSQL</a></li>
    <li><a href="http://vldb.skku.edu">VLDB Lab.</a></li>
  </ul>

  <p class="copyright">
    <a href="http://vldb.skku.edu">Copyright Sungkyunkwan University VLDB Lab.</a>
    All rights reserved.
  </p>

</footer>

<!-- Scripts -->
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/highlight.js/8.5/highlight.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/lightbox2/2.7.1/js/lightbox.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
  // Default syntax highlighting
  hljs.initHighlightingOnLoad();

  // Header
  var menuToggle = $('#js-mobile-menu').unbind();
  $('#js-navigation-menu').removeClass("show");
  menuToggle.on('click', function(e) {
    e.preventDefault();
    $('#js-navigation-menu').slideToggle(function(){
      if($('#js-navigation-menu').is(':hidden')) {
        $('#js-navigation-menu').removeAttr('style');
      }
    });
  });
});

</script>


  </body>

</html>