Hi.
Please don't write only to me, but also to the list.
On Mon, May 13, 2002 at 09:35:46AM -0400, [EMAIL PROTECTED] wrote:
> Benjamin
>
> I had seen that article before, but I still don't understand what
> "delay_key_write" does?
Well, than you better had asked, what the explanation in the manual
means. Would have saved both of us time.
delay_key_write determines whether DELAY_KEY_WRITE on CREATE TABLE
will be ignored or respected.
DELAY_KEY_WRITE influences when changes to the key buffer will be
flushed to disk, i.e. without DELAY_KEY_WRITE, MySQL will call the
appropriate OS function to write the changes to disk after every
change of the key buffer. With DELAY_KEY_WRITE, this will be done only
when the table is closed.
The key buffer hold the indexes and is usually changed when you insert
a new row, update an indexed column in a row and so on. With
DELAY_KEY_WRITE it has to be expected that on abnormal termination of
MySQL, the some of indexes were not written to disk yet and therefore
will be corrupted or inconsistent with the data file.
That is not really harmful as the indexes can be recreated from the
data file and your MySQL daemon should not terminate abnormally that
often. ;-)
However, as the manual recommends, you should add an automatic table
check to your MySQL start up script.
I hope this answered your question. If not, you should explain what
you understand and which part is still not obvious for you.
Bye,
Benjamin.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin
> Pflugmann
> Sent: Sunday, May 12, 2002 2:11 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: delay_key_write
>
>
> On Sat, May 11, 2002 at 11:30:07PM -0400, [EMAIL PROTECTED] wrote:
> >
> > Hello there,
> > Does anyone know what the MySQL delay_key_write variable do?
> > Ramon
>
> http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
>
> And I simply found that as second hit by typing "delay_key_write" it
> in the search field...
>
> Bye,
>
> Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
