List:General Discussion« Previous MessageNext Message »
From:Robin Keech Date:May 15 2003 4:18pm
Subject:RE: Linux x86 file size limit w.r.t. MySQL
View as plain text  
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
 
Thread
Linux x86 file size limit w.r.t. MySQLAndy Smith15 May
  • Re: Linux x86 file size limit w.r.t. MySQLAndy Smith15 May
  • Re: Linux x86 file size limit w.r.t. MySQLDan Nelson15 May
    • Re: Linux x86 file size limit w.r.t. MySQLAndy Smith18 May
RE: Linux x86 file size limit w.r.t. MySQLJon Wagoner15 May
RE: Linux x86 file size limit w.r.t. MySQLRobin Keech15 May