Re: How does key buffer work ?

2004-01-16 Thread Matt W
Hi John, - Original Message - From: [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 2:28 AM Subject: Re: How does key buffer work ? Matt, One last question and then I promise to drop the topic ... what would be the best way to force a complete load of an index into the key buffer

Re: How does key buffer work ?

2004-01-15 Thread john . everitt
] cc: Subject:Re: How does key buffer work ? Classification: Hi John, - Original Message - From: [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 6:37 AM Subject: Re: How does key buffer work ? Matt, Many thanks for the answer. It has helped

How does key buffer work ?

2004-01-14 Thread john . everitt
I've been trying to optimise the operation of a MySQL (4.0.13) installation on a Windows 2000 based web server. After going through the docs and browsing the net for some time, it seems that after ensuring that your database design is sound and your queries correctly structured with the right

Re: How does key buffer work ?

2004-01-14 Thread Matt W
Hi John, I'll give my comments. :-) - Original Message - From: [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 2:04 AM Subject: How does key buffer work ? I've been trying to optimise the operation of a MySQL (4.0.13) installation on a Windows 2000 based web server. First, I'd

Re: How does key buffer work ?

2004-01-14 Thread john . everitt
surely ? Anyway, thanks again for the response. John Matt W [EMAIL PROTECTED] 2004-01-14 11:18 To: John Everitt/EHV/CORP/[EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject:Re: How does key buffer work ? Classification: Hi John, I'll

Re: How does key buffer work ?

2004-01-14 Thread Matt W
Hi John, - Original Message - From: [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 6:37 AM Subject: Re: How does key buffer work ? Matt, Many thanks for the answer. It has helped enormously. First, I have been getting the odd index corruption that has proved to be very