Mailing List Archive: DBMail: users

Size of accounts

Index | Next | Previous | View Threaded

mysql.jorge at decimal

Feb 21, 2009, 3:57 AM

Post #1 of 5 (965 views)
Permalink

Size of accounts

People,

I'd like to know, if someone has a bigger account than me.

The heaviest imap accounts are from me and 2 colleagues.

Mine has 3.99GB, and the next has 2.54GB.

Does anyone has a bigger one?

Just 'd like to know :)

PS: I don't have any performance problem or so, I'm just curious.

Jorge

michael.monnerie at is

Feb 21, 2009, 5:15 AM

Post #2 of 5 (897 views)
Permalink

Re: Size of accounts [In reply to]

On Samstag 21 Februar 2009 Jorge Bastos wrote:
> Does anyone has a bigger one?

I have about 10GB in a single account, with 141 mailboxes and 226493
e-mails (average 46kb per mail).

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

Attachments:

signature.asc (0.19 KB)

mysql.jorge at decimal

Feb 21, 2009, 5:25 AM

Post #3 of 5 (886 views)
Permalink

RE: Size of accounts [In reply to]

Good!
The folders I have I don't know, didn't count them, but maybe ~40/50

Anyone else?

> -----Original Message-----
> From: dbmail-bounces [at] dbmail [mailto:dbmail-bounces [at] dbmail] On
> Behalf Of Michael Monnerie
> Sent: sábado, 21 de Fevereiro de 2009 13:15
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Size of accounts
>
> On Samstag 21 Februar 2009 Jorge Bastos wrote:
> > Does anyone has a bigger one?
>
> I have about 10GB in a single account, with 141 mailboxes and 226493 e-
> mails (average 46kb per mail).
>
> mfg zmi
> --
> // Michael Monnerie, Ing.BSc ----- http://it-management.at
> // Tel: 0660 / 415 65 31 .network.your.ideas.
> // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
> // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
> // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

listid at alvar

Feb 21, 2009, 5:47 AM

Post #4 of 5 (890 views)
Permalink

Re: Size of accounts [In reply to]

Jorge Bastos wrote:
>
> People,
>
> I’d like to know, if someone has a bigger account than me.
>
> The heaviest imap accounts are from me and 2 colleagues.
>
> Mine has 3.99GB, and the next has 2.54GB.
>
> Does anyone has a bigger one?
>
> Just ‘d like to know :)
>
> PS: I don’t have any performance problem or so, I’m just curious.
>
> Jorge
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> mysql> select count(*) from dbmail_users;
> | 1037 |
>
> mysql> select curmail_size from dbmail_users order by curmail_size
> DESC limit 10;
> | 2167830084 |
> | 2021756374 |
> | 1948025803 |
> | 1877983107 |
> | 1847464686 |
> | 1780845294 |
> | 1455522183 |
> | 1420964121 |
> | 1268958920 |
> | 1234187837 |
http://img510.imageshack.us/img510/5396/dbmail.gif <- account size/count

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

michael.monnerie at is

Feb 21, 2009, 11:02 AM

Post #5 of 5 (888 views)
Permalink

Re: Size of accounts [In reply to]

On Samstag 21 Februar 2009 Jorge Bastos wrote:
> he folders I have I don't know, didn't count them, but maybe ~40/50

Count mailboxes:
select count(1) from dbmail_mailboxes where owner_idnr =
<your_user_idnr>;

Count Mails:
select count(1) from dbmail_messages join dbmail_mailboxes using
(mailbox_idnr) where owner_idnr = <your_user_idnr>;

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

Attachments:

signature.asc (0.19 KB)

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads