Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

311 lines (208 sloc) 15.653 kb
<!DOCTYPE html>
<html lang="zh">
<head>
<title>DQW's Blog</title>
<meta charset="utf-8" />
<link href="http://www.dqw.me/feeds/all.atom.xml" type="application/atom+xml" rel="alternate" title="DQW's Blog Full Atom Feed" />
<!-- Mobile viewport optimized: j.mp/bplateviewport -->
<meta name="viewport" content="width=device-width,initial-scale=1, maximum-scale=1">
<link rel="stylesheet" type="text/css" href="http://www.dqw.me/theme/gumby.css" />
<link rel="stylesheet" type="text/css" href="http://www.dqw.me/theme/style.css" />
<link rel="stylesheet" type="text/css" href="http://www.dqw.me/theme/pygment.css" />
<script src="http://www.dqw.me/theme/js/libs/modernizr-2.6.2.min.js"></script>
</head>
<body id="index" class="home">
<div class="container">
<div class="row">
<header id="banner" class="body">
<h1><a href="http://www.dqw.me">DQW's Blog <strong>用适合的技术解决实际的问题</strong></a></h1>
</header><!-- /#banner -->
<div id="navigation" class="navbar row">
<a href="#" gumby-trigger="#navigation &gt; ul" class="toggle"><i class="icon-menu"></i></a>
<ul class="columns">
<li><a href="http://www.dqw.me">Home</a></li>
<li><a href="http://www.dqw.me/pages/about.html">About</a></li>
</ul>
</div>
<section id="content">
<div class="row">
<div class="eleven columns">
<ol id="post-list">
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/dokuwikixiu-gai-huan-cun-wen-jian-wei-zhi.html" rel="bookmark" title="Permalink to dokuwiki修改缓存文件位置">dokuwiki修改缓存文件位置</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2012-04-09T22:53:00"> 一 09 四月 2012 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> <p>用网盘同步时可以减少同步的文件,在conf下新建local.protected.php</p> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/dokuwikixiu-gai-huan-cun-wen-jian-wei-zhi.html" rel="bookmark" title="Permalink to dokuwiki修改缓存文件位置">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/dokuwiki.html">dokuwiki</a>
</div>
</article></li>
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/mysqlsuo-yin-zong-jie.html" rel="bookmark" title="Permalink to MySQL索引总结">MySQL索引总结</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2012-01-30T22:53:00"> 一 30 一月 2012 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> <p>系统中最频繁的操作应该就是查询操作了,使用索引可快速访问表中的特定信息,提高查询和排序的操作效率。在关系数据库中,索引是一种与表有关的数据库结构,它可以使对应于表的SQL语句执行得更快。 索引的作用相当于图书的目录,可以根据目录中的页码快速找到所需的内容。当表中有大量记录时如果没有索引,查询时需要对表中的记录逐一匹配,这样做会消耗大量数据库系统时间,并造成大量磁盘I/O操作。索引提供指向存储在表的指定列中的数据值的指针,然后根据您指定的排序顺序对这些指针排序。数据库使用索引的方式与书籍中的索引的方式很相似,它搜索索引以找到特定值,然后顺指针找到包含该值的行。</p> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/mysqlsuo-yin-zong-jie.html" rel="bookmark" title="Permalink to MySQL索引总结">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/mysql.html">MySQL</a>
<a class="danger label" href="http://www.dqw.me/tag/suo-yin.html">索引</a>
</div>
</article></li>
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/yin-hao-dui-mysqlcha-xun-xing-neng-de-ying-xiang.html" rel="bookmark" title="Permalink to 引号对MySQL查询性能的影响">引号对MySQL查询性能的影响</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2012-01-30T22:53:00"> 一 30 一月 2012 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/yin-hao-dui-mysqlcha-xun-xing-neng-de-ying-xiang.html" rel="bookmark" title="Permalink to 引号对MySQL查询性能的影响">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/mysql.html">MySQL</a>
</div>
</article></li>
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/shi-yong-cconvpi-liang-jian-ti-zhuan-fan-ti.html" rel="bookmark" title="Permalink to 使用cconv批量简体转繁体">使用cconv批量简体转繁体</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2011-11-09T22:53:00"> 三 09 十一月 2011 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> <p>cconv是一个批量简繁转换项目,目前只能在linux下使用,<a href="http://code.google.com/p/cconv/">项目地址</a></p> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/shi-yong-cconvpi-liang-jian-ti-zhuan-fan-ti.html" rel="bookmark" title="Permalink to 使用cconv批量简体转繁体">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/cconv.html">cconv</a>
</div>
</article></li>
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/apachezui-jian-dan-de-url-rewrite.html" rel="bookmark" title="Permalink to apache最简单的url rewrite">apache最简单的url rewrite</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2011-11-06T22:53:00"> 日 06 十一月 2011 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/apachezui-jian-dan-de-url-rewrite.html" rel="bookmark" title="Permalink to apache最简单的url rewrite">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/apache.html">apache</a>
<a class="danger label" href="http://www.dqw.me/tag/rewrite.html">rewrite</a>
</div>
</article></li>
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/zong-jie-phpde-this-self-parent.html" rel="bookmark" title="Permalink to 总结php的->、::、this、self、parent">总结php的->、::、this、self、parent</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2011-11-06T22:53:00"> 日 06 十一月 2011 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/zong-jie-phpde-this-self-parent.html" rel="bookmark" title="Permalink to 总结php的->、::、this、self、parent">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/php.html">php</a>
</div>
</article></li>
<li><article class="hentry">
<header> <h2 class="entry-title"><a href="http://www.dqw.me/mysql-replication.html" rel="bookmark" title="Permalink to mysql replication">mysql replication</a></h2> </header>
<footer class="post-info">
<abbr class="published" title="2011-10-19T22:53:00"> 三 19 十月 2011 </abbr>
<address class="vcard author">By <a class="url fn" href="http://www.dqw.me/author/dqw.html">dqw</a></address> </footer><!-- /.post-info -->
<div class="entry-content"> <p>mysql的replication是基于二进制日志的,按照手册配置就可以了,配置很简单</p> </div><!-- /.entry-content -->
<div class="medium primary btn"><a href="http://www.dqw.me/mysql-replication.html" rel="bookmark" title="Permalink to mysql replication">Read more <i class="icon-arrow-right"></i></a></div>
<div class="row tag-row">
<span>Tagged as : </span>
<a class="danger label" href="http://www.dqw.me/tag/mysql.html">mysql</a>
<a class="danger label" href="http://www.dqw.me/tag/replication.html">replication</a>
</div>
</article></li>
</ol><!-- /#posts-list -->
</div><!-- /.eleven.columns -->
<div class="three columns">
<h4>Pages</h4>
<ul>
<li><a href="http://www.dqw.me/pages/about.html">About</a></li>
</ul>
<h4>Categories</h4>
<ul>
<li><a href="http://www.dqw.me/category/apache.html">apache</a></li>
<li><a href="http://www.dqw.me/category/centos.html">centos</a></li>
<li><a href="http://www.dqw.me/category/dokuwiki.html">dokuwiki</a></li>
<li><a href="http://www.dqw.me/category/javascript.html">javascript</a></li>
<li><a href="http://www.dqw.me/category/linux.html">Linux</a></li>
<li><a href="http://www.dqw.me/category/macos.html">macos</a></li>
<li><a href="http://www.dqw.me/category/mysql.html">MySQL</a></li>
<li><a href="http://www.dqw.me/category/other.html">other</a></li>
<li><a href="http://www.dqw.me/category/pelican.html">pelican</a></li>
<li><a href="http://www.dqw.me/category/php.html">php</a></li>
<li><a href="http://www.dqw.me/category/xie-yi.html">协议</a></li>
</ul>
<h4>Tags</h4>
<ul>
<li class="tag-4"><a href="http://www.dqw.me/tag/github.html">github</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/pelican.html">pelican</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/.html"></a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/ubuntu.html">Ubuntu</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/http.html">http</a></li>
<li class="tag-2"><a href="http://www.dqw.me/tag/nginx.html">nginx</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/suo-yin.html">索引</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/https.html">https</a></li>
<li class="tag-2"><a href="http://www.dqw.me/tag/macos.html">macos</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/replication.html">replication</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/cconv.html">cconv</a></li>
<li class="tag-2"><a href="http://www.dqw.me/tag/centos.html">centos</a></li>
<li class="tag-2"><a href="http://www.dqw.me/tag/apache.html">apache</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/homebrew.html">homebrew</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/xie-yi.html">协议</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/rewrite.html">rewrite</a></li>
<li class="tag-0"><a href="http://www.dqw.me/tag/mysql.html">mysql</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/vga.html">VGA</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/dokuwiki.html">dokuwiki</a></li>
<li class="tag-2"><a href="http://www.dqw.me/tag/php.html">php</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/cookie.html">cookie</a></li>
<li class="tag-2"><a href="http://www.dqw.me/tag/fen-bian-lu.html">分辨率</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/shu-zu.html">数组</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/javascript.html">javascript</a></li>
<li class="tag-4"><a href="http://www.dqw.me/tag/zim.html">zim</a></li>
</ul>
<nav class="widget">
<h4>LINKS</h4>
<ul>
<li><a href="feeds/all.atom.xml" target="_blank">RSS</a></li>
<li><a href="https://github.com/dqw" target="_blank">github</a></li>
<li><a href="http://www.douban.com/people/47947350/" target="_blank">douban</a></li>
<li><a href="http://dqw3721.blog.51cto.com/" target="_blank">以前51cto上的Blog</a></li>
<li><a href="http://dqw3721.cnblogs.com/" target="_blank">以前cnblogs上的Blog</a></li>
<li><a href="http://www.dqw.me/sitemap.xml" target="_blank">sitemap</a></li>
</ul>
</nav>
</div> </div><!-- /.row -->
<p class="paginator">
<a href="http://www.dqw.me/index.html"><i class="icon-arrow-left"></i></a>
Page 2 / 2
</p>
</section><!-- /#content -->
</div><!-- /.row -->
</div><!-- /.container -->
<div class="container.nopad bg">
<footer id="credits" class="row">
<div class="seven columns left-center">
<address id="about" class="vcard body">
Proudly powered by <a href="http://getpelican.com/">Pelican</a>,
which takes great advantage of <a href="http://python.org">Python</a>.
<br />
Based on the <a target="_blank" href="http://gumbyframework.com">Gumby Framework</a>
</address>
</div>
<div class="seven columns">
<div class="row">
<ul class="socbtns">
</ul>
</div>
</div>
</footer>
</div>
<script src="http://www.dqw.me/theme/js/libs/jquery-1.9.1.min.js"></script>
<script src="http://www.dqw.me/theme/js/libs/gumby.min.js"></script>
<script src="http://www.dqw.me/theme/js/plugins.js"></script>
</body>
</html>
Jump to Line
Something went wrong with that request. Please try again.