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
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:2