Eelco, Can you tell me how I install or even just verify if InnoDB is instaled in my machine? Where can I found documentation and some other information about this?
Nataniel Klug ----- Original Message ----- From: "Eelco van Beek - IC&S" <[EMAIL PROTECTED]> To: <dbmail@dbmail.org> Sent: Sunday, March 02, 2003 2:30 PM Subject: Re: [Dbmail] Maximun size of a DB : 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 : : _______________________________________________ : Dbmail mailing list : Dbmail@dbmail.org : https://mailman.fastxs.nl/mailman/listinfo/dbmail :
