-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jorge Bastos schrieb: | |> Maybe you have a scenario like: |> |> 1. users got emails with big attachements -> db grows |> 2. users deleted the big emails -> db doesn't reduce the size of the |> tablespace until you use the optimize table command |> | | | | | It could be true that scenario, but not possible. | SELECT round(sum(maxmail_size)/1024/1024,2) FROM dbmail_users ;
maxmail_size? In my environment maxmail_size is 0 (zero) for every user. Well, I ran dbmail-util and optimize table for all dbmail-* tables. The used space at the filesystem now is about twice of SELECT round(sum(curmail_size)/1024/1024,2) FROM dbmail_users ; Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSJRHU9s3frmum9swAQJOhwf+LmosijiYR5kudZYkbN/YTGej2azZz0zy Um8v+RuQHDmBbID6U2zkSd8sbmKcWT3dw72hnIZ3+AaBTB5/lc53JrHWK7LM1bYb e/OIp1zbI0qp6Iwcs87EPOpl0ng/I+eLHfswl/5bHYkzAkrdCmQT9pvrL8avGfea wYi523n4uIc68bczKzTY1+DPc3sPrd5K0fNRdryQ+U66EcRBB+QNc2e1KBHpqXHb ME1NW1sYgEBousYJQsMTgdeW099CeLKIcn+bHGZZGrJv8ZBlsiSB54GeG6oux+uV A+PqrZLmJ8ebNc0d+saOaoJar9E0w1rjRjqoSj22OGYm8rC5DPUmZg== =Q+MY -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
