>>>>> "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
