[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [cobalt-users] Mysql table size limit
- Subject: RE: [cobalt-users] Mysql table size limit
- From: "Andy Brown" <andy.brown@xxxxxxxxxxxxx>
- Date: Wed Jul 3 09:39:34 2002
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
<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