innodb will work fine until many tb's. Innodb works with tablespace
files. Those can be up to 4 Gb per file. But you can create as many
tablespace files as you'd like. We're running a system with 15 Gb in
tablespace. As soon as that runs out we create more tablespace files.
Best regards,
Eelco
On zondag, maa 2, 2003, at 18:19 Europe/Amsterdam, Nataniel Klug wrote:
Craig,
Thanks for your help. I think I am using InnoDB and I use ext3
filesystem
type. I am very woried about using DBMail for all my clients becouse my
email system is growing every day... There is any other system that
can auth
users by [EMAIL PROTECTED] without using MySQL? It could use MailDir or
MailBoxes...
Nataniel Klug
----- Original Message -----
From: "Craig Whitmore" <[EMAIL PROTECTED]>
To: <dbmail@dbmail.org>
Sent: Sunday, March 02, 2003 2:40 AM
Subject: Re: [Dbmail] Maximun size of a DB
: Its pretty hard to know until you do it.. depends on alot of
things.. how
: many clients you have, how often they check, how much emails they
get etc
: etc.
:
: The biggest factor is the mysql database. Looking at your hardware
and
: number of users etc, I think your machine should handle it ok. Just
make
: sure you have plenty of RAM for mysql (so it doesn't start to go into
: swap)(and DMA is turned on on the hdds). Also make sure the File
system
you
: are using can handle very large files and is journeled (ie XFS) and
you
use
: innodb databases (transactional database support). (If you don't then
you'll
: have a VERY LONG time in trying to fix your databases if the machine
crashes
: ever).
:
: Thanks
: Craig
:
: ----- Original Message -----
: From: "Nataniel Klug" <[EMAIL PROTECTED]>
: To: <dbmail@dbmail.org>
: Sent: Sunday, March 02, 2003 11:29 AM
: Subject: [Dbmail] Maximun size of a DB
:
:
: > Hello,
: >
: > I am just new to DBMail and I want to know how bigger can get a
DBMail
: MySQL
: > database. I am about to create more than 200 mail accounts every
with 10
: > Mbytes. It could get my mail server slow? I have a Pentium III
1.13 Ghz
: with
: > 512 MB RAM and an Maxtor 7.200 RPM harddrive with 40 Gbytes using
RedHat
: > Linux v8.0. How many accounts (with 10 Mb os space) I can create
withou
: > worry about losing my server power?
: >
: > Nataniel Klug
: >
: >
: > _______________________________________________
: > Dbmail mailing list
: > Dbmail@dbmail.org
: > https://mailman.fastxs.nl/mailman/listinfo/dbmail
: >
:
: _______________________________________________
: Dbmail mailing list
: Dbmail@dbmail.org
: https://mailman.fastxs.nl/mailman/listinfo/dbmail
:
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________
E.J.A. van Beek
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
PGP-key:
www.ic-s.nl/keys/eelco.txt
