<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cloud952788的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cloud952788</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cloud952788]]></copyright><item><title><![CDATA[2012年Oracle技术嘉年华后写的“作业”]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/41978017</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/41978017</guid><author>cloud952788</author><pubDate>Wed, 17 Dec 2014 09:54:19 +0800</pubDate><description><![CDATA[THIS IS OLD CHAPTER IN 2012 AFTER OUR TEAM COME BACK FROM TEH MEETING
THE LEADER ARRAGED THIS TASK AND COMPLETED THIS WORK]]></description><category></category></item><item><title><![CDATA[Oracle DG之ORA-16792: configurable property value is inconsistent with database setting]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/41728823</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/41728823</guid><author>cloud952788</author><pubDate>Thu, 04 Dec 2014 19:28:35 +0800</pubDate><description><![CDATA[Data Guard Broker
OEM12C配置管理Data Guard中报错如下：
ORA-16792: configurable property value is inconsistent with database setting




查询错误过程：
1：登录物理备库
$ dgmgrl
DGMGRL> connect sys
Password:
Connec]]></description><category></category></item><item><title><![CDATA[Oracle GoldenGate Configuration-列不对称带有常量的配置]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/41010453</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/41010453</guid><author>cloud952788</author><pubDate>Tue, 11 Nov 2014 13:38:30 +0800</pubDate><description><![CDATA[Oracle GoldenGate Configuration


Source:Oracle
create table t01(id int primary key,name varchar2(20));
alter table t01 add supplemental log data (all) columns;
Source:OGG


GGSCI (primary) 1]]></description><category></category></item><item><title><![CDATA[Mysql Performance Analysis]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/40978883</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/40978883</guid><author>cloud952788</author><pubDate>Mon, 10 Nov 2014 11:52:06 +0800</pubDate><description><![CDATA[Mysql Performance Analysis
2014/10/09


目标：
运行中的mysql状态查看
写成脚本。输出成html页


(1)QPS(每秒Query量) 
QPS = Questions(or Queries) / seconds 
mysql > show  global  status like 'Que%'; 
#show global s]]></description><category></category></item><item><title><![CDATA[linux performance analysis]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/40978853</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/40978853</guid><author>cloud952788</author><pubDate>Mon, 10 Nov 2014 11:50:03 +0800</pubDate><description><![CDATA[linux performance analysis


1,cpu
百度百科top详细介绍。


2,memory




3,io]]></description><category></category></item><item><title><![CDATA[nginx]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/40978807</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/40978807</guid><author>cloud952788</author><pubDate>Mon, 10 Nov 2014 11:47:23 +0800</pubDate><description><![CDATA[Nginx  是一个高性能的 HTTP 和 反向代理 服务器，也是一个 IMAP/POP3/SMTP 代理服务器（电子邮件）


原理简介]]></description><category></category></item><item><title><![CDATA[RRDtool存储引擎 cacti ganglia监控 CDN CGI KVM]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/40978737</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/40978737</guid><author>cloud952788</author><pubDate>Mon, 10 Nov 2014 11:41:54 +0800</pubDate><description><![CDATA[RRDtool (Round Robin Database Tool) 一个强大的绘图的引擎


Cacti 网络流量图形监测分析工具。 RRDtool存储数据
Ganglia 分布式集群监控系统。 RRDtool存储数据]]></description><category></category></item><item><title><![CDATA[Oracle-Ora-04031故障的分析]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/40581541</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/40581541</guid><author>cloud952788</author><pubDate>Wed, 29 Oct 2014 09:38:24 +0800</pubDate><description><![CDATA[#
#2014-09-29
#
#shared pool的使用情况
SELECT free_space,
       avg_free_size,
       used_space,
       avg_used_size,
       request_failures,
       last_failure_size
  FROM v$shared_pool_res]]></description><category></category></item><item><title><![CDATA[Mysql压力测试mysqlslap]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/40042791</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/40042791</guid><author>cloud952788</author><pubDate>Mon, 13 Oct 2014 12:29:44 +0800</pubDate><description><![CDATA[Mysql自带压力测试工具研究

#测试机  4Cpus 4GMemsize
测试结果
[root@ZQ-SE-226-V06 ~]# mysqlslap --concurrency=1000 --iterations=10  -a --socket=/opt/dbdata/mysql_3306/sock/mysql.sock -uroot -p
Enter password: 
Be]]></description><category></category></item><item><title><![CDATA[infobright之如何备份infobright的BRIGHTHOUSE表]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39989663</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39989663</guid><author>cloud952788</author><pubDate>Sat, 11 Oct 2014 10:13:14 +0800</pubDate><description><![CDATA[如何备份infobright的RIGHTHOUSE表


Infobright是开源的MySQL数据仓库解决方案。支持列式存储。默认的存储引擎：BRIGHTHOUSE。
使用mysqldump备份BRIGHTHOUSE表时需要加上single-transaction，否则报错
mysqldump: Got error: 1031: Table storage engine for 'BR]]></description><category></category></item><item><title><![CDATA[Sublime TEXT中文输入法无法定位输入框]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39925759</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39925759</guid><author>cloud952788</author><pubDate>Thu, 09 Oct 2014 10:06:29 +0800</pubDate><description><![CDATA[https://github.com/chikatoike/IMESupport]]></description><category></category></item><item><title><![CDATA[Mysql集群HA方案Galera测试节点宕机]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39644257</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39644257</guid><author>cloud952788</author><pubDate>Sun, 28 Sep 2014 17:25:26 +0800</pubDate><description><![CDATA[Galera节点宕机的测试
1,关掉其中一个节点node2
2,在node1中插入数据
3,查看node1和node3的数据
4,启动节点node2
5,查看node2的数据]]></description><category></category></item><item><title><![CDATA[Mysql集群HA方案Galera的安装配置]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39643921</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39643921</guid><author>cloud952788</author><pubDate>Sun, 28 Sep 2014 17:03:24 +0800</pubDate><description><![CDATA[###############################################################################
###############################################################################
######################################]]></description><category></category></item><item><title><![CDATA[How to unintall the Mysql service on your server?]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39643733</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39643733</guid><author>cloud952788</author><pubDate>Sun, 28 Sep 2014 16:57:55 +0800</pubDate><description><![CDATA[How to unintall the Mysql service on your server?


--Make sure all the Mysql services on your server  are not useful forever.
--Backup all your datas manually


--close all the mysql instance ]]></description><category></category></item><item><title><![CDATA[Linux之Shell脚本while循环ssh登录执行命令]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39640085</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39640085</guid><author>cloud952788</author><pubDate>Sun, 28 Sep 2014 13:26:43 +0800</pubDate><description><![CDATA[包含以下内容]]></description><category></category></item><item><title><![CDATA[Linux-SHELL]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39373051</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39373051</guid><author>cloud952788</author><pubDate>Thu, 18 Sep 2014 15:35:49 +0800</pubDate><description><![CDATA[declare的用法
-i 声明整数

-a 声明数组

-f 声明未函数

-r 声明未只读
﻿﻿]]></description><category></category></item><item><title><![CDATA[Mysql主从复制从库状态双Yes及seconds_behind_master为0的故障分析]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39369693</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39369693</guid><author>cloud952788</author><pubDate>Thu, 18 Sep 2014 11:28:21 +0800</pubDate><description><![CDATA[转载一：
MySQL同步状态双Yes的假象及seconds_behind_master的含义

http://www.cnblogs.com/billyxp/p/3470376.html]]></description><category></category></item><item><title><![CDATA[MySQL备份与恢复之物理备份xtrabackup]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39340945</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39340945</guid><author>cloud952788</author><pubDate>Wed, 17 Sep 2014 12:29:15 +0800</pubDate><description><![CDATA[安装xtrabackup
rpm包


[root@cluster4 x86_64]# ls -lrt
total 46512
-rw-r--r-- 1 root root  7098196 Aug  5 10:08 percona-xtrabackup-2.1.4-656.rhel6.x86_64.rpm
-rw-r--r-- 1 root root  9344980 Aug  5]]></description><category></category></item><item><title><![CDATA[Oracle Database SQLのData Guard环境中修改基表引起视图查询报错]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39184431</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39184431</guid><author>cloud952788</author><pubDate>Wed, 10 Sep 2014 18:44:01 +0800</pubDate><description><![CDATA[描述
在Data Guar]]></description><category></category></item><item><title><![CDATA[Oracle Goldengate手工切换trail文件]]></title><link>https://blog.youkuaiyun.com/cloud952788/article/details/39180773</link><guid>https://blog.youkuaiyun.com/cloud952788/article/details/39180773</guid><author>cloud952788</author><pubDate>Wed, 10 Sep 2014 14:34:11 +0800</pubDate><description><![CDATA[在某些情况下，对于一个已经running的OGG进程，需要保持一个一致点，对已同步的数据（正确的或者错误的）做修改，修改完之后，从一致点继续同步。
这是需要人工干涉产生一个新的extract trail文件。etrollover可以再重新启动抽取进程时自动生成一个新的trail文件。
同时会提示并且必须指定datapump和replicat进程的seqno序号。
另外，源端的trail文件序]]></description><category></category></item></channel></rss>