Re: delay_key_write usage

2004-09-17 Thread Egor Egorov
Paul DuBois <[EMAIL PROTECTED]> wrote: >>> According to the documentation, when delay_key_write is active the index >>> keys aren=92t written to disk until the table(s) are closed. When is a = >>> table >>> closed? Is it only when a connection is cl

Re: delay_key_write usage

2004-09-13 Thread Paul DuBois
At 19:41 +0300 9/13/04, Egor Egorov wrote: "Dan Cumpian" <[EMAIL PROTECTED]> wrote: According to the documentation, when delay_key_write is active the index keys aren=92t written to disk until the table(s) are closed. When is a = table closed? Is it only when a connection

Re: delay_key_write usage

2004-09-13 Thread Egor Egorov
"Dan Cumpian" <[EMAIL PROTECTED]> wrote: > > According to the documentation, when delay_key_write is active the index > keys aren=92t written to disk until the table(s) are closed. When is a = > table > closed? Is it only when a connection is closed? When connecti

delay_key_write usage

2004-09-10 Thread Dan Cumpian
According to the documentation, when delay_key_write is active the index keys aren’t written to disk until the table(s) are closed. When is a table closed? Is it only when a connection is closed? Thank you, Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus

MySQL 3.23 has index crashes with DELAY_KEY_WRITE=1

2002-08-09 Thread Iain Wade
he indices to disk (DELAY_KEY_WRITE=1 on the MyISAM tables). This is a *big* win. Every hour/day the previous hour/days records are "summarised" up a level. (REPLACE INTO summary_table SELECT foo FROM raw_usage_table GROUP BY bar) I'm replicating from a MySQL 3.23 master to a number of 4.01a sl

Re: delay_key_write

2002-05-13 Thread Benjamin Pflugmann
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 ha

Re: delay_key_write

2002-05-11 Thread Benjamin Pflugmann
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"

delay_key_write

2002-05-11 Thread sup-mysql
Hello there, Does anyone know what the MySQL delay_key_write variable do? Ramon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To