List:General Discussion« Previous MessageNext Message »
From:Helen M Hudson Date:September 25 2006 11:36am
Subject:Re: adding columns to a large table
View as plain text  
Thanks for all the help on this one.  Its a MyISAM table.  
I ended up creating a temp table and selecting the data in... took 2 mins.  I feel totally
blonde for not thinking of that earlier!
Thanks for being there, everyone!

Helen
  ----- Original Message ----- 
  From: praj 
  To: Helen M Hudson 
  Cc: MySQL List 
  Sent: Monday, September 25, 2006 1:23 PM
  Subject: Re: adding columns to a large table


  There must be some thing went wrong with your settings in my.cnf file.For an 3 million
records 24 hrs is bad :(

  > myisam_sort_buffer_size value in my.cnf ?

  Also you can apporx check the status by doing file size check on the table in database
dir and the temoprory table created in the data base dir .

  --
  Praj


  Helen M Hudson wrote: 
    let you know shortly or I have a table with about 3million rows and I'm having trouble
altering it to add 4 more columns.  I'm using the MySQL Administrator and I've left it
more than 24hours and its still not finished.  I was going to try using a login to the
console next, but is there a better way?  Any advice much appreciated! 
    Helen 



Thread
SUM in WHEREAhmad Al-Twaijiry18 Sep
  • AW: SUM in WHEREAndré Hänsel18 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry18 Sep
  • Re: SUM in WHEREEdward Macnaghten18 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry19 Sep
      • Re: SUM in WHEREAhmad Al-Twaijiry19 Sep
        • RE: SUM in WHERERandall Price19 Sep
          • Re: SUM in WHEREAhmad Al-Twaijiry19 Sep
  • Re: SUM in WHEREFelix Geerinckx21 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry24 Sep
RE: SUM in WHEREQuentin Bennett19 Sep
  • Re: SUM in WHEREDouglas Sims20 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry24 Sep
      • Re: SUM in WHEREDouglas Sims24 Sep
        • Re: SUM in WHEREAhmad Al-Twaijiry24 Sep
          • Re: SUM in WHEREDouglas Sims25 Sep
            • Re: SUM in WHEREAhmad Al-Twaijiry25 Sep
              • Re: SUM in WHEREPeter Brawley25 Sep
  • adding columns to a large tableHelen M Hudson25 Sep
    • Re: adding columns to a large tableEhrwin Mina25 Sep
      • RE: adding columns to a large tableMugunthan SIFY25 Sep
        • RE: adding columns to a large tableOw Mun Heng25 Sep
    • Re: adding columns to a large tablepraj25 Sep
  • Re: adding columns to a large tableHelen M Hudson25 Sep