List:General Discussion« Previous MessageNext Message »
From:Ramon Arias Date:May 13 2002 1:23pm
Subject:RE: Repair with key cache
View as plain text  
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:jzawodn@stripped]
Sent: Sunday, May 12, 2002 12:19 PM
To: sup-mysql@stripped
Cc: Paul DuBois; Benjamin Pflugmann; mysql@stripped
Subject: Re: Repair with key cache


On Sat, May 11, 2002 at 08:39:55PM -0400, sup-mysql@stripped 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, <jzawodn@stripped>
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 <mysql-thread108795@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-sup-mysql=supsrv.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
quick sql questionAugey Mikus10 May
  • Re: quick sql questionPaul DuBois10 May
  • Re: quick sql questionAugey Mikus10 May
    • Re: quick sql questionPaul DuBois10 May
  • Re: quick sql questionAugey Mikus10 May
    • Re: quick sql questionPaul DuBois10 May
  • Re: quick sql questionAugey Mikus11 May
  • Re: quick sql questionAugey Mikus11 May
    • Re: quick sql questionPaul DuBois11 May
      • Repair with key cachesup-mysql11 May
        • Re: Repair with key cacheBenjamin Pflugmann11 May
          • Re: Repair with key cachesup-mysql11 May
            • Re: Repair with key cachePaul DuBois12 May
              • Re: Repair with key cachesup-mysql12 May
              • Re: Repair with key cachesup-mysql12 May
                • Re: Repair with key cachePaul DuBois12 May
                  • Re: Repair with key cachesup-mysql12 May
                    • Re: Repair with key cacheJeremy Zawodny12 May
                      • RE: Repair with key cacheRamon Arias13 May
                        • Re: Repair with key cacheJeremy Zawodny13 May
  • Re: quick sql questionAugey Mikus11 May