<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/boby16</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; boby16]]></copyright><item><title><![CDATA[DES\RSA加密解密简单用法]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/51492621</link><guid>https://blog.youkuaiyun.com/boby16/article/details/51492621</guid><author>boby16</author><pubDate>Tue, 24 May 2016 18:45:03 +0800</pubDate><description><![CDATA[DES\RSA加密解密简单用法]]></description><category></category></item><item><title><![CDATA[mongoDB 3.0 安全权限访问控制]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/51330384</link><guid>https://blog.youkuaiyun.com/boby16/article/details/51330384</guid><author>boby16</author><pubDate>Fri, 06 May 2016 11:42:42 +0800</pubDate><description><![CDATA[MongoDB]]></description><category></category></item><item><title><![CDATA[Mongodb中Security介绍]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/51330074</link><guid>https://blog.youkuaiyun.com/boby16/article/details/51330074</guid><author>boby16</author><pubDate>Fri, 06 May 2016 11:24:10 +0800</pubDate><description><![CDATA[MongoDB]]></description><category></category></item><item><title><![CDATA[MongoDB下载&安装&启动（Windows7 64位）]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/51221474</link><guid>https://blog.youkuaiyun.com/boby16/article/details/51221474</guid><author>boby16</author><pubDate>Fri, 22 Apr 2016 17:17:20 +0800</pubDate><description><![CDATA[MongoDB下载&安装&启动（Windows7 64位）]]></description><category></category></item><item><title><![CDATA[MySQL pivot table query with dynamic columns(mysql 行转列)]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/50972597</link><guid>https://blog.youkuaiyun.com/boby16/article/details/50972597</guid><author>boby16</author><pubDate>Thu, 24 Mar 2016 16:12:14 +0800</pubDate><description><![CDATA[转自：http://stackoverflow.com/questions/12598120/mysql-pivot-table-query-with-dynamic-columns


delimiter //

  create procedure myPivot(
    in tableA varchar(255),
    in columnA varchar(255),
    ]]></description><category></category></item><item><title><![CDATA[测试工具收藏]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/46226463</link><guid>https://blog.youkuaiyun.com/boby16/article/details/46226463</guid><author>boby16</author><pubDate>Fri, 29 May 2015 10:39:13 +0800</pubDate><description><![CDATA[1、新一代服务器性能测试工具 http://www.infoq.com/cn/articles/new-generation-server-testing-tool-gatling/
2、Robot Framework自动化测试 http://www.cnblogs.com/fnng/p/3871712.html 
3、渗透测试工具 http://www.freebuf.com/tools/5]]></description><category></category></item><item><title><![CDATA[mysql总结之explain]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/44201861</link><guid>https://blog.youkuaiyun.com/boby16/article/details/44201861</guid><author>boby16</author><pubDate>Wed, 11 Mar 2015 17:35:07 +0800</pubDate><description><![CDATA[文章转自：http://www.jb51.net/article/29769.htm




最近看了一些explain方面的资料，但是感觉网上的都差不多，基本也和manual差不多，所以自己总结了些，有些不明白的已经用黄色底色标出，希望各位拍砖


explain主要用于sql语句中的select查询，可以显示的查看该sql语句索引的命中情况，从而更好的利用索引、优化查询效率。]]></description><category></category></item><item><title><![CDATA[MySQL 加锁处理分析]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/44063897</link><guid>https://blog.youkuaiyun.com/boby16/article/details/44063897</guid><author>boby16</author><pubDate>Wed, 04 Mar 2015 18:56:29 +0800</pubDate><description><![CDATA[文章转自：http://hedengcheng.com/?p=771




1    背景    1


1.1    MVCC：Snapshot
 Read vs Current Read    2


1.2    Cluster
 Index：聚簇索引    3


1.3    2PL：Two-Phase
 Locking    3


1.4  ]]></description><category></category></item><item><title><![CDATA[SHOW INNODB STATUS  详解]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/44036001</link><guid>https://blog.youkuaiyun.com/boby16/article/details/44036001</guid><author>boby16</author><pubDate>Tue, 03 Mar 2015 11:30:42 +0800</pubDate><description><![CDATA[文章转自：http://blog.itpub.net/7916042/viewspace-1058867/
 
很多人让我来阐述一下 SHOW INNODB STATUS 的输出信息, 了解 SHOW  INNODB STATUS 都输出了些什么信息，并且我们能从这些信息中获取什么资讯，得以提高 MySQL 性能。

首先，让我们来了解一下 SHOW INNODB STATUS 输出的基础]]></description><category></category></item><item><title><![CDATA[如何查询mysql事务未提交]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/44035805</link><guid>https://blog.youkuaiyun.com/boby16/article/details/44035805</guid><author>boby16</author><pubDate>Tue, 03 Mar 2015 11:20:25 +0800</pubDate><description><![CDATA[文章转自：http://yueliangdao0608.blog.51cto.com/397025/1180917
 
如果遇到死锁了，怎么解决呢？找到原始的锁ID，然后KILL掉一直持有的那个线程就可以了， 但是众多线程，可怎么找到引起死锁的线程ID呢？ MySQL 发展到现在，已经非常强大了，这个问题很好解决。 直接从数据字典连查找。
 
我们来演示下。


线程A，我们用来锁定]]></description><category></category></item><item><title><![CDATA[MySQL Innodb表导致死锁日志情况分析与归纳]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/44035713</link><guid>https://blog.youkuaiyun.com/boby16/article/details/44035713</guid><author>boby16</author><pubDate>Tue, 03 Mar 2015 11:15:14 +0800</pubDate><description><![CDATA[文章转载自：http://www.jb51.net/article/32651.htm
 
案例描述
在定时脚本运行过程中，发现当备份表格的sql语句与删除该表部分数据的sql语句同时运行时，mysql会检测出死锁，并打印出日志。
两个sql语句如下：
（1）insert into backup_table select * from source_table
（2）DELETE FR]]></description><category></category></item><item><title><![CDATA[实例讲解.NET中资源文件的创建与使用(转)]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6330465</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6330465</guid><author>boby16</author><pubDate>Mon, 18 Apr 2011 10:11:00 +0800</pubDate><description><![CDATA[实例讲解.NET中资源文件的创建与使用
]]></description><category></category></item><item><title><![CDATA[iis7整合模式]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6246367</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6246367</guid><author>boby16</author><pubDate>Sun, 13 Mar 2011 15:03:00 +0800</pubDate><description><![CDATA[iis7]]></description><category></category></item><item><title><![CDATA[C#中如何插入照片到Excel]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6202292</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6202292</guid><author>boby16</author><pubDate>Wed, 23 Feb 2011 13:50:00 +0800</pubDate><description><![CDATA[C#中如何插入照片到Excel]]></description><category></category></item><item><title><![CDATA[System.Timers]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6126462</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6126462</guid><author>boby16</author><pubDate>Mon, 10 Jan 2011 11:24:00 +0800</pubDate><description><![CDATA[System.Timers]]></description><category></category></item><item><title><![CDATA[C#中timer类]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6126232</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6126232</guid><author>boby16</author><pubDate>Mon, 10 Jan 2011 10:06:00 +0800</pubDate><description><![CDATA[C#中timer类]]></description><category></category></item><item><title><![CDATA[（转）ADO.NET中的多数据表操作浅析之读取方案]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6122035</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6122035</guid><author>boby16</author><pubDate>Fri, 07 Jan 2011 10:55:00 +0800</pubDate><description><![CDATA[ADO.NET中的多数据表操作浅析之读取方案]]></description><category></category></item><item><title><![CDATA[用SqlCommandBuilder实现批量更新]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/6121916</link><guid>https://blog.youkuaiyun.com/boby16/article/details/6121916</guid><author>boby16</author><pubDate>Fri, 07 Jan 2011 10:18:00 +0800</pubDate><description><![CDATA[SqlCommandBuilder]]></description><category></category></item><item><title><![CDATA[SQL自动编号 通过select生成自增长列的办法 应用在各种SQL排名中]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/5897523</link><guid>https://blog.youkuaiyun.com/boby16/article/details/5897523</guid><author>boby16</author><pubDate>Mon, 20 Sep 2010 17:07:00 +0800</pubDate><description><![CDATA[SQL自动编号 通过select生成自增长列的办法 应用在各种SQL排名中]]></description><category></category></item><item><title><![CDATA[(转).net使用Office组件读取Excel，引用Microsoft.Office.Interop.Excel出现的问题]]></title><link>https://blog.youkuaiyun.com/boby16/article/details/5895041</link><guid>https://blog.youkuaiyun.com/boby16/article/details/5895041</guid><author>boby16</author><pubDate>Sun, 19 Sep 2010 17:09:00 +0800</pubDate><description><![CDATA[.net使用Office组件读取Excel，引用Microsoft.Office.Interop.Excel出现的问题]]></description><category></category></item></channel></rss>