[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [cobalt-users] Mysql table size limit



<snip>
> What is the file size limit currently on a Raq4? 
> 
> I have a mysql table that is around 2gb and it has just started to be
> unstable. I wondered if it was a kernel limit and if there was a work
> around?
</snip>

Is the table in question created with the RAID_TYPE option set? Take a look at:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html

and look about 3/4 way down for the RAID_TYPE information, as I suspect rather than upgrading the kernel (which isn't advisable on a production RaQ/Cobalt system, AFAIK) you could use this, convert your table to a RAID-like array of directories, splitting up the 2Gb limit.

Hope this helps.
Regards,

Andy
andy@xxxxxxxxxxxxxxx
http://www.raqpak.com/ <-- Raq/Qube unofficial PKGs and support advice