[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Solved: Client still reports table  full
From:       "Jacob, Raymond A Jr" <raymond.jacob () navy ! mil>
Date:       2006-06-30 22:12:55
Message-ID: 653C8E7D21FB654997909E77C691053F0758F1D2 () NAEAWNYDEX21VA ! nadsusea ! nads ! navy ! mil
[Download RAW message or body]

 I forgot I have two databases snortdb and archive_snortdb with same
schema. 
Syslog did not distinguish between the two(2).
Both were suffering from the 4GB limit.
Once I increased max_row the error stopped on the client. 

Brent, Thanks again,
Raymond


-----Original Message-----
From: Brent Baisley [mailto:brenttech@gmail.com] 
Sent: Friday, June 30, 2006 8:49
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full

Wow, I'm really sorry about that. Left out a zero. I should stop
answering questions before the holiday weekend.

I was suggesting a minor change to 500 to see if that would work.
Everything I've read about adjusting for table full errors always
specifies both. Since only one was changed, MySQL might not have
realized things were different(?).

Unfortunately, there's not a whole lot of info on this topic, at least
that I can find. I learned a while ago to set these parameters when I
create the table if I think the table will be huge. I've also switched
to using merge tables, which makes it a lot easier to archive parts of
the table.

You might try running the alter table command again with both variables
specified.

----- Original Message -----
From: "Jacob, Raymond A Jr" <raymond.jacob@navy.mil>
To: <mysql@lists.mysql.com>
Sent: Thursday, June 29, 2006 5:21 PM
Subject: RE: Client still reports table full


If I understand the results from SHOW TABLE STATUS LIKE 'data';
My avg_row_length = 497 Why would descreasing it to 50 have a positive
Effect. I would assume I should increase it?

Thank you/Raymond

-----Original Message-----
From: Brent Baisley [mailto:brenttech@gmail.com]
Sent: Thursday, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full

Oops, left out an important part. You should change the Avg_row_length
also.

ALTER TABLE AVG_ROW_LENGTH = 50

You need to specify an average row length if you have dynamic length
fields in the table (blob, text, etc.).

Also, perhaps a silly question which you may have answered earlier, but
does you file system allow files larger than 4GB? Sometimes you have to
specifically enable that feature in a file system.

If that doesn't work, or you're limited to 4GB files, you may need to
switch to using a merge table.

----- Original Message -----
From: "Jacob, Raymond A Jr" <raymond.jacob@navy.mil>
To: <mysql@lists.mysql.com>
Sent: Thursday, June 29, 2006 1:37 PM
Subject: Client still reports table full


Yesterday:
I ran the following command:
ALTER TABLE data max_rows=11000000

 Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I still get the table is full error on the data table.

I ran the command:
\ echo "SHOW TABLE STATUS LIKE 'data';" | mysql -u user -p snortdb
\ below is the output.

Name Engine Version Row_format Rows Avg_row_length
Data_length Max_data_length Index_length Data_free
Auto_increment Create_time Update_time Check_time
Collation Checksum Create_options Comment
data MyISAM 9 Dynamic 8721565 497 4335220336
1099511627775 127599616 0 NULL 2006-06-28 20:54:55
2006-06-29 18:02:32 NULL latin1_swedish_ci NULL
max_rows=11000000

\\ df shows /var the partition with the database has enoungh room:
Filesystem    1K-blocks     Used   Avail Capacity  Mounted on
....
/dev/amrd0s1f  27792614 18449326 7119880    72%    /var
....

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=brenttech@gmail.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=brenttech@gmail.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]