List:Bugs« Previous MessageNext Message »
From:Sinisa Milivojevic Date:March 20 2003 4:39pm
Subject:Re: long write queries hang the server
View as plain text  
Mark M. Ito writes:
> Indrek and Miguel,
> 
> Any ideas for a work-around?
> 

It is just now fixed.

Thank you so much for your test case.

Fix will come with 4.0.13, but this is a patch:


===== myisam/mi_dynrec.c 1.23 vs edited =====
*** /tmp/mi_dynrec.c-1.23-14575 Thu Nov  7 03:53:06 2002
--- edited/myisam/mi_dynrec.c   Thu Mar 20 18:38:45 2003
***************
*** 62,68 ****
  
    extra= (ALIGN_SIZE(MI_MAX_DYN_BLOCK_HEADER)+MI_SPLIT_LENGTH+
          MI_DYN_DELETE_BLOCK_HEADER+1);
!   reclength= (info->s->base.pack_reclength+
              _my_calc_total_blob_length(info,record)+ extra);
  #ifdef NOT_USED                                       /* We now support big rows */
    if (reclength > MI_DYN_MAX_ROW_LENGTH)
--- 62,68 ----
  
    extra= (ALIGN_SIZE(MI_MAX_DYN_BLOCK_HEADER)+MI_SPLIT_LENGTH+
          MI_DYN_DELETE_BLOCK_HEADER+1);
!   reclength= (info->s->base.pack_reclength+ info->s->base.pack_bits+
              _my_calc_total_blob_length(info,record)+ extra);
  #ifdef NOT_USED                                       /* We now support big rows */
    if (reclength > MI_DYN_MAX_ROW_LENGTH)

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com


Thread
long write queries hang the serverMark M. Ito14 Mar
  • Re: long write queries hang the serverIndrek Siitan14 Mar
    • Re: long write queries hang the serverMark M. Ito18 Mar
      • Re: long write queries hang the servermiguel solórzano19 Mar
        • Re: long write queries hang the serverMark M. Ito20 Mar
          • Re: long write queries hang the serverSinisa Milivojevic20 Mar