文章不在长，坚持不懈记录下努力前行的脚步
发布时间：2015-09-08 18:00:22
1.alter table
it can take a lot of time.MySQL will perform a row-by-row copy of your old table into a new table. During that
time, you’ll probably be using all of the server’s di.........【阅读全文】
发布时间：2015-08-21 15:16:20
1.Each query has to check each row’s version numbers against the transaction’s version。
2.InnoDB must examine each row to ensure that it meets two criteria。innodb会根据以下两个条件检查每行记录.........【阅读全文】
发布时间：2015-08-11 11:51:04
Oracle性能监控脚本
1. 监控事例的等待
select event,
sum(decode(wait_Time, 0, 0, 1)) "Prev",
sum(decode(wait_Time, 0, 1, 0)) "Curr",
count(*) "Tot.........【阅读全文】
发布时间：2015-08-10 15:49:44
mysql集群<br />===================<br />集群成员：<br />管理节点<br />数据节点<br />sql节点<br />===================<br />ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-Cluster-7.3/<br />1. 所有节点均不安装和启动mysql-server软件包，仅安装集群软件包 mysql-cluster-gpl-7.3.4.tar.gz<br />2.........【阅读全文】
