RE: [Dbmail] dbmail & mysql ..

2005-10-26 Thread Simon Gray
>I have a problem with mysql db ... >InnoDB: Page may be an index page where index id is 1481853025 1498166642 >InnoDB: Database page corruption on disk or a failed >InnoDB: file read of page 41223. >InnoDB: You may have to recover from a backup. >InnoDB: It is also possible that your operating >In

RE: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-26 Thread Simon Gray
> 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 creat