Hi Erik:
Sorry to hear about your mishap.
I have seen before what you write about your _messageblks and assigned it to
mismatched ibdata files and logs. Things look good for a while but as the
system tries to run on a mismatched set of referenced relationships through
the messages structure, you get peculiar manifestations which evolve into a
totally and unpredictably confounded _messageblks, _messages and more.
You might think about your mail system's behaviour before it "restarted
abruptly the other night due to power loss". Was it working well, prior? It
seems strange that a sudden power down would cause this much harm. I wonder
why things messed up in the first place? Have you perhaps over or under
allocated memory for Innodb buffers and logs? (Perhaps other folks might
comment on buffer/log memory allotments.)
Because of the recent mishaps-- are you using inadvertently all or part of
your old log and ibdata files.
Some notes:
*innodb_buffer_pool_size*
Allow as high as possible to minimize slow disk usage. You can set this up
to 80% of the total available memory left after DBMail has what it needs to
run *your* normal number of processes as set out in your dbmail.conf file.
*innodb_log_file_size*
should be up to 25 % of buffer pool size --some folks do much more (see
perf. note below)
*innodb_additional_mem_pool_size*
stores the internal data structure--- big enough to store data about all
your InnoDB tables
For some interesting data on MySQL / InnoDB *performance*, check this out:
http://dbma.ca/SourceLabsMySQLInnoDBScalabilityReport.pdf
best... Mike
----- Original Message -----
From: "Erik Kristensen" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <dbmail@dbmail.org>
Sent: Sunday, October 30, 2005 9:00 AM
Subject: [Dbmail] mysql innodb dbmail_messageblks getting corrupt
Morning everyone,
Over the last few days I have been having some very frustrating
experience with dbmail and I haven't been able to totally narrow it
down to an issue with the server, mysql server, or dbmails injection
into the database.
dbmail version: 2.0.7
Apparently the server that I am having these issues with restarted
abruptly the other night due to power loss, at which time it seems
that the database got corrupt. I was able to do innodb_force_recovery
= 1 in the my.cnf file so that I could get a clean dump of the
database since my other backup solution had failed ....
After I got the clean dump of the database, I dropped my old dbmail
database completely that still had corrupt data in it. I recreated the
database inserted the data back into the system from the dump file.
Everything seem to work fine for several hours .... last night the db
was showing up corrupt again ... and it is only the dbmail_messageblks
table that is showing corrupt.
Anyone else had issues? Anyone have any ideas? Thanks ...
-Erik
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
