Daniel Mejia wrote:
Michael Monnerie-5 wrote:
Just put a max quota on your users accounts, then they *must* delete
some old e-mails.
We have a 1GB quota on all users, except for more or less, 20 users in the
management level, with the biggest quota at 3GB.
So with 2000 users you have
Paul J Stevens wrote:
So with 2000 users you have 2 to 3TB storage allocated already?
There is a 3TB of storage, with 800Gb used.
So don't run dbmail-util -ay on a 800GB database!
...
That is the header check (-b). You can safely skip that one, until you
decide to rebuild the
Daniel Mejia wrote:
Paul J Stevens wrote:
So with 2000 users you have 2 to 3TB storage allocated already?
There is a 3TB of storage, with 800Gb used.
So don't run dbmail-util -ay on a 800GB database!
...
That is the header check (-b). You can safely skip that one, until you
tabris wrote:
1. shut down the mysql server,
2. change the mysql.cnf file, and
3. restart the mysql server back up
Well, shutdown dbmail-lmtp and dbmail-imap (and dbmail-pop too),
then restart mysqld.
Not really required since dbmail-2.2 will shutdown all child process
handling
Paul J Stevens wrote:
tabris wrote:
1. shut down the mysql server,
2. change the mysql.cnf file, and
3. restart the mysql server back up
Well, shutdown dbmail-lmtp and dbmail-imap (and dbmail-pop too),
then restart mysqld.
Not really required since dbmail-2.2 will
tabris wrote:
Ok. Didn't know that. I know that it's supposed to handle LDAP dying,
but haven't had much luck with that either.
The code only deals with temporary ldap disconnections. If a ldap
connection goes stale the code will try to reconnect every 2 seconds,
and will try this 5 times. So
On Montag, 14. Dezember 2009 Daniel Mejia wrote:
still, the database size is increasing average 2GB per day
Just put a max quota on your users accounts, then they *must* delete
some old e-mails. If you don't use quota, people will never delete, as
they just don't realize they need some space.
still, the database size is increasing average 2GB per day. btw, do u happen
to know the maximum size mysql can handle? with the rate this is going, its
gonna be 2TB at the end of next year..
run the following query:
select userid,curmail_size from dbmail_users order by curmail_size desc
On Sun, 2009-12-13 at 20:14 -0800, Daniel Mejia wrote:
1. Is the dbmail_messageblks table cant be optimized?
It can be optimized, but there's probably no good reason to do it. I did
it once and it didn't increase the database speed it just took a long
time to do it.
2. What would u suggest
Josh Marshall-2 wrote:
1. Is the dbmail_messageblks table cant be optimized?
It can be optimized, but there's probably no good reason to do it. I did
it once and it didn't increase the database speed it just took a long
time to do it.
Would the optimization retrieve some space?
Would the optimization retrieve some space? ie: reducing the table
size?
It only recovers empty space and re-orders (like a defrag). If your
usage is increasing, the best way is to remove emails. Maybe you need to
run a dbmail-util to remove the deleted emails (there might be a SQL you
can run
Daniel Mejia wrote:
Josh Marshall-2 wrote:
1. Is the dbmail_messageblks table cant be optimized?
It can be optimized, but there's probably no good reason to do it. I did
it once and it didn't increase the database speed it just took a long
time to do it.
Would the
Josh Marshall-2 wrote:
It only recovers empty space and re-orders (like a defrag). If your
usage is increasing, the best way is to remove emails. Maybe you need to
run a dbmail-util to remove the deleted emails (there might be a SQL you
can run manually)
i did a cronjob to take care of
Daniel Mejia wrote:
Josh Marshall-2 wrote:
It only recovers empty space and re-orders (like a defrag). If your
usage is increasing, the best way is to remove emails. Maybe you need to
run a dbmail-util to remove the deleted emails (there might be a SQL you
can run manually)
i did a
Table dbmail_messageblks has almost 24Gb size (we have about 45000
emails each day!). So when OPTIMIZE TABLE dbmail_messageblks starts
Mysql sets locking on this table and write operations delays while
optimize process runnig.
It has a very long time to parse 25Gb of data (MySQL creates
Paul J Stevens wrote:
[EMAIL PROTECTED] wrote:
-rw-rw 1 mysql4 mysql4 23995613184 Oct 20 11:47 dbmail_messageblks.ibd
he! are those innodb table spaces? Been reading about them, but haven't
used them yet..
But isn't that a MyISAM database?
--
Best regards,
Danil V.
No. It's a innodb table space, where the innodb engine keeps separate
files per table. The shared table space is then mainly used for
housekeeping.
For all you myisam users: starting dbmail-2.1.x myisam is deprecated!
Better start getting used to innodb.
Danil V. Gerun wrote:
Paul J Stevens
Thanks, that's clear. I just didn't know, that InnoDB can store tables
in separate files..
Paul J Stevens wrote:
No. It's a innodb table space, where the innodb engine keeps separate
files per table. The shared table space is then mainly used for
housekeeping.
For all you myisam users:
Hi all!
After 1-2 months testing dbmail I have installed it on our main mail
server. Now everything is ALMOST fine, but some questions still not
resolved. The first question about dbmail-util.
If we run dbmail-util -arf our database starts performing
OPTIMIZE TABLE procedure.
Everything Ok,
[EMAIL PROTECTED] wrote:
-rw-rw 1 mysql4 mysql4 23995613184 Oct 20 11:47 dbmail_messageblks.ibd
he! are those innodb table spaces? Been reading about them, but haven't
used them yet..
Table dbmail_messageblks has almost 24Gb size (we have about 45000
emails each day!). So when
If anybody now how to do optimize MySQL tables in such hard terms
- please answer.
I'm open to suggestions and ideas here. I've been having this very same
problem.
http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.html
Big RDBMS (Sybase, Oracle) have advanced table partitioning
Ah, that'll help.
Looks like mysql-5 will have what we need:
http://dev.mysql.com/doc/refman/5.1/en/partitioning.html
I see it's on the TODO list for postgresql
http://www.postgresql.org/docs/faqs.TODO.html
Eugene Prokopiev wrote:
If anybody now how to do optimize MySQL tables in such hard
Merge tables are mainly based for having two identical tables then
'merging' them together with a third. I am guessing that he wants RAID
chucks in the 'create table' statement. Also, InnoDB has built in
functionality to create new files and roll over...
23 matches
Mail list logo