RE: [cobalt-users] Mysql table size limit

["Steven Young" <steven.young@xxxxxxxxxxxxxxx>]

> 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?


Snippets taken from the MySQL reference...

<SNIP>
MySQL Version 3.22 has a 4Gb limit on table size. With the new MyISAM table
type in MySQL Version 3.23, the maximum table size is pushed up to 8 million
terabytes (2 ^ 63 bytes) ... table size for MySQL databases is normally
limited by the operating system ... On Linux 2.2 you can get bigger tables
than 2Gb by using the LFS patch for the ext2 file system.
</SNIP>

So, yes you have reached your limit unless you want to tinker with the LFS
patch or as Gerald suggestes earlier, upgrade your kernel to 2.4.x

Steve