 |
|
|
|
Next: How to make device files for USB Zip drive disks ..
|
| Author |
Message |
External
Since: Apr 02, 2005
Posts: 3
|
(Msg. 1) Posted: Sat Apr 02, 2005 11:36 am
Post subject: Partition advice
Archived from groups: comp>unix>bsd>freebsd>misc (more info?)
|
|
|
I need some advice creating partitions (on my 80 Gb harddisk -IDE)
especially the /var and /usr partitions.
It's a PII, 450 Mhz with 512 Mb RAM and I need to run Apache, PHP, MySQL
(forum) and Postfix mailserver.
It's not very heavy, it's for private use.
I have knowledge of the FreeBSD partition advices (FreeBSD handbook), but I
understood that mySQL uses the /var partition.
So i suppose that i need more space then they adviced.
(my excuses for crossposting, but i need this advice very urgent)
Robertico |
|
| Back to top |
|
 | |
External
Since: Sep 11, 2003
Posts: 4
|
(Msg. 2) Posted: Sat Apr 02, 2005 2:58 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Robertico wrote:
>
> I need some advice creating partitions (on my 80 Gb harddisk -IDE)
> especially the /var and /usr partitions.
> It's a PII, 450 Mhz with 512 Mb RAM and I need to run Apache, PHP, MySQL
> (forum) and Postfix mailserver.
> It's not very heavy, it's for private use.
> I have knowledge of the FreeBSD partition advices (FreeBSD handbook), but I
> understood that mySQL uses the /var partition.
> So i suppose that i need more space then they adviced.
>
Some generic advice. If mysql creates a large, dynamic DB in say
/var/foo/mysql, then make /var/foo/mysql a mount point for an entirely
separate filesystem. This keeps mysql from being able to fill up the
/var filesystem, and potentially causing a DoS, when syslog can't write,
or new /var/run/pid files can't be created.
There is no law that says you have to mount filesystems off of /, any
directory will do. I would imagine having /usr/{src|obj|ports|local} on
their own filesystems isn't that uncommon. Putting those on a different
filesystem lets you tailor the size of /usr a bit more narrowly as it
shouldn't grow too much during the life of a major FreeBSD version. You
don't have to leave extra room in /usr for the buildworld, or building
or adding ports.
Also you have 7 available BSD partition letters in a slice (don't use
c!), so you can do this on single disk systems too. I'm not sure what
the default FreeBSD install does anymore, but I have 5 different
filesystem partitions on my boot slice, plus swap.
You can also move /var/foo/mysql to a new filesystem after you've been
running for a while.
newfs the new filesystem
mount the new filesystem in /mnt
shutdown mysql
copy data from /var/foo/mysql to /mnt
rm -rf /var/foo/mysql
mkdir /var/foo/mysql
remount the new filesystem to /var/foo/mysql
start mysql
edit /etc/fstab to mount the new filesystem in /var/foo/mysql at boot
time
???
profit
-Jed |
|
| Back to top |
|
| |
External
Since: Feb 28, 2005
Posts: 32
|
(Msg. 3) Posted: Sat Apr 02, 2005 2:58 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>>>>> "Jed" == Jed Clear writes:
Jed> Some generic advice.
And all of it good. In my specific case, I prefer to resize the
"/var" file system to something a little larger, by default. On my
web/database server, I made /var on the order of 16 GB, in order to
contain my web sites and databases. It probably would be better if I
created individual file systems for everything, but I'm lazy. 
Best wishes,
Matthew
--
"The challenge of a moral life is to do nothing that requires
forgiveness." - Roger Ebert in his review of _The Woodsman_ >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Jan 17, 2005
Posts: 60
|
(Msg. 4) Posted: Sat Apr 02, 2005 4:16 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Begin
On 2005-04-02, Robertico wrote:
> I need some advice creating partitions (on my 80 Gb harddisk -IDE)
> especially the /var and /usr partitions.
> It's a PII, 450 Mhz with 512 Mb RAM and I need to run Apache, PHP, MySQL
> (forum) and Postfix mailserver.
> It's not very heavy, it's for private use.
So you expect your forum to need gigabytes of database storage? No?
Thought so.
> I have knowledge of the FreeBSD partition advices (FreeBSD handbook), but I
> understood that mySQL uses the /var partition.
> So i suppose that i need more space then they adviced.
I generally use a quarter to half a gigabyte for logging on /var. You do
not have to use /var to store your mysqldb, but if you do, just add say
double the space that you think you'll be needing. Then add 20% storage
overhead and murphy tax and fudge the size upwards.
Some people put all their spare room in /usr. I don't, but if you choose
to do so, you won't easily run out of space there.
> (my excuses for crossposting, but i need this advice very urgent)
Of course, your bad planning is not my incentive to be any quicker. You
don't appear to be crossposting. If you then multiposted instead, that
is worse.
--
j p d (at) d s b (dot) t u d e l f t (dot) n l . >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Jan 17, 2005
Posts: 60
|
(Msg. 5) Posted: Sat Apr 02, 2005 10:29 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Begin
On 2005-04-02, Matthew X. Economou wrote:
> In my specific case, I prefer to resize the
> "/var" file system to something a little larger, by default. On my
> web/database server, I made /var on the order of 16 GB, in order to
> contain my web sites and databases. It probably would be better if I
> created individual file systems for everything, but I'm lazy.
Not necessairily everything, but separating logspace and user data space
(this includes websites) is a good thing. Otherwise, your users (or you,
or website visitors) can fill up /var to the point that no more logging
is taking place.
--
j p d (at) d s b (dot) t u d e l f t (dot) n l . >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Feb 28, 2005
Posts: 32
|
(Msg. 6) Posted: Sat Apr 02, 2005 11:09 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>>>>> "jpd" == jpd writes:
jpd> Not necessairily everything, but separating logspace and user
jpd> data space (this includes websites) is a good thing.
jpd> Otherwise, your users (or you, or website visitors) can fill
jpd> up /var to the point that no more logging is taking place.
Another excellent point. I'll keep this in mind in the future.
--
"The challenge of a moral life is to do nothing that requires
forgiveness." - Roger Ebert in his review of _The Woodsman_ >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Apr 02, 2005
Posts: 3
|
(Msg. 7) Posted: Sun Apr 03, 2005 10:14 am
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
First of all, thanks for your advices.
I think that I'll create the following partitions.
/
swap
/tmp
/var 'logfiles, etc
/db 'mySQL database
/www 'webserver data
/usr 'user data
Now i'll have the following question.
Whats the best way to point mySQL to the /db partition. Is it possible to do
this before installing mySQL (make file ?)
or create a link after installation ?
Robertico >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Jan 17, 2005
Posts: 60
|
(Msg. 8) Posted: Mon Apr 04, 2005 9:56 am
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Begin
On 2005-04-03, Robertico wrote:
[snip!]
> Now i'll have the following question.
> Whats the best way to point mySQL to the /db partition. Is it possible to do
> this before installing mySQL (make file ?)
> or create a link after installation ?
You can just as easily mount the space allocated to /db on /var/db/mysql
(or wherever mysql puts it database). Same for /www; if you're running
a standard apache you could mount it on /usr/local/www. For a specific
answer to your actual question, I'll refer to the mysql documentation.
--
j p d (at) d s b (dot) t u d e l f t (dot) n l . >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Apr 04, 2005
Posts: 1
|
(Msg. 9) Posted: Mon Apr 04, 2005 3:57 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Robertico" writes:
> First of all, thanks for your advices.
> I think that I'll create the following partitions.
[...]
> /db 'mySQL database
[...]
> Now i'll have the following question.
> Whats the best way to point mySQL to the /db partition.
by instead following the advice you were given in
Message-ID:
--
Justin Murdock >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Apr 02, 2005
Posts: 3
|
(Msg. 10) Posted: Mon Apr 04, 2005 6:43 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Justin,
What's the difference between ceating a seperate moint point at
"/var/foo/mysql" or "/db.
Maybe i didn't understood it very well (English is not my native language)
JPD,
Can you give me a hint to search for.
I couldn't find it in the mysql documentation. I searched the documentation,
before i asked the question.
Robertico >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Jul 13, 2003
Posts: 30
|
(Msg. 11) Posted: Tue Apr 05, 2005 6:00 am
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article "Robertico"
writes:
>
>What's the difference between ceating a seperate moint point at
>"/var/foo/mysql" or "/db.
Mounting the partition where mysql would "normally" have its db (which
most probably is neither literally "/var/foo/mysql" nor "/db", but
according to previous posts "somewhere under /var") removes the need for
asking questions like "Whats the best way to point mySQL to the /db
partition". Plus by making your setup more "standard", it becomes easier
for someone else to navigate.
I.e. the whole point is that you *don't* "create a separate mount point".
--Per Hedeland
per.DeleteThis@hedeland.org >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Apr 05, 2005
Posts: 1
|
(Msg. 12) Posted: Tue Apr 05, 2005 12:36 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2005-04-05, Per Hedeland wrote:
> In article "Robertico"
> writes:
>>
>>What's the difference between ceating a seperate moint point at
>>"/var/foo/mysql" or "/db.
>
> Mounting the partition where mysql would "normally" have its db (which
> most probably is neither literally "/var/foo/mysql" nor "/db", but
> according to previous posts "somewhere under /var") removes the need for
> asking questions like "Whats the best way to point mySQL to the /db
> partition". Plus by making your setup more "standard", it becomes easier
> for someone else to navigate.
>
> I.e. the whole point is that you *don't* "create a separate mount point".
>
> --Per Hedeland
> per.RemoveThis@hedeland.org
What ?, Thats not making much sense to me at all. If you mount
/dev/?????? on /var/db/mysql then nomatter who is on the system
they will still know that the db is in /var/db/mysql and they
dont even have to know that its being mounted there and is
still accessed in the same way as when you would have that mount
point. If you want to create a partition for your mysql database
then do it. its what partitioning is for so you can create stuff
like this so it enables you to remove other stuff carelessly
without accedently removing the other stuff you care about.
Now Hadeland, Dont answer a question with pointless loopback
information thats just falsified opinion that you made up
over the past 10 years of windows experience.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)
Comment: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xF7DF979F
Comment: Fingerprint = D1DC 0AA4 1C4E EAD4 24EB 7E77 B261 50BA F7DF 979F
iD8DBQFCUoZEsmFQuvffl58RAtCsAKCRzFRpKALQHXyp8T0fowRNmHhhJgCcDIuU
Bmu/2066LdWXuI9ofs5OSho=
=r2p5
-----END PGP SIGNATURE-----
--
( When in doubt, use brute force. -- Ken Thompson 1998 ) >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Jan 17, 2005
Posts: 60
|
(Msg. 13) Posted: Tue Apr 05, 2005 12:53 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Begin
On 2005-04-05, c0ldbyte wrote:
>
> On 2005-04-05, Per Hedeland wrote:
[snippety]
>> I.e. the whole point is that you *don't* "create a separate mount point".
>>
> What ?, Thats not making much sense to me at all.
To me it is. Maybe something wrong with you, then?
Here, maybe it'll help if I tell you that he doesn't say to not have
a mountpoint, but not not create a separate one. /var/db/mysql would
exist anyway, and using it wouldn't mean reconfiguring mysql.
Where /db wouldn't exist and would need creation AND reconfiguring.
> Now Hadeland, Dont answer a question with pointless loopback
> information thats just falsified opinion that you made up
> over the past 10 years of windows experience.
I think you just overstepped the line here. Go back to cola or whatever
stone you usually hide under, and leave us well alone.
--
j p d (at) d s b (dot) t u d e l f t (dot) n l . >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
External
Since: Jul 29, 2004
Posts: 10
|
(Msg. 14) Posted: Tue Apr 05, 2005 2:59 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Jan 17, 2005
Posts: 60
|
(Msg. 15) Posted: Tue Apr 05, 2005 2:59 pm
Post subject: Re: Partition advice [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Begin
On 2005-04-05, MattD.. wrote:
> After replacing jpd with a small shell script on Tuesday 05 Apr 2005 13:53,
> the following appeared on stdout:
>
>> Begin
>
> You know, that's a really nasty thing you're doing to all the unpatched
> Outhouse Excuse clients, jpd. Nice 
Something I admit I should've thought of much earlier, but anyway.
It's not even original.
--
j p d (at) d s b (dot) t u d e l f t (dot) n l . >> Stay informed about: Partition advice |
|
| Back to top |
|
| |
| Related Topics: | /var partition too small ... what to do ? - Unfortunately the freebsd handbook told me to make the /var partition un-reasonably small (256 mb).. So I have all of my data + scripts on /usr partition on a localhost instead of /var. And All config files are set up to find stuff in /usr. But I'd lik...
How to add the mirror partition to a RAID1 set with vinum - Hello, I am running FreeBSD 5.1 and would like to have all my partitions of by FreeBSD installation mirrored (RAID 1). So I followed the steps form the FreeBSD handbook (the part called Installing FreeBSD on Vinum). So far I got my first disks..
How to add the mirror partition to a RAID 1 set with Vinum - Hello, I am running FreeBSD 5.1 and would like to have all my partitions of by FreeBSD installation mirrored (RAID 1). So I followed the steps form the FreeBSD handbook (the part called Installing FreeBSD on Vinum). So far I got my first disks partition...
How to add th mirror partition to a RAID1 set with Vinum - Hello, I am running FreeBSD 5.1 and would like to have all my partitions of by FreeBSD installation mirrored (RAID 1). So I followed the steps form the FreeBSD handbook (the part called Installing FreeBSD on Vinum). So far I got my first disks..
Advice about cvsup ports-all upgrading - Hallo guys, it's going to be a long mail, I apologize for my poor english*. I'd like to have an advice about how to behave in case I want to upgrade some port because of new vulnerabilities. I'm not interested in having all my portsa always upgraded to... |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
