Db growing size

> In 2.3x version, with the new database design, the size
that the database
> has, it's not the real size.
> 
> I have now 52GB of DB Size, but comparing with the
email that is stored in
> this very moment:
> 
> "SELECT round((sum(curmail_size)/1024)/1024,2)
FROM dbmail_users ;"
> 
> Result:
> 
> 8648.34
Jorge, I'm not sure if you're using PG or Mysql, but I'm
going
to assume that you're doing all the normal (proper)
maintenance
of your database (vacuum and such)?


-- 

Dave Logan
http://www.digitalcoven.
com/

When you do things right,
people won't be sure you've done anything at all.
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

MySQL,
Yes, nightly maintainance.
---
/usr/local/sbin/dbmail-util -d -y
/usr/local/sbin/dbmail-util -p -y
/usr/local/sbin/dbmail-util -ty
---


> -----Original Message-----
> From: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] On
> Behalf Of Dave Logan
> Sent: sexta-feira, 1 de Agosto de 2008 21:40
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Db growing size
> 
> > In 2.3x version, with the new database design, the
size that the
> database
> > has, it's not the real size.
> >
> > I have now 52GB of DB Size, but comparing with the
email that is
> stored in
> > this very moment:
> >
> > "SELECT
round((sum(curmail_size)/1024)/1024,2) FROM dbmail_users
;"
> >
> > Result:
> >
> > 8648.34
> Jorge, I'm not sure if you're using PG or Mysql, but
I'm going
> to assume that you're doing all the normal (proper)
maintenance
> of your database (vacuum and such)?
> 
> 
> --
> 
> Dave Logan
> http://www.digitalcoven.
com/
> 
> When you do things right,
> people won't be sure you've done anything at all.
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Jorge Bastos wrote:
> Hi Paul,
> 
>  
> 
> In 2.3x version, with the new database design, the size
that the
> database has, it’s not the real size.
> 
> I have now 52GB of DB Size, but comparing with the
email that is stored
> in this very moment:
> 
> “SELECT round((sum(curmail_size)/1024)/1024,2) FROM
dbmail_users ;”
> 
> Result:
> 
> 8648.34
> 
> Wich mean that I have currently about 8,5GB of email.
> 
>  
> 
> Is there something to tune this?
> 
> Is there a special reason for this huge size?
> 

In case you are using the standard innodb pool - yes. The
pool never shrinks,
and unless you "defragment" it, it will keep
growing. In order to avoid this
situation it is very advisable to use
http://dev.mysql.com/doc/refman/5.0/en/multiple-
tablespaces.html
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I'm already using innodb_file_per_table,
In fact it's my default for my MySQL Servers.



> -----Original Message-----
> From: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] On
> Behalf Of Peter Rabbitson
> Sent: sexta-feira, 1 de Agosto de 2008 22:32
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Db growing size
> 
> Jorge Bastos wrote:
> > Hi Paul,
> >
> >
> >
> > In 2.3x version, with the new database design, the
size that the
> > database has, its not the real size.
> >
> > I have now 52GB of DB Size, but comparing with the
email that is
> stored
> > in this very moment:
> >
> > SELECT round((sum(curmail_size)/1024)/1024,2) FROM
dbmail_users ;
> >
> > Result:
> >
> > 8648.34
> >
> > Wich mean that I have currently about 8,5GB of
email.
> >
> >
> >
> > Is there something to tune this?
> >
> > Is there a special reason for this huge size?
> >
> 
> In case you are using the standard innodb pool - yes.
The pool never
> shrinks,
> and unless you "defragment" it, it will keep
growing. In order to avoid
> this
> situation it is very advisable to use
> http://dev.mysql.com/doc/refman/5.0/en/multiple-
tablespaces.html
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Jorge,

Jorge Bastos schrieb:
>
>
>[size of your db]

what about your db size? Can you tell us your experience?

Thanks,
	Uwe


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org


iQEVAwUBSKF3Yts3frmum9swAQKwNggAk6wgPCgUH6MyoiBhr+LizPaZgqgW
1AlK
NMgqJgmX2naJnmRCq1Di1uqTZhm3gBg8VHbdmavIcAgM5uD9VqRTv6EflD42
Retj
WBJsKccMSfCN8vYFyRKslq60gIo9v48UaDkl51eo/pWdVZilYjzEeGc909MK
9PiV
zbPm3ltLff7N/gi9Mo+dRfpe/NoyYBTmyzlff9pOQrELg1t5xKxBUmKxZlI1
1zGm
NsAg1RWBC0UI1/y4G2EwJRpJB4n40R5ofAFrAwt3FVlBd1Z+oMcohSV0WjMj
RxtH
FwzmuZ/hp5PfotR7hobp9OXaQjjz4EUcdL7b9P4ghdiHz/3AvHvC4g==
=acNb
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Well, my DB now has 53GB, and when I first posted this,
after a optimize
table on 2/3 tables I was with 49GB, so 4GB more, and I
don't have more 4GB
in email storage.
I don't know if Paul is on vacation or so, but it must be
something here not
right in dbmail_mimeparts table.
I still haven't the opportunity to do a optimize table on
dbmail_mimeparts
because I only have a 100GB disk, so remaining space is less
than the table
size.




> -----Original Message-----
> From: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] On
> Behalf Of Uwe Kiewel
> Sent: ter�a-feira, 12 de Agosto de 2008 12:44
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Db growing size
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Hi Jorge,
> 
> Jorge Bastos schrieb:
> >
> >
> >[size of your db]
> 
> what about your db size? Can you tell us your
experience?
> 
> Thanks,
> 	Uwe
> 
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

> 
>
iQEVAwUBSKF3Yts3frmum9swAQKwNggAk6wgPCgUH6MyoiBhr+LizPaZgqgW
1AlK
>
NMgqJgmX2naJnmRCq1Di1uqTZhm3gBg8VHbdmavIcAgM5uD9VqRTv6EflD42
Retj
>
WBJsKccMSfCN8vYFyRKslq60gIo9v48UaDkl51eo/pWdVZilYjzEeGc909MK
9PiV
>
zbPm3ltLff7N/gi9Mo+dRfpe/NoyYBTmyzlff9pOQrELg1t5xKxBUmKxZlI1
1zGm
>
NsAg1RWBC0UI1/y4G2EwJRpJB4n40R5ofAFrAwt3FVlBd1Z+oMcohSV0WjMj
RxtH
>
FwzmuZ/hp5PfotR7hobp9OXaQjjz4EUcdL7b9P4ghdiHz/3AvHvC4g==
> =acNb
> -----END PGP SIGNATURE-----
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On Wednesday 20 August 2008 Jorge Bastos wrote:
> Tell me, are those queries safe?
> I haven't time to test them on a test server, is you
confirm me that
> they are safe, I'll run them on the production server
right after the
> nightly dbmail-util.
> So, are they safe?

Jorge, I don't want to step on your toes, but the whole 2.3
thingy is 
*TEST* state. Everybody warned you to use it in production,
and if you 
do, you shouldn't call Paul all the time for help. Or maybe
you pay him 
for support already, then I guess he will be glad to help
you. You might 
be better of to install a 2.2 server, and move your mail via
IMAP client 
to that server.

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: www.keyserver.net                   Key-ID:
1C1209B4


_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail