<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[u014761321的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/u014761321</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; u014761321]]></copyright><item><title><![CDATA[pgpool无法启动故障解决一例]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/40113985</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/40113985</guid><author>u014761321</author><pubDate>Wed, 15 Oct 2014 17:18:07 +0800</pubDate><description><![CDATA[pgpool -n -d > /home/postgres/pgpool.log 2>&1 &
使用上面的命令启动pgpool时报错：
2014-10-15 13:29:58 ERROR: pid 2315: pool_config: parse error at line 257 ''
2014-10-15 13:29:58 ERROR: pid 2315: Unable to get c]]></description><category></category></item><item><title><![CDATA[mysql ERROR 1265 (01000)故障解决一例]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/38488247</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/38488247</guid><author>u014761321</author><pubDate>Mon, 11 Aug 2014 10:28:50 +0800</pubDate><description><![CDATA[mysql ERROR 1265 (01000)故障解决一例


解决：ERROR 1265 (01000): Data truncated for column '表名' at row 1


今天为一张表添加主键索引：
alter table 表名 add primary key(列1,列2,列3);
结果报如下错误：
ERROR 1265 (01000): Data tru]]></description><category></category></item><item><title><![CDATA[myisam引擎的表缺少统计信息所导致的严重性能问题]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/38487513</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/38487513</guid><author>u014761321</author><pubDate>Mon, 11 Aug 2014 09:45:13 +0800</pubDate><description><![CDATA[myisam引擎的表缺少统计信息所导致的严重性能问题


内容提要：
mysql数据库myisam引擎的表在默认状态下，不会自动收集统计信息。
如果myisam引擎的表缺少统计信息，会导致一些sql语句莫名其妙地产生极其严重的性能问题。


数据库版本：
mysql> show variables like '%version%';
+---------------------]]></description><category></category></item><item><title><![CDATA[mysql慢查询日志使用总结]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/26599697</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/26599697</guid><author>u014761321</author><pubDate>Thu, 22 May 2014 16:19:37 +0800</pubDate><description><![CDATA[mysql慢查询日志使用总结

首先查看log_output参数，确认日志信息输出到操作系统文件还是数据库的表中：
mysql> show variables like 'log_output';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    ]]></description><category></category></item><item><title><![CDATA[处理mysql锁争用的一个示例]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/25905935</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/25905935</guid><author>u014761321</author><pubDate>Thu, 15 May 2014 18:06:28 +0800</pubDate><description><![CDATA[处理mysql锁争用的一个示例

模拟一个场景：
建一个innodb引擎的表：
create table shuzhi
(
  id mediumint(8) primary key,
  name varchar(30),
  shuzhi mediumint(10)
);
alter table shuzhi engine=innodb;
插入一些记录：
insert ]]></description><category></category></item><item><title><![CDATA[oracle数据库的静默状态]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/24730821</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/24730821</guid><author>u014761321</author><pubDate>Tue, 29 Apr 2014 17:41:31 +0800</pubDate><description><![CDATA[静默状态

当数据库处于静默状态时，只有拥有DBA权限的用户
（注：只有sys和system用户才可以，其他被授予DBA角色的用户也不能执行任何操作），
才能对数据库进行查询、更新等操作。
任何非DBA用户（非sys、system用户）都不能在数据库中执行任何操作。

注意：在执行下面的语句重新配置em时，也会使数据库处于静默状态！！！
emca -deconfig dbcontr]]></description><category></category></item><item><title><![CDATA[oracle 10g dataguard备库切换时，ORA-16139错误的解决办法]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/23949585</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/23949585</guid><author>u014761321</author><pubDate>Thu, 17 Apr 2014 17:48:47 +0800</pubDate><description><![CDATA[oracle 10g dataguard备库切换时，ORA-16139错误的解决办法


Maximum Protection Mode下，将备库切换到主库报错：
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at ]]></description><category></category></item><item><title><![CDATA[在oracle 10g下，outline（存储大纲）与cursor_sharing参数的依赖关系]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/23934571</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/23934571</guid><author>u014761321</author><pubDate>Thu, 17 Apr 2014 15:03:28 +0800</pubDate><description><![CDATA[在oracle 10g下，outline（存储大纲）与cursor_sharing参数的依赖关系
数据库版本：
10.2.0.1.0








生成无绑定变量的outline：
create outline o1 on 
select EMPLOYEE_ID,SALARY from employees where EMPLOYEE_ID=198;


测试ou]]></description><category></category></item><item><title><![CDATA[Red Hat Enterprise Linux 5下有关dmrc文件错误的解决办法]]></title><link>https://blog.youkuaiyun.com/u014761321/article/details/23922389</link><guid>https://blog.youkuaiyun.com/u014761321/article/details/23922389</guid><author>u014761321</author><pubDate>Thu, 17 Apr 2014 11:48:45 +0800</pubDate><description><![CDATA[平台：
Red Hat Enterprise Linux 5
2.6.18-194.el5
​
​故障描述，使用oracle用户登录linux时报错：
User's $HOME/.dmrc file is being ignored. This prevents the defaults session and language from being saved. File should]]></description><category></category></item></channel></rss>