RE: [cobalt-users] Mysql table size limit

[Mark Roebuck <mroebuck@xxxxxxxxxxxxxxxxxxx>]

	<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


	Yes, Thanks

	I was just reading about this when the digest arrived. How can I
tell if the mysql version is configured with this support?

	Thanks

	Mark Roebuck


	 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/02