Skip to contentSkip to conversation

System Suggestions

linux-lvm Anthony W. Marino 2 participants 3 messages Mar 6, 2002

lore
Share & tools
lore
#0 lore raw

Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect "THE" answer since all things are relative and I will have to further test the various scenarios.

SuSE 7.3-2.4.18
512MB RAM
4x40GB Maxtor IDE (7200RPM) drives
3Ware 7800 RAID Controller
LVM
XFS

Thank You,
Anthony

#1 lore raw
Quoted 11 lines · Anthony W. Marino

Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect "THE" answer since all things are relative and I will have to further test the various scenarios.
SuSE 7.3-2.4.18
512MB RAM
4x40GB Maxtor IDE (7200RPM) drives
3Ware 7800 RAID Controller
LVM
XFS

You really don't provide us with enough information here.

How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables?

All of these, and more will have a dramatic impact on how you set this stuff up.

Signature · 1 line
Share and Enjoy. 
#2 lore raw
Quoted 15 lines · Petro
Quoted 11 lines · Anthony W. Marino

Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect "THE" answer since all things are relative and I will have to further test the various scenarios.
SuSE 7.3-2.4.18
512MB RAM
4x40GB Maxtor IDE (7200RPM) drives
3Ware 7800 RAID Controller
LVM
XFS

You really don't provide us with enough information here.

Quoted 7 lines

How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables?

All of these, and more will have a dramatic impact on how you set this stuff up.

Thanks. I'm more concerned about any specifics as it applies to MySQL Max and XFS, RAID and LVM as a whole. Are there any nuances as it applies to the whole?

Anthony