Table Crashing frequently

[bravo]

hi
i am using mysql ver 5.0 , one table is crahsing frequently
i need to know why .. is it becoz of the query iam running
or i have some problem with db ..
what i have done is given below :

1. created a table with a primary key and having one long text field
with max _rows and avg_row_length so as to increase the
4 GB limit of MyISAM.

CREATE TABLE IF NOT EXISTS smsc_inb (  c1 varchar(20) NOT NULL DEFAULT '' ,  c2 varchar(50) DEFAULT '0000-00-00 00:00:00' ,  c3 int(10) unsigned DEFAULT '0' ,  c4 longtext ,  c5 tinyint(3) unsigned NOT NULL DEFAULT '0' ,  c6 tinyint(3) unsigned NOT NULL DEFAULT '0' ,  c7 varchar(15) ,  c8 tinyint(3) unsigned NOT NULL DEFAULT '0' ,  c9 tinyint(3) unsigned NOT NULL DEFAULT '0' ,  c10 varchar(15) ,  c11 tinyint(3) unsigned NOT NULL DEFAULT '0' ,  c12 varchar(15) NOT NULL DEFAULT '' ,  c13 int(5) unsigned DEFAULT '0' ,  c14 int(5) unsigned DEFAULT '0' ,  c15 decimal(12,5) NOT NULL DEFAULT '0.00000' ,  c16 varchar(15) NOT NULL DEFAULT '' ,  c17 varchar(15) ,  c18 char(1) DEFAULT 'F' ,  PRIMARY KEY (c1))ENGINE=MyISAM AVG_ROW_LENGTH=134 MAX_ROWS=110000000 DEFAULT CHARSET=latin1 ;

2. inserted data in the table using the query

INSERT INTO table_name (c1, c2, c3, c4, c7, c10, c12, c16, c17) VALUES ('"+v1+"', '"+v2+"','"+v3+ "','"+v4+"','"+ v5+"','"+v6+"', '"+v7+"','"+v8+ "','"+v9+"' ,)";

what is happening now is as the data grows above 20 to 30 million or the size reaches near 4 GB the table crashes some time above 4 GB it goes but crashes even if i run a simple select query. say

select count( * ) from table;

after repairing , the table crashed more

how to know what is going wrong ...
any suggestions please...

[debasisdas]

what do you mean by table crashes ?

is it taking too long to fetch rows or your system hangs ?

[bravo]

what do you mean by table crashes ?

is it taking too long to fetch rows or your system hangs ?

Dada , By table crashes i mean that i got the error
The table is marked as crash.. and still i am facing the problem, not very frequently but still i need a solution for that....
actually nobody replied for a long time so i didnt opened this forum
today i saw atleast one response ... thanks for it...

[debasisdas]

please pass more infor about the exact nature of the error with error message.