4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Size limit
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Gandalf
WebHelper
WebHelper


Joined: 08 Jan 2002
Posts: 52
Location: Israel

PostPosted: Thu Jan 10, 2002 11:58 pm (15 years, 11 months ago) Reply with QuoteBack to Top

Out of sheer curiousity, does anyone know the size limit for a MySQL database and table?
OfflineView User's ProfileFind all posts by GandalfSend Personal MessageICQ Number
Jos
Ex Team Member



Joined: 08 Jan 2002
Posts: 36
Location: The Netherlands

PostPosted: Fri Jan 11, 2002 7:24 am (15 years, 11 months ago) Reply with QuoteBack to Top

Gandalf wrote:

Out of sheer curiousity, does anyone know the size limit for a MySQL database and table?


So far as I know is this for Linux 2G

________________________________
Jos
** Team Member ** http://www.josvanras.com **
OfflineView User's ProfileFind all posts by JosSend Personal MessageVisit Poster's Website
jayant
Team Member



Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India

PostPosted: Fri Jan 11, 2002 12:36 pm (15 years, 11 months ago) Reply with QuoteBack to Top

Size generally depends on operating system:

MySQL 3.22 has a 4G limit on table size. With the new MyISAM in MySQL 3.23 the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes).

Note however that operating systems have their own file size limits. Here are some examples:

Linux-Intel 2G (or 4G with reiserfs)
Linux-Alpha 8T (?)
Solaris 2.5.1 2G (possible 4G with patch)
Solaris 2.6 4G
Solaris 2.7 Intel 4G
Solaris 2.7 ULTRA-SPARC 8T (?)

This means that the table size for MySQL is normally limited by the operating system

Following is infor for MySQL 3.23 and 3.22 respectively:
Simultaneous connections (installation default): 101 and 101
Columns in table: 3398 and 2364
max table row length (without blobs): 65534 and 65534
table row length with nulls (without blobs): 65502 and 65501
query size: 1048574 and 1048574
[/b]

________________________________
Jayant Kumar
Member of the 4WebHelp Team
Nibble Guru - Computing Queries Demystified
GZip/ Page Compression Test
OfflineView User's ProfileFind all posts by jayantSend Personal MessageVisit Poster's WebsiteYahoo MessengerMSN Messenger
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.049988 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme