List:General Discussion« Previous MessageNext Message »
From:Emmett Bishop Date:June 16 2005 5:03am
Subject:Re: Table full
View as plain text  
Mike,

Thanks for the insight. The "sent" table has about 7
million records. The other tables involved have tens
of thousands of records or there abouts. Not your 100
million size but certainly worth exploring.

Thanks again,

Tripp

--- mos <mos99@stripped> wrote:

> Tripp,
>          This problem may occur if your table is
> quite large (several gb in 
> size). The update may make the table too large to
> address using 
> conventional MySQL pointers. You may need to modify
> the table so it has a 
> "Max Rows=nnnn" option where "nnnn" is the max rows
> you expect the table to 
> have and this forces MySQL to use a larger table
> pointer. When my tables 
> 
=== message truncated ===



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search. 
http://info.mail.yahoo.com/mail_250
Thread
How to write subqueries?Unknown Sender14 Jun
  • Re: How to write subqueries?SGreen14 Jun
    • RE: How to write subqueries?Rhino14 Jun
  • RE: How to write subqueries?Rhino14 Jun
  • Re: How to write subqueries?mfatene14 Jun
    • Re: How to write subqueries?Unknown Sender14 Jun
      • Re: How to write subqueries?mfatene14 Jun
        • Table fullEmmett Bishop15 Jun
          • Re: Table fullmfatene15 Jun
            • Re: Table fullEmmett Bishop15 Jun
              • Re: Table fullmfatene15 Jun
                • Re: Table fullEmmett Bishop15 Jun
                  • Re: Table fullmos16 Jun
                    • Re: Table fullEmmett Bishop16 Jun
                      • Re: Table fullmfatene16 Jun
        • Re: How to write subqueries?Unknown Sender15 Jun
    • Re: How to write subqueries?Unknown Sender14 Jun