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.p
df
best... Mike
----- Original Message -----
From: "Erik Kristensen" <erik.kristensen gmail.com>
To: "DBMail mailinglist" <dbmaildbmail.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
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|