<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[csi83845的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/csi83845</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; csi83845]]></copyright><item><title><![CDATA[MySQL 拼接Insert批量同步异构表数据]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241636</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241636</guid><author>csi83845</author><pubDate>Tue, 25 Jul 2017 17:52:01 +0800</pubDate><description><![CDATA[需求：线上部分表数据需要同步到测试环境，但是测试环境表结构又有变更，额外添加需求：原线上和测试都有的表字段同步，其他不同的字段不用同步，置为NULL即可。


	思路：首先导出线上表数据到测试的test库，考虑到两边...]]></description><category></category></item><item><title><![CDATA[logminer总结]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241637</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241637</guid><author>csi83845</author><pubDate>Wed, 22 Mar 2017 15:04:34 +0800</pubDate><description><![CDATA[执行脚本安装logminer 


	[oracle@fogtestdb admin]$ sqlplus / as sysdba 


	SQL&gt; @$ORACLE_HOME/rdbms/admin/db...]]></description><category></category></item><item><title><![CDATA[Oracle慢SQL监控脚本实现]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241631</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241631</guid><author>csi83845</author><pubDate>Tue, 07 Mar 2017 11:01:18 +0800</pubDate><description><![CDATA[线上Oracle准备实现类似MySQL
slow query的监控脚本，把查询时间超出定值的SQL定时的发送邮件告警，实现过程记录如下： 


	


	主要思路是通过DBA_HIST的几个视图来获取每小时...]]></description><category></category></item><item><title><![CDATA[MongoDB主从模式修改主库的oplogsize]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241635</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241635</guid><author>csi83845</author><pubDate>Fri, 24 Feb 2017 16:25:29 +0800</pubDate><description><![CDATA[如果是集群分片环境建议使用官方方法： 


	https://docs.mongodb.com/v3.0/tutorial/change-oplog-size/ 


	这里环境是传统的master/slave...]]></description><category></category></item><item><title><![CDATA[lepus安装记录]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241633</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241633</guid><author>csi83845</author><pubDate>Fri, 10 Feb 2017 11:33:32 +0800</pubDate><description><![CDATA[参考官方手册：http://www.lepus.cc/manual/index 


	安装xampp集成环境 


	[root@230_42-tiantu_monitor lepus]# ./xampp-l...]]></description><category></category></item><item><title><![CDATA[awr报表中用到的几个SQL]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241634</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241634</guid><author>csi83845</author><pubDate>Wed, 30 Nov 2016 09:25:23 +0800</pubDate><description><![CDATA[分享几个AWR脚本中查询资源占有的SQL，更改想要的snapid就可以查相应时间段的数据库性能信息了
 按执行时间查sql 


	select s.sql_id


	, elapsed_time/1000...]]></description><category></category></item><item><title><![CDATA[OGG Oracle 分区压缩表 到 MySQL分表的实现]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241625</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241625</guid><author>csi83845</author><pubDate>Sun, 09 Oct 2016 14:57:30 +0800</pubDate><description><![CDATA[需求描述：


	同步Oracle的分区表到MySQL，并且该分区表是压缩表，要同步到MySQL的分表。


	软件版本：


	Oracle  11.2.0.3


	MySQL 5.6.26
...]]></description><category></category></item><item><title><![CDATA[RMAN故障一例（归档的备份，从不obsolete）]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241628</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241628</guid><author>csi83845</author><pubDate>Tue, 30 Aug 2016 15:42:21 +0800</pubDate><description><![CDATA[问题描述: 


	近期的rman备份中，归档日志的备份没有被删除，rman的脚本和策略都没变过，归档的备份一直保留，每过一段时间就要物理删除备份，很是奇怪。


	


	rman的configure如...]]></description><category></category></item><item><title><![CDATA[OGG 12c  MySQL to MySQL]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241621</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241621</guid><author>csi83845</author><pubDate>Mon, 22 Aug 2016 10:51:39 +0800</pubDate><description><![CDATA[安装包下载
下载最新的OGG FOR MySQL，这里使用的是
ggs_121210_Linux_x64_MySQL_64bit.zip
官方下载地址：
http://www.oracle.com/tec...]]></description><category></category></item><item><title><![CDATA[orabug 手册(转)]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241630</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241630</guid><author>csi83845</author><pubDate>Fri, 05 Aug 2016 10:15:20 +0800</pubDate><description><![CDATA[1&gt; oradebug有哪些可用命令？


	以sysdba身份登陆数据库，通过oradebug help可以看到oradebug常用命令


	sqlplus / as sysdba

...]]></description><category></category></item><item><title><![CDATA[MongoDB的增删改查]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241629</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241629</guid><author>csi83845</author><pubDate>Fri, 05 Aug 2016 10:10:34 +0800</pubDate><description><![CDATA[增删改查的高级应用
Capped Collection(固定集合)
GridFS 大文件上传或下载


	1: insert
MongoDB是面向文档存储的数据库，文档结构形式叫BSON(类似JSON)
...]]></description><category></category></item><item><title><![CDATA[TokuMX 使用记录]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241627</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241627</guid><author>csi83845</author><pubDate>Fri, 05 Aug 2016 10:09:28 +0800</pubDate><description><![CDATA[相比原生的MongoDB， TokuMX 提供了三个主要的特性：性能的优化提升，数据压缩特性，支持事物。


	



	


	


	下载地址：https://www.percona.com...]]></description><category></category></item><item><title><![CDATA[MongoBD 日常操作小节]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241626</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241626</guid><author>csi83845</author><pubDate>Fri, 05 Aug 2016 10:08:35 +0800</pubDate><description><![CDATA[一、开启Mongodb 密码验证功能
	
	
		默认安装完mongodb是不用密码验证的，直接输入mongo就可以登入数据库进行相关操作，设置参数auth=true启动mongodb密码验证功能，开启改功能...]]></description><category></category></item><item><title><![CDATA[xtrabackup 使用记录（减少锁表配置主从）]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241620</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241620</guid><author>csi83845</author><pubDate>Fri, 05 Aug 2016 10:05:51 +0800</pubDate><description><![CDATA[xtrabackup安装


	[root@59-Mysql-Testbin]#cppercona-xtrabackup-2.1.8-733-Linux-x86_64.tar.gz/usr/src/

...]]></description><category></category></item><item><title><![CDATA[ogg 12c 配置记录  integrated]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241624</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241624</guid><author>csi83845</author><pubDate>Tue, 05 Jul 2016 10:41:56 +0800</pubDate><description><![CDATA[主备库都要操作：
	
	
		任一节点解压ogg 并设置环境变量
	
	
		
	
	
		
			
				
					121210_fbo_ggs_Linux_x64_shiphome....]]></description><category></category></item><item><title><![CDATA[ORA-600 [17074] Or ORA-600 [kglhpd-bad-free]]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241632</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241632</guid><author>csi83845</author><pubDate>Fri, 27 May 2016 13:11:57 +0800</pubDate><description><![CDATA[...]]></description><category></category></item><item><title><![CDATA[rac to rac dg记录]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241615</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241615</guid><author>csi83845</author><pubDate>Fri, 08 Apr 2016 11:02:38 +0800</pubDate><description><![CDATA[[oracle@tbrac01admin]$vitnsnames.ora


	


	#tnsnames.oraNetworkConfigurationFile:/u01/app/orac...]]></description><category></category></item><item><title><![CDATA[mysql 日期格式化]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241622</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241622</guid><author>csi83845</author><pubDate>Tue, 23 Feb 2016 09:51:47 +0800</pubDate><description><![CDATA[mysql 日期


	DATE_FORMAT(date,format)
根据format字符串格式化date值。下列修饰符可以被用在format字符串中：
%M 月名字(January……December)...]]></description><category></category></item><item><title><![CDATA[mongoDB 小脚本总结]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241623</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241623</guid><author>csi83845</author><pubDate>Sun, 10 Jan 2016 11:20:49 +0800</pubDate><description><![CDATA[批量建下个月的表
#!/bin/bash
	
	
		
	
	
		source/root/.bash_profile
	
	
		
	
	
		date_today=`date+%...]]></description><category></category></item><item><title><![CDATA[MySQL 5.7.9 源码安装记录]]></title><link>https://blog.youkuaiyun.com/csi83845/article/details/100241612</link><guid>https://blog.youkuaiyun.com/csi83845/article/details/100241612</guid><author>csi83845</author><pubDate>Fri, 27 Nov 2015 11:18:46 +0800</pubDate><description><![CDATA[tar zxvf cmake-version.tar.gz
官方手册
http://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.htm...]]></description><category></category></item></channel></rss>