<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[davis的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/davis2015csdn</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; davis2015csdn]]></copyright><item><title><![CDATA[一台windows主机安装多个mysql服务]]></title><link>https://blog.youkuaiyun.com/davis2015csdn/article/details/75125738</link><guid>https://blog.youkuaiyun.com/davis2015csdn/article/details/75125738</guid><author>davis2015csdn</author><pubDate>Fri, 14 Jul 2017 16:56:17 +0800</pubDate><description><![CDATA[1、本地安装mysql 
2、新建一个文件“mysql2”，将上面的所有目录全部复制到该文件夹中 
 
3、修改mysql2中my-default.ini 
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.h]]></description><category></category></item><item><title><![CDATA[mycat的入门教程（二）]]></title><link>https://blog.youkuaiyun.com/davis2015csdn/article/details/74919841</link><guid>https://blog.youkuaiyun.com/davis2015csdn/article/details/74919841</guid><author>davis2015csdn</author><pubDate>Mon, 10 Jul 2017 14:26:58 +0800</pubDate><description><![CDATA[在上篇教程中初步介绍了mycat的使用，接下来搭建一个拆分的策略（取模还是按区间划分等）的入门教程来实现一个分库分表的功能三张表users和test，三个数据库testtest2,,dmeo（三个库在一个数据库实例上）  
users表被分割到test,test2中存储。  
test在dmeo中存储。创建三个数据库，并创建对应的表-- ----------------------------
--]]></description><category></category></item><item><title><![CDATA[mycat的入门教程（一）]]></title><link>https://blog.youkuaiyun.com/davis2015csdn/article/details/74910974</link><guid>https://blog.youkuaiyun.com/davis2015csdn/article/details/74910974</guid><author>davis2015csdn</author><pubDate>Mon, 10 Jul 2017 11:44:06 +0800</pubDate><description><![CDATA[拓扑结构 
 
两张表users和test，两个数据库test,dmeo（两个库在一个数据库实例上） 
users在test中存储。 
test在dmeo中存储。-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `use]]></description><category></category></item><item><title><![CDATA[solr配置及Java实现]]></title><link>https://blog.youkuaiyun.com/davis2015csdn/article/details/74447046</link><guid>https://blog.youkuaiyun.com/davis2015csdn/article/details/74447046</guid><author>davis2015csdn</author><pubDate>Wed, 05 Jul 2017 15:04:29 +0800</pubDate><description><![CDATA[一、下载solr（地址：http://lucene.apache.org/solr/），并解压到一个目录中
 
Bin目录是执行脚本。Dist是构建完的jar包。Doc文档。Example是样例核配置。Server是solr的webapp和默认的solr_home目录。
Cmd进入在window命令窗口
(1)在solr/bin/路径下启动
solr start
(2)暂停solr]]></description><category></category></item><item><title><![CDATA[kill MySQL的线程]]></title><link>https://blog.youkuaiyun.com/davis2015csdn/article/details/52775760</link><guid>https://blog.youkuaiyun.com/davis2015csdn/article/details/52775760</guid><author>davis2015csdn</author><pubDate>Mon, 10 Oct 2016 11:04:49 +0800</pubDate><description><![CDATA[1、进入 information_schema数据库，查看数据库中被锁的线程
 select * from information_schema.innodb_trx;

2、可以批量查看被锁线程
SELECT concat(‘KILL ‘,id,’;') FROM information_schema.processlist WHERE user=’root’;



3、找到对]]></description><category></category></item></channel></rss>