ITPub博客

Percona MySQL 5.6语句加锁报错：ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

Oracle 连接的测试

Oracle 11g 数据库服务器CPU、IO负载高的故排除流程

在哈希分区中，如果分区字段的值是相同的，相同值的条目都会存放在相同的分区中；LIST分区则易于管理，而对于哈希分区，则不好控制各个值所存放的分区，有的分区会存放两个或多个分区字段值。

Oracle 通过存储过程来生成CSV文件

Oracle SQL Developer Debug存储过程

MySQL 连接工具mysql中的语句注释方法

MySQL 创建函数时报错ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger

MySQL 创建存储过程报错ERROR 1415 (0A000): Not allowed to return a result set from a function

MySQL create function时报错'ERROR 1064 (42000)'

MySQL 使用tee记录语句和输出日志

Linux Shell执行source或.命令报错：[root@localhost fire]# . config.inibash: VERSION_LEVEL_TABLE: command not foundbash: SQL_SCRIPT_NAME: command not found

MySQL 5.5 NDB集群查看日志

Oracle 11g RAC在grid用户下登陆sqlplus报错Error 6 initializing SQL*PlusSP2-0667: Message file sp1.msb not foundSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

PUTTY 记录操作记录

MySQL 5.7 查询InnoDB锁表

VMware下Linux网卡由eth0变为eth1的解决办法

Oracle 11g 向表中大字段插入数据

CentOS 6.5 tree命令安装

Oracle 12c 备份恢复OCR(Oracle Cluster Registry)