List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 5 2000 11:36pm
Subject:Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?
View as plain text  
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
Thread
CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Rick Moore2 Jan
  • Database for use with DelphiMike Smith2 Jan
  • CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Michael Widenius2 Jan
  • Re: Database for use with Delphimiguel angel sol√≥rzano2 Jan
  • Re: Database for use with DelphiSven E. van 't Veer3 Jan
  • Re: Database for use with DelphiSven E. van 't Veer3 Jan
  • Re: Database for use with DelphiMike Smith3 Jan
  • Re: Database for use with DelphiMike Smith3 Jan
  • Re: Database for use with Delphisven4 Jan
  • Re: Database for use with DelphiSven E. van 't Veer5 Jan
  • Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Rick Moore5 Jan
    • Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Paul DuBois6 Jan
    • Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Michael Widenius6 Jan
  • Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Rick Moore6 Jan
  • Re: CONCURRENT_INSERT & DELAY_KEY_WRITE off or on?Rick Moore6 Jan