If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > hard drive masseive and filesystem format

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-26-04, 01:53
credo credo is offline
Registered User
 
Join Date: Mar 2004
Location: Estonia
Posts: 2
hard drive masseive and filesystem format

Hi,

Dunno exactly am I in right place, but i have following situation:
Have server (P4 3,0 Prescott processor, 2 GB memory, Intel D865 chipset MB, Adaptec 19160 + 9,1 GB Quantum for system and 2*160 GB Samsung sATA drives in stripe for data) under Windows 2003 Standard Server
There is MySQL server + Apache for www + PHP that are installed to 9,1 GB system drive.
In striped drive there are approx. 760000 file that are accessed over www (something like web-album).
Now my problems:
1) is it wise to go something non-MS platform?
2) allocation unit size for striped drive? 32K? 4096? default 512?
3) fragmentation of drive was previously horrible (when it was under W2K server), now it performes defrag every 2 days. What are suggestions?
4) Page file size - at moment it's as it was automatically. What would be good? And on system drive or in this striped drive?

Sorry if my questions are quite silly

Best regards,
Mati
Reply With Quote
  #2 (permalink)  
Old 03-26-04, 12:11
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Re: hard drive masseive and filesystem format

Quote:
Originally posted by credo
Hi,

Dunno exactly am I in right place, but i have following situation:
Have server (P4 3,0 Prescott processor, 2 GB memory, Intel D865 chipset MB, Adaptec 19160 + 9,1 GB Quantum for system and 2*160 GB Samsung sATA drives in stripe for data) under Windows 2003 Standard Server
There is MySQL server + Apache for www + PHP that are installed to 9,1 GB system drive.
In striped drive there are approx. 760000 file that are accessed over www (something like web-album).
Now my problems:
1) is it wise to go something non-MS platform?
2) allocation unit size for striped drive? 32K? 4096? default 512?
3) fragmentation of drive was previously horrible (when it was under W2K server), now it performes defrag every 2 days. What are suggestions?
4) Page file size - at moment it's as it was automatically. What would be good? And on system drive or in this striped drive?

Sorry if my questions are quite silly

Best regards,
Mati
1. Yes is it wise...
Unix (Linux, BSD and so on) is better for your needs...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On