List:General Discussion« Previous MessageNext Message »
From:Denis Mercier Date:September 4 2003 6:04pm
Subject:RE: Table is full error
View as plain text  
I also had table is full error, today
actually.
  
mysql> alter table mytable max_rows = 200000000000 avg_row_length=50;

mysql> show table status like 'mytable' \G
*************************** 1. row ***************************
           Name: mytable
           Type: MyISAM
     Row_format: Dynamic
           Rows: 157
 Avg_row_length: 2257832
    Data_length: 354479668
Max_data_length: 1099511627775
   Index_length: 3072
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2003-09-04 12:17:56
    Update_time: 2003-09-04 12:18:09
     Check_time: NULL
 Create_options: max_rows=4294967295 avg_row_length=50
        Comment:
1 row in set (0.03 sec)

this fixed my problem.
      

Thread
Table is full errorKeith Bussey4 Sep
  • Re: Table is full errorKeith C. Ivey4 Sep
Re: Table is full errorKeith Bussey4 Sep
  • Re: Table is full errorKeith C. Ivey4 Sep
    • Re: Table is full errorColbey4 Sep
RE: Table is full errorDenis Mercier4 Sep
Re: Table is full errorKeith Bussey4 Sep
  • Re: Table is full errorColbey4 Sep
  • Re: Table is full errorKeith C. Ivey4 Sep
Re: Table is full errorKeith Bussey4 Sep
  • Re: Table is full errorcolbey4 Sep
Re: Table is full errorKeith Bussey4 Sep
  • Re: Table is full errorKeith C. Ivey4 Sep
Re: Table is full errorKeith Bussey4 Sep
  • Re: Table is full errorcolbey4 Sep
  • Re: Table is full errorKeith C. Ivey5 Sep
Re: Table is full errorDenis Mercier5 Sep