Yes.
Mysql tables default to a set maximum size, so alter table to change max rows and max row
size.
I think that was what I did..., (but it was some time ago and I have moved jobs, so much
of my memory has been wiped...)
Since going to 2.4 we had index files of over 20G
Robin Keech
Java Developer
Synectics Ltd
-----Original Message-----
From: Andy Smith [mailto:andy@stripped]
Sent: 15 May 2003 16:39
To: mysql@stripped
Subject: Re: Linux x86 file size limit w.r.t. MySQL
On Thu, May 15, 2003 at 03:20:51PM +0100, Andy Smith wrote:
> Hi folks,
>
> One of our tables has grown to 4GB. We are using Linux 2.4.20 on x86
> with ext3 fs. I have read the MySQL manual which seesm to suggest
> that the RAID option is the only way forward.
>
> Has anyone else had any luck getting 4GB+ tables on this platform with
> e.g. reiserfs? Or maybe there is some kernel option I am missing.
A bit more investigation shows that since my linux box is already able to create files
larger than 4GB with ext3, this must be a MySQL limitation and the RAID option is my only
choice now. Am I correct here?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.474 / Virus Database: 272 - Release Date: 18/04/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.474 / Virus Database: 272 - Release Date: 18/04/2003
