[转载] 求教: 转数据库服务器,装什么CPU+主板+内存? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

[转载] 求教: 转数据库服务器,装什么CPU+主板+内存?

[转载] 求教: 转数据库服务器,装什么CPU+主板+内存?# Database - 数据库

p*i2002-06-11 07:06

1 楼

【以下文字转载自 Hardware 讨论区,原文如下】
发信人: pci (futureio), 信区: Hardware
标题: 求教: 转数据库服务器,装什么CPU+主板+内存?
发信站: The unknown SPACE (Tue Jun 11 00:20:20 2002) WWW-POST
学校数据库服务器的帐号随课程结束终止了, 想自己装一个entry-level的PC来转Oracle
或 MS SQL server
继续学一学. 请求各位高手指点, 该装什么CPU+mobo+ram好? Thanks a lot!
以下是一堆没条理的想法 ($500-800 for CPU+mobo+ram)
CPU:
如P3 - Tualatin Celeron: Intel 815芯片组, 512MB转不动数据库服务器,
其它VIA/SIS/Ali芯片组倒能支持多一点内存, 但非Intel的芯片组不稳定.
如P4 - Northwood: 845芯片组支持2GB内存
如Athlon XP: 不熟悉AMD芯片组, 只了解760MP(?)作服务器,

d*e2002-06-11 07:06

2 楼

你作什么呢?
512MB+ linux or windows 玩oracle很富裕了
难道你要作大量计算.
多余啊

【在 p*i 的大作中提到】

: 【以下文字转载自 Hardware 讨论区,原文如下】
: 发信人: pci (futureio), 信区: Hardware
: 标题: 求教: 转数据库服务器,装什么CPU+主板+内存?
: 发信站: The unknown SPACE (Tue Jun 11 00:20:20 2002) WWW-POST
: 学校数据库服务器的帐号随课程结束终止了, 想自己装一个entry-level的PC来转Oracle
: 或 MS SQL server
: 继续学一学. 请求各位高手指点, 该装什么CPU+mobo+ram好? Thanks a lot!
: 以下是一堆没条理的想法 ($500-800 for CPU+mobo+ram)
: CPU:
: 如P3 - Tualatin Celeron: Intel 815芯片组, 512MB转不动数据库服务器,

h*e2002-06-11 07:06

3 楼

跑DB Server的话, 如果不是自己玩玩就算, 还是选多CPU的box

【在 p*i 的大作中提到】

p*i2002-06-11 07:06

4 楼

Thanks a lot,
I just want to study more about Oracle and SQL server, trying to get direct
experience of storage procedures, error recovery, etc. Because I never
administored a database yet, so I think try oneself is the only way to learn.
Sure it cannot run as normal applications as on school's SUN 4-CPU server,
etc. I know other limitations to this home-grown approach could exist, such as
for load test of a number of simulatenous user requests, I can only use
software simulator to do that, as

【在 d******e 的大作中提到】

: 你作什么呢?
: 512MB+ linux or windows 玩oracle很富裕了
: 难道你要作大量计算.
: 多余啊

p*i2002-06-11 07:06

5 楼

Thanks a lot for your advice, that's very helpful for me-a newbie to database

【在 h****e 的大作中提到】

: 跑DB Server的话, 如果不是自己玩玩就算, 还是选多CPU的box

d*e2002-06-11 07:06

6 楼

our several servers use 512M and it is enough.
1gb is too much to study le.

【在 p*i 的大作中提到】

: Thanks a lot for your advice, that's very helpful for me-a newbie to database

p*i2002-06-11 07:06

7 楼

Really, do multiple servers must work together to handle the workload
(clustered or some server farm)?
So will two P3s with 815 chipset 512MB each, linked by 100Mbps switch handle
it?

【在 d******e 的大作中提到】

: our several servers use 512M and it is enough.
: 1gb is too much to study le.

d*e2002-06-11 07:06

8 楼

well, i don't have experienve with oracle RAC.
but it looks stupid. you can make a try.
or you may try to make the sql be executed parallelly.
or you may design some algorithms by urself using
pipeline or partition tech of parallel DB.
that's the only benefit of multiple processors.
do you need them? i don't think so.
for few concurrent accesses, SMP or cluster is just a waste.
is database your research direction. otherwise,
I really think you are wasting your money.

it is not the same cluster

【在 p*i 的大作中提到】

: Really, do multiple servers must work together to handle the workload
: (clustered or some server farm)?
: So will two P3s with 815 chipset 512MB each, linked by 100Mbps switch handle
: it?

p*i2002-06-11 07:06

9 楼

Thank you for the great help,
yes, I must get adept at the basic database configuration first,
i had bad experience that java development tools eat too much memory: IBM
VisualAge starts up too slow on P3/500+384M ram, so thought 512M unable to run
Oracle

handle

【在 d******e 的大作中提到】

: well, i don't have experienve with oracle RAC.
: but it looks stupid. you can make a try.
: or you may try to make the sql be executed parallelly.
: or you may design some algorithms by urself using
: pipeline or partition tech of parallel DB.
: that's the only benefit of multiple processors.
: do you need them? i don't think so.
: for few concurrent accesses, SMP or cluster is just a waste.
: is database your research direction. otherwise,
: I really think you are wasting your money.

d*e2002-06-11 07:06

10 楼

oh, the basic database engine is in C
and you don't develop an jserv based internet application right?

【在 p*i 的大作中提到】

: Thank you for the great help,
: yes, I must get adept at the basic database configuration first,
: i had bad experience that java development tools eat too much memory: IBM
: VisualAge starts up too slow on P3/500+384M ram, so thought 512M unable to run
: Oracle
:
: handle

p*i2002-06-11 07:06

11 楼

yeah, I mistook the 9iAS powered by pure java (from oracle's advertisement)
for 9i powered by C,
thanks for pointing out that,
will study servlet later and hopefully can afford another machine by then

【在 d******e 的大作中提到】

: oh, the basic database engine is in C
: and you don't develop an jserv based internet application right?

d*e2002-06-11 07:06

12 楼

9iAS is not a database.

【在 p*i 的大作中提到】

: yeah, I mistook the 9iAS powered by pure java (from oracle's advertisement)
: for 9i powered by C,
: thanks for pointing out that,
: will study servlet later and hopefully can afford another machine by then

w*h2002-06-11 07:06

13 楼

If you only use it for study, 512MB is fine.
If you use it for production, you have to have at least 2GB memory, especially
if you use Oracle's Java features.
Oracle + Java = Huge Memory

learn.
as

【在 p*i 的大作中提到】

: Thanks a lot for your advice, that's very helpful for me-a newbie to database