Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?

[Paul DuBois]

At 12:46 PM -0700 2000-01-05, Rick Moore wrote:
>Hi Monty!
>
>I just installed 3.23.8 and it still claims that CONCURRENT_INSERT is off by
>default.  I don't see a way to turn it "on"...  Do you think it's a
>misprint?
>
>| concurrent_insert      | OFF                                   |
>| datadir                | /usr/local/mysql/var/                 |
>| delay_key_write        | ON                                    |
>...
>| version                | 3.23.8-alpha                          |
>| wait_timeout           | 28800                                 |
>+------------------------+---------------------------------------+
>bash-2.03$


Same here under LinuxPPC, but under FreeBSD 3.3 the value is ON.

The initial value of this variable is controlled by the following
bit of code in myisam/mi_static.c:

#if defined(THREAD) && !defined(DONT_USE_RW_LOCKS)
my_bool myisam_concurrent_insert=1;
#else
my_bool myisam_concurrent_insert=0;
#endif

I'm not sure what controls the definitions of THREAD and DONT_USE_RW_LOCKS,
however.

-- 
Paul DuBois, paul@stripped