Jereymy,
Thanks a lot for your explanation on "Repair with key cache", I was reading
the online help, but could not get a clear picture of what was going on. So
I gess allocating as much memory as posible to the key buffer will improve
the performance of this stage?
Thanks
Ramon
-----Original Message-----
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 12:19 PM
To: [EMAIL PROTECTED]
Cc: Paul DuBois; Benjamin Pflugmann; [EMAIL PROTECTED]
Subject: Re: Repair with key cache
On Sat, May 11, 2002 at 08:39:55PM -0400, [EMAIL PROTECTED] wrote:
>
> Paul, do you have any idea what this "Repair with keycache" state,
> is all about.
It means that MySQL is building up the indexes on the imported data.
It is doing so using the keycache (or key_buffer) just as it does
during a REPAIR operation.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 4.0.2: up 3 days, processed 53,693,960 queries (172/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
