dbTalk Databases Forums  

"table is full" errors

comp.databases.mysql comp.databases.mysql


Discuss "table is full" errors in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
starman7
 
Posts: n/a

Default "table is full" errors - 01-11-2007 , 06:48 PM






I'm running a phpbb board using MySQL/InnoDB - running w/ SELINUX on

mysql Ver 14.7 Distrib 4.1.20

The board after a few hours will begin to experience errors - most
having to do with inserting, often the error will be table is full
(though it has not yet reached anywhere near max_rows).

Each of my 10 InnoDB segments is 250M - the machine has 2GB memory -

I have added
max_heap_table_size=256M
tmp_table_size=256M

innodb_buffer_pool_size is 300M


Does this ring any bells?

Thanks for any suggestions,
s7


Reply With Quote
  #2  
Old   
starman7
 
Posts: n/a

Default Re: "table is full" errors - 01-11-2007 , 09:20 PM






starman7 wrote:
Quote:
I'm running a phpbb board using MySQL/InnoDB - running w/ SELINUX on

mysql Ver 14.7 Distrib 4.1.20

The board after a few hours will begin to experience errors - most
having to do with inserting, often the error will be table is full
(though it has not yet reached anywhere near max_rows).

Each of my 10 InnoDB segments is 250M - the machine has 2GB memory -

I have added
max_heap_table_size=256M
tmp_table_size=256M

innodb_buffer_pool_size is 300M


Does this ring any bells?

Thanks for any suggestions,
s7
this app was moved from another server, i compared the previous DB and
the present using mysqlshow --status - and noticed that in the former,
there was very much more more innodb free (the new had only a few
megs/kbs free) - so i added 6 more innodb segments at 250M each -
restarted the db - and i have my fingers crossed. i think this could be
the solution.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.