<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congjiong3047的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congjiong3047</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congjiong3047]]></copyright><item><title><![CDATA[mydumper 编译错误]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447292</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447292</guid><author>congjiong3047</author><pubDate>Fri, 11 Aug 2017 13:52:40 +0800</pubDate><description><![CDATA[[root@service mydumper-0.9.1]# cmake ``-DMYSQL_CONFIG=/usr/local/percona3306/bin/mysql_config`` .


	


	...]]></description><category></category></item><item><title><![CDATA[Percona XtraDB Cluster 读写分离]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447291</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447291</guid><author>congjiong3047</author><pubDate>Thu, 22 Jun 2017 14:29:54 +0800</pubDate><description><![CDATA[Percona XtraDB Cluster 部署


	




	




	配置本地光盘YUM源：


	cd /etc/yum.repos.d/


	vi Cent...]]></description><category></category></item><item><title><![CDATA[定位空闲会话事务没提交导致锁阻塞的脚本]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447290</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447290</guid><author>congjiong3047</author><pubDate>Mon, 10 Apr 2017 22:01:19 +0800</pubDate><description><![CDATA[---- 查看事务锁阻塞线程和等待线程
SELECT r.trx_id AS waiting_trx_id,r.`trx_mysql_thread_id` AS waiting_thread,
 TIMESTAM...]]></description><category></category></item><item><title><![CDATA[(何凳成博客)MySQL 加锁处理分析——学习笔记]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447308</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447308</guid><author>congjiong3047</author><pubDate>Mon, 10 Apr 2017 21:36:07 +0800</pubDate><description><![CDATA[1. 准备测试数据
use test;

CREATE TABLE t1(id int,name varchar(20));

alter table t1 add primary key(id);

insert...]]></description><category></category></item><item><title><![CDATA[通过performance_schema视图和sys视图定位使用磁盘文件导致IO很高的SQL]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447289</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447289</guid><author>congjiong3047</author><pubDate>Mon, 27 Mar 2017 20:40:10 +0800</pubDate><description><![CDATA[思路：


	1. 执行测试的语句，使用 TOP 查看操作系统的性能状态


	2. iostat


	3. iotop


	4. 通过 performance_schema 中的 events...]]></description><category></category></item><item><title><![CDATA[MYSQL主从复制部署MHA自动故障转移]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447297</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447297</guid><author>congjiong3047</author><pubDate>Mon, 06 Feb 2017 10:58:58 +0800</pubDate><description><![CDATA[一. 环境描述


	操作系统：RHEL 6.4 


	mysql ：5.6.27


	


	
		
			
				
					角色
				
			
			
			...]]></description><category></category></item><item><title><![CDATA[使用Performance Schema 诊断磁盘IO很高的问题]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447365</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447365</guid><author>congjiong3047</author><pubDate>Mon, 23 Jan 2017 15:47:33 +0800</pubDate><description><![CDATA[--运行基准测试，-w5 表示5个数据仓库、-c5 表示5个并发线程、-r30 表示预热30秒、-l1300表示基准测试进行1300秒。

[root@oradb tpcc-mysql-master]# ./tpcc_sta...]]></description><category></category></item><item><title><![CDATA[通过performance_schema视图和sys视图定位使用磁盘文件导致IO很高的SQL]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447293</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447293</guid><author>congjiong3047</author><pubDate>Sun, 25 Dec 2016 18:30:15 +0800</pubDate><description><![CDATA[思路：


	1. 执行测试的语句，使用 TOP 查看操作系统的性能状态


	2. iostat


	3. iotop


	4. 通过 performance_schema 中的 events...]]></description><category></category></item><item><title><![CDATA[innodb 事务锁研究]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447347</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447347</guid><author>congjiong3047</author><pubDate>Sun, 25 Dec 2016 18:09:56 +0800</pubDate><description><![CDATA[1. select * for update 语句添加的是排他行锁。 


	 


	2. select ... from table_name where ... for
update 语句在行计划使用...]]></description><category></category></item><item><title><![CDATA[innodb保护行锁对象的mutext争用导致LINUX内核态CPU使用率高诊断]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447287</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447287</guid><author>congjiong3047</author><pubDate>Wed, 14 Dec 2016 22:48:27 +0800</pubDate><description><![CDATA[MSYQL 版本： 


	mysql&gt; select version()\G 


	*************************** 1. row
**********************...]]></description><category></category></item><item><title><![CDATA[控制文件与数据文件头SCN不一致导致数据库无法启动故障处理]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447288</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447288</guid><author>congjiong3047</author><pubDate>Thu, 17 Nov 2016 11:17:22 +0800</pubDate><description><![CDATA[环境说明
	


	OS操作系统：WINDOWS 2012 64位


	数据库版 本：ORACLE 11.2.0.1


	


	
		故障问题描述
	


	客户反映数据...]]></description><category></category></item><item><title><![CDATA[通过查询日志定位持有锁的SQL语句]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447295</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447295</guid><author>congjiong3047</author><pubDate>Wed, 16 Nov 2016 11:11:56 +0800</pubDate><description><![CDATA[MYSQL 版本：
mysql&gt; select version();
+------------+
| version() |
+------------+
| 5.6.27-log |
+---------...]]></description><category></category></item><item><title><![CDATA[服务器内存不足导致LINUX KILL MYSQLD 故障]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447286</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447286</guid><author>congjiong3047</author><pubDate>Sun, 13 Nov 2016 11:30:20 +0800</pubDate><description><![CDATA[环境说明
	


	OS操作系统：SUSE Linux 11


	数据库版 本：MYSQL 5.6


	


	
		故障问题描述
	


	客户反映MYSQL数据库因为内...]]></description><category></category></item><item><title><![CDATA[RAC删除 /tmp/.oracle目录导致故障]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447285</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447285</guid><author>congjiong3047</author><pubDate>Sun, 13 Nov 2016 09:41:33 +0800</pubDate><description><![CDATA[故障问题描述 
	


	客户技术人员电话反映应用出现有张表无法访问的问题（其实是数据库已经无法进行写入操作），同时，也无法远程登录检查，数据库日志等信息。根据当时情况，基本无法判断确定具体是什么原因导致表...]]></description><category></category></item><item><title><![CDATA[定位ORACLE TX锁和表锁的脚本]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447230</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447230</guid><author>congjiong3047</author><pubDate>Thu, 10 Nov 2016 23:10:04 +0800</pubDate><description><![CDATA[--查看 v$lock 表中的锁信息
select sid,type,id1,id2,decode(lmode,0,'None',1,'Null',2,'Row Share',
 3,'Row Exclusive...]]></description><category></category></item><item><title><![CDATA[ORACLE锁阻塞研究]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447284</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447284</guid><author>congjiong3047</author><pubDate>Thu, 10 Nov 2016 23:08:37 +0800</pubDate><description><![CDATA[1. SESION 信息
SESSION 125
SQL&gt; select sid from v$mystat where rownum&lt;2;

 SID
----------
 1...]]></description><category></category></item><item><title><![CDATA[OGG重新初始化]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447229</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447229</guid><author>congjiong3047</author><pubDate>Wed, 09 Nov 2016 17:01:07 +0800</pubDate><description><![CDATA[环境说明 
	


	OS操作系统：AIX 


	数据库版 本：ORACLE 11.2.0.4 


	 


	 


	
		OGG 重新初始化步骤 
	


	...]]></description><category></category></item><item><title><![CDATA[从MYSQL查查询日志中过滤出一个小时的慢查询日志并找出 TOP SQL]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447228</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447228</guid><author>congjiong3047</author><pubDate>Wed, 09 Nov 2016 13:53:55 +0800</pubDate><description><![CDATA[sed -n '/# Time: 151226 16:30:../,$'p QITV0223-slow.log &gt; QITV0223-slow-1630.log


在 MYSQL 慢查询日志中 # Time ...]]></description><category></category></item><item><title><![CDATA[使用正确的表连接顺序和表连接方式优化SQL]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447282</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447282</guid><author>congjiong3047</author><pubDate>Wed, 02 Nov 2016 20:57:08 +0800</pubDate><description><![CDATA[本文中的执行计划格式混乱，把执行计划复制到 UltraEdit 中就可以正常显示了。

1. 创建测试数据

create table lixia.t1 as select * from dba_objects; ...]]></description><category></category></item><item><title><![CDATA[源码编译 mydumper 和使用 mydumper 对MYSQL进行逻辑备份]]></title><link>https://blog.youkuaiyun.com/congjiong3047/article/details/100447227</link><guid>https://blog.youkuaiyun.com/congjiong3047/article/details/100447227</guid><author>congjiong3047</author><pubDate>Tue, 01 Nov 2016 12:33:08 +0800</pubDate><description><![CDATA[1. 下载 mydumper 


	https://launchpad.net/mydumper/+milestone/0.9.1 


	
 


	 


	 


	2. 把 m...]]></description><category></category></item></channel></rss>