MySQL Forums
Forum List  »  MyISAM

Re: How to avoid 'Repair with keycache'
Posted by: Ingo Strüwing
Date: October 04, 2006 02:02PM

Hi.

For repair by sort myisam_max_sort_file_size must be bigger than (rows * maximum length of a key), in your case 40 million * 32, or if the char(32) is in UTF-8 (probable in your case) then 40 million * 32 * 3.

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
7858
September 07, 2006 10:16PM
Re: How to avoid 'Repair with keycache'
4094
October 04, 2006 02:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.