try
SHOW TABLE STATUS FROM dbmail;
This will show how much space is left in your innodb blocks - you're
probably running out of it. To create more space, simply edit your
my.cnf file (probably in /etc or /etc/mysql) and add some more ibdata
files. When restarting mysql, innodb will create the new files
automatically.
regards roel
Eelco van Beek heeft op woensdag, 30 apr 2003 om 22:44
(Europe/Amsterdam) het volgende geschreven:
I think your table space is full. You should create more table space.
mysql> select count(*) from messages;
+----------+
| count(*) |
+----------+
| 148237 |
+----------+
1 row in set (0.62 sec)
We're not experiecing any problems here.
Best regards,
Eelco
On woensdag, apr 30, 2003, at 22:29 Europe/Amsterdam, Jacques Beaudoin
wrote:
I'm testing (or stressting) dbmail and loading the tables with lots of
messages
before i attemp to migrate from uwimap to dbmail.
I did a mysql-innodb install and whent up to over 200,000 messages.
for my 3000 users.
Every thing looks ok except i had to restart dbmail-imap once.
I did a mysql install with no innodb i have now 106,499 messages
for my 3000 users and i get this messages in my maillog
The table "messageblks" is full.
Did i reach a mysql limit ?
Thanks
Jacques
_______________________________________________
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
_________________________
R.A. Rozendaal
IC&S
T: +31 30 2322878
F: +31 30 2322305
www.ic-s.nl
