Re: Huge tables under linux? - Jorge del Conde - com.mysql.lists.mysql

6 messages in com.mysql.lists.mysqlRe: Huge tables under linux?

From	Sent On	Attachments
Robert Wunderer	11 Dec 2000 04:46
Jorge del Conde	11 Dec 2000 20:19
Robert Wunderer	12 Dec 2000 02:50
Jorge del Conde	12 Dec 2000 08:30
Kyle Hayes	12 Dec 2000 09:24
Jerome Abela	13 Dec 2000 01:28

Subject:	Re: Huge tables under linux?
From:	Jorge del Conde (jor...@mysql.com)
Date:	12/12/2000 08:30:44 AM
List:	com.mysql.lists.mysql

Jorge,

Thanks for your reply.

So the 2GB limit is actually caused by 32-bit linux and is independent of the filesystem used for the database?

That's correct!

I am asking because somebody suggested using XFS to solve this problem. However since the system in question is a production system I am hesitant to try it yet.

Using XFS will probably not help much

Also I gave reiserfs a try which claims to be able to breakt the 2GB limit as long as the application uses 64 bit file functions.

So I was kinda hoping there would be a #define for MySQL that would make it use 64bit file functions instead of the "regular" functions.

You wont find such thing, on the later versions (3.23.X), since the problem is directly related to 32 bit systems....

Regards, Robert.

Regards Jorge

----- Original Message ----- From: "Robert Wunderer" <rwun...@fait.at> To: "Jorge del Conde" <jor...@mysql.com> Cc: <mys...@lists.mysql.com> Sent: Tuesday, December 12, 2000 4:50 AM Subject: Re: Huge tables under linux?

On Mon, Dec 11, 2000 at 10:20:19PM -0600, Jorge del Conde wrote:

The max table size is not really restricted in mysql 2.23.X versions

since

********Sorry here, I ment 3.23.X versions :)

it can be as big as 8 million terabytes.

The max table size under linux really depends on various standards (POSIX, SVID, XPG*, Unix98) that limit it to 2Gb on a 32-bit system (one where sizeof(long) == 4). "off_t" has to be a signed integral type, which effectively limits you to 31 bits.

Regards Jorge

Hi.

Is it possible to have huge (> 2GB) tables under linux kernel 2.2.17?

I know of the RAID option work around, but this cannot help if the index file grows beyond 2 GB.

I tried utilizing reiserfs for the database partition but tables still cannot grow beyond the omnious 2GB limit.

I am using MySQL 2.23.28-gamma, compiled from source.

Are there any special compile-time options I have to use or is it simply not possible to have >2GB under linux?

Thx. Robert.

------------------------------------------------ Robert Wunderer CTO FAIT Internet Software AG Landstrasser Hauptstr. 71/2, A-1030 Vienna, Austria phone: +43 1 717 28 - 130, fax: +43 1 717 28 - 110 mailto:robe...@fait.at http://www.fait.at