List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 28 1999 12:00am
Subject:RE: DELAY_KEY_WRITE table option appears to be ignored
View as plain text  
>>>>> "web" == web  <web@stripped> writes:

web> Hi Sasha,
web> I just reverted from 3.23.7 to 3.23.5 due to a different bug and the ratio
web> of key_writes to key_write requests decreased dramatically from 1/10 to
web> 1/500, so I *think* the DELAY_KEY_WRITE table option *is* being ignored.

web> This isn't conclusive of course - only the code can tell us for sure ;-)

web> Jason

Hi!

You are right;  --delay-key-write didn't do anything in MySQL 3.23.7.
Here is a fix for this:

*** /my/monty/master/mysql-3.23.7-alpha/sql/mysqld.cc	Thu Dec  2 03:59:37 1999
--- ./mysqld.cc	Tue Dec 28 01:58:25 1999
***************
*** 2463,2468 ****
--- 2473,2479 ----
      }
      case OPT_DELAY_KEY_WRITE:
        ha_open_options|=HA_OPEN_DELAY_KEY_WRITE;
+       myisam_delay_key_write=1;
        break;
      default:
        fprintf(stderr,"%s: Unrecognized option: %c\n",my_progname,c);

The above fix will be included in MySQL 3.23.8

Regards,
Monty
Thread
DELAY_KEY_WRITE table option appears to be ignoredweb13 Dec
  • Re: DELAY_KEY_WRITE table option appears to be ignoredSasha Pachev14 Dec
RE: DELAY_KEY_WRITE table option appears to be ignoredweb16 Dec
  • RE: DELAY_KEY_WRITE table option appears to be ignoredMichael Widenius28 Dec