RE: Simultaneous SELECT and UPDATE on the same table

2002-03-08 Thread Corin Hartland-Swann
Hi there, On Fri, 8 Mar 2002, Paul DuBois wrote: > At 21:14 +0100 3/8/02, Roger Baklund wrote: > >* Paul DuBois > >> At 17:00 +0000 3/8/02, Corin Hartland-Swann wrote: > >[...] > >> >This works for a varying number of rows (usually 5,000 to 10,000) befo

Simultaneous SELECT and UPDATE on the same table

2002-03-08 Thread Corin Hartland-Swann
ops out of the loop at the same sort of interval (but often differs from run to run). Should this be working or should I find another way? If it is a bug then I will of course try to produce more information, but I just want to check I'm doing the right thing first. Many Thanks, Corin

ENUM NOT NULL without default value

2001-09-30 Thread Corin Hartland-Swann
''; mysql> DESCRIBE test_enum; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | e | enum('a','b','c') | | | | | +---+

Re: Optimising for 4096MB RAM

2001-08-12 Thread Corin Hartland-Swann
; The memory usage of MySQL thread will grow up with the time (each new key > scanned will stay in memory). Thanks for your help :) Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce I

Optimising for 4096MB RAM

2001-08-09 Thread Corin Hartland-Swann
Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web:

Effect of quoting numbers

2001-07-11 Thread Corin Hartland-Swann
: any replies to me as I am no longer on the list. Many Thanks, Corin /+---------\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings