<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congyun1447</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congyun1447]]></copyright><item><title><![CDATA[我的一套较全面的oracle数据库监控管理脚本]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375906</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375906</guid><author>congyun1447</author><pubDate>Mon, 11 Mar 2019 16:18:19 +0800</pubDate><description><![CDATA[给大家介绍

一套oracle数据库监控管理脚本



该脚本对oracle的监控还是比较全面的，使用也很方便，自己也可以在脚本的...]]></description><category></category></item><item><title><![CDATA[呆瓜呆呆的专栏stream学习链接]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375970</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375970</guid><author>congyun1447</author><pubDate>Thu, 02 Jul 2015 18:12:20 +0800</pubDate><description><![CDATA[呆瓜呆呆的专栏中的stream学习链接 ：
oracle 11g streams搭建
oracle 11g streams rule和rule set 使用示例


	oracle 11g streams 捕获（cap...]]></description><category></category></item><item><title><![CDATA[oracle 自定义聚合函数]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375937</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375937</guid><author>congyun1447</author><pubDate>Tue, 02 Jun 2015 17:31:59 +0800</pubDate><description><![CDATA[oracle提供了聚合函数的API可以让我们方便的自己定义聚合函数。
详细看oracle官方文档：
http://docs.oracle.com/cd/B14117_01/appdev.101/b10800/dciaggre...]]></description><category></category></item><item><title><![CDATA[nagios snmp 安装记录]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375904</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375904</guid><author>congyun1447</author><pubDate>Wed, 21 Jan 2015 11:39:10 +0800</pubDate><description><![CDATA[1、安装依赖的包


	 (1) yum install httpd php php-cli gcc glibc glibc-common gd gd-devel net-snmp
 (2) service...]]></description><category></category></item><item><title><![CDATA[记HBase集群安装]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375909</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375909</guid><author>congyun1447</author><pubDate>Tue, 16 Dec 2014 18:32:02 +0800</pubDate><description><![CDATA[HBase实验环境：


	
172.16.110.133 laodeng3.localdomain
172.16.110.132 laodeng2.localdomain
172.16.110.134 lao...]]></description><category></category></item><item><title><![CDATA[记录:hadoop 2.5.2 集群动态增加新datanode 无法通信的问题]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375907</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375907</guid><author>congyun1447</author><pubDate>Wed, 03 Dec 2014 09:27:14 +0800</pubDate><description><![CDATA[1、拷贝NameNode上的hadoop home 目录到新的datanode（包括配置文件等）。


	2、启动新的datanode


	 hadoop-daemon.sh start datan...]]></description><category></category></item><item><title><![CDATA[Oracle 11gR2 注意revoke dba 会一并回收通过”quota“分配的表空间限额]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375900</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375900</guid><author>congyun1447</author><pubDate>Thu, 31 Jul 2014 10:32:11 +0800</pubDate><description><![CDATA[在Oracle11gR2中回收dba权限，会一并把通过”quota“分配的表空间限额也回收了。


	原先一直只知道回收dba权限时会一并回收unlimited tablespace权限


	看实验：
10...]]></description><category></category></item><item><title><![CDATA[mysql BLOB类型 TEXT类型]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375899</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375899</guid><author>congyun1447</author><pubDate>Fri, 21 Mar 2014 11:06:49 +0800</pubDate><description><![CDATA[MySQL的四种BLOB和TEXT类型: 
　　

	
		
			
				BLOB类型 
			
			
				大小（字节） 
			
			
				TEXT类型 
			
			
	...]]></description><category></category></item><item><title><![CDATA[能否直接修改NoOfReplicas=2为NoOfReplicas=1]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375805</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375805</guid><author>congyun1447</author><pubDate>Thu, 13 Mar 2014 16:49:22 +0800</pubDate><description><![CDATA[NoOfReplicas=2为时


	Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @172.16...]]></description><category></category></item><item><title><![CDATA[RHEL 使用CenOS的yum源repo文件]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375895</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375895</guid><author>congyun1447</author><pubDate>Wed, 12 Mar 2014 18:27:18 +0800</pubDate><description><![CDATA[Red Hat Enterprise Linux Server release 5.6:

	[base]
name=CentOS-5 - Base
baseurl=http://centos.ustc.edu.c...]]></description><category></category></item><item><title><![CDATA[mysql cluster ndb 内存表和磁盘表]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375897</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375897</guid><author>congyun1447</author><pubDate>Thu, 27 Feb 2014 17:43:56 +0800</pubDate><description><![CDATA[在ndb上可以建立两种类型的表：
 1、内存表：所有数据(包括index)都在内存中。同时会在磁盘上保存数据，因此不用担心数据会丢失，datanode会在启动的时候把数据加载到内存。
 2、磁盘表：仅主键、索引字段...]]></description><category></category></item><item><title><![CDATA[理解：MySQL的null与空字符串的不同]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375893</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375893</guid><author>congyun1447</author><pubDate>Wed, 19 Feb 2014 17:41:14 +0800</pubDate><description><![CDATA[MySQL的null与空字符串：


	搞过Oracle的人，常常会对MySQL的null与空字符串''搞错。
在Oracle里：null 与 ''是等价的。


	15:02:40 sql&gt;creat...]]></description><category></category></item><item><title><![CDATA[MySQL导入导出文件文件]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375890</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375890</guid><author>congyun1447</author><pubDate>Wed, 19 Feb 2014 14:15:42 +0800</pubDate><description><![CDATA[导出文本：
select ...into outfile 导出文件（注：导出的文件存放在mysql的服务器上）
 子句：FIELDS TERMINATED BY '*' 指定字段分隔符
 子句：OPTI...]]></description><category></category></item><item><title><![CDATA[MySql定位执行效率较低的SQL语句]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375888</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375888</guid><author>congyun1447</author><pubDate>Mon, 17 Feb 2014 16:30:39 +0800</pubDate><description><![CDATA[MySql定位执行效率较低的SQL语句:



	MySQL能够记录执行时间超过参数long_query_time设置值的SQL语句，默认是不记录的。


	获得初始锁定的时间不算作执行时间。mysqld...]]></description><category></category></item><item><title><![CDATA[MySql Date/Time Functions]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375898</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375898</guid><author>congyun1447</author><pubDate>Fri, 14 Feb 2014 11:34:01 +0800</pubDate><description><![CDATA[Date/Time Functions


	
		
		
			
				
					Name
				
				
					Description
				
			
		
		
			...]]></description><category></category></item><item><title><![CDATA[ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375885</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375885</guid><author>congyun1447</author><pubDate>Thu, 13 Feb 2014 15:27:46 +0800</pubDate><description><![CDATA[ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

错误的处理：

1、innodb引擎

超时由innodb_lo...]]></description><category></category></item><item><title><![CDATA[mysql修改事务隔离级别]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375887</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375887</guid><author>congyun1447</author><pubDate>Thu, 13 Feb 2014 13:30:48 +0800</pubDate><description><![CDATA[用户可以用SET TRANSACTION语句改变单个会话或者所有新进连接的隔离级别。它的语法如下：


SET [SESSION | GLOBAL] TRANSACTION ISOLATION LEVEL {READ...]]></description><category></category></item><item><title><![CDATA[mysql ndbcluster引擎不支持可重复读(ndb-7.3.3)]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375896</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375896</guid><author>congyun1447</author><pubDate>Thu, 13 Feb 2014 11:57:45 +0800</pubDate><description><![CDATA[mysql ndbcluster引擎不支持可重复读


	MySQL在事务隔离级别为Repeatable read时是可以支持可重复读的。
如innodb。http://www.cnblogs.com/zhouji...]]></description><category></category></item><item><title><![CDATA[源码方式安装mysql cluster 7.3.3]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375880</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375880</guid><author>congyun1447</author><pubDate>Wed, 12 Feb 2014 16:57:25 +0800</pubDate><description><![CDATA[MySql集群安装
1环境介绍
IP地址 节点类型 描述备注
172.16.110.136Mgmt NodeMa...]]></description><category></category></item><item><title><![CDATA[二进制方式安装mysql 5.6.15]]></title><link>https://blog.youkuaiyun.com/congyun1447/article/details/100375889</link><guid>https://blog.youkuaiyun.com/congyun1447/article/details/100375889</guid><author>congyun1447</author><pubDate>Mon, 27 Jan 2014 15:49:37 +0800</pubDate><description><![CDATA[1环境介绍
操作系统：Red Hat Enterprise Linux Server release 5.6 (64位)



	2安装软件
二进制包：mysql-5.6.15-linux-glibc2...]]></description><category></category></item></channel></rss>