![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Databases
baidu_26022431
这个作者很懒,什么都没留下…
展开
-
MySQL Select and Sort Status Variables
MySQL Select and Sort Status Variables MySQL Select and Sort Status Variables MySQL SHOW STATUS; and mysqlreport using the -sas command line option show nine status variables which are counters for...2007-12-18 16:49:06 · 96 阅读 · 0 评论 -
网易评论数据库宕机了……
可怜的Mysql数据库,在关键的时刻宕机了…… 从页面看到的错误源代码: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1000]; error code [1016]; -...2009-03-03 16:19:50 · 130 阅读 · 0 评论 -
mysql主从搭建和测试步骤
主从配置步骤: 假设两台机器分别为192.168.0.202, 192.168.0.203,&2009-04-13 13:52:56 · 120 阅读 · 0 评论 -
The Mysql tool I’ve been waiting for years. zt
I've just been pointed to the nice tool which I was waiting for years to see. It is fincore - little perl script which allows you to see what pages of file are cached in OS memory. This is really co...2008-03-25 17:47:34 · 57 阅读 · 0 评论 -
When the subselect runs faster (zt)
A few weeks ago, we had a query optimization request from one of our customer. The query was very simple like: PLAIN TEXT CODE: SELECT * FROM `table` WHERE (col1='A'||col1='B') ORDER BY id...2010-03-23 11:32:38 · 71 阅读 · 0 评论 -
Handling CLOBs - Made easy with Oracle JDBC 10g
Handling CLOBs - Made easy with Oracle JDBC 10g Date: 17-Mar-2004 This document will help you understand: • How to easily handle the CLOB data at the JDBC layer using enhanced...原创 2010-01-18 11:06:39 · 97 阅读 · 0 评论 -
小批评一下《构建Oracle高可用环境》这本书
标题党一把,呵呵。 背景调查: 对书的评价是因人而异的,先说下我的自己的阅读背景,可能这本书不是针对我类用户的,所以让我觉得不适应。 我目前在做系统架构设计,需要非常全面的了解各项技术,我们第一次大范围使用Oracle数据库,而我对这个基本上不太懂,所以需要找本书看看,在itpub上看到了这本书,排名第一,作者很有名气就买下了。就我这位读者情况来说: 1. 不懂oracl...2009-08-13 11:07:25 · 159 阅读 · 0 评论