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

starman7 wrote:
> 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.