|
|
|
|
  |
  Group: Members
Posts: 436 Joined: 21-January 05 From: Koronadal City, Philippines Member No.: 3,358  |
Post
#1
 Apr 28 2005, 07:30 AM
Hey guys I was wondering if MySQL has a space limit. I know that MSAccess has a limit of 2GB and that SQL Server doesn't, only the harddisk capacity. Do you guys know?
 
|
|
Group: Members
Posts: 96 Joined: 20-April 05 Member No.: 5,931 |
Post
#2
Apr 28 2005, 11:09 AM
QUOTE MySQL Version 3.22 had a 4 GB (4 gigabyte) limit on table size. With the MyISAM table type in MySQL Version 3.23, the maximum table size was pushed up to 8 million terabytes (2 ^ 63 bytes). Note, however, that operating systems have their own file-size limits. Here are some examples: Operating System File-Size Limit Linux-Intel 32 bit 2 GB, 4GB or more, depends on Linux version Linux-Alpha 8 TB (?) Solaris 2.5.1 2 GB (possible 4GB with patch) Solaris 2.6 4 GB (can be changed with flag) Solaris 2.7 Intel 4 GB Solaris 2.7 UltraSPARC 512 GB i hope this answer your question. [note=snlildude87]Use the quote tags whenever applicable[/note] This post has been edited by snlildude87: Apr 29 2005, 11:31 PM
|
|
Group: Members
Posts: 436 Joined: 21-January 05 From: Koronadal City, Philippines Member No.: 3,358 |
|
|
Group: Members
Posts: 2,325 Joined: 8-March 05 From: Mawson, Antarctica Member No.: 4,254 |
Post
#4
Apr 29 2005, 11:36 PM
QUOTE(leiaah @ Apr 29 2005, 08:06 PM) Ummm..okay thanks. What is MyISAM?  [right][snapback]136154[/snapback][/right] QUOTE(http://dev.mysql.com/doc/mysql/en/myisam-storage-engine.html) MyISAM is the default storage engine as of MySQL 3.23. It is based on the ISAM code but has many useful extensions. Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table definition. The data file has an .MYD (MYData) extension. That explains why you get more space with myisam....
|
|
Similar Topics
| Topic Title | Replies | Topic Starter | Views | Last Action | |||
|---|---|---|---|---|---|---|---|
 |
1 | electropunks | 4,472 | 19th June 2004 - 11:33 AM Last post by: OpaQue |
|||
|
3 | Shackman | 4,104 | 9th February 2009 - 05:52 PM Last post by: Ash-Bash |
|||
 |
19 | Shackman | 19,074 | 28th January 2009 - 11:30 AM Last post by: miladinoski |
|||
|
7 | Shackman | 3,333 | 30th July 2004 - 10:59 AM Last post by: Shackman |
|||
|
98 | OpaQue | 88,307 | 19th June 2009 - 03:00 AM Last post by: The Simpleton |
|||
|
 |
3 | chalawanonline | 6,269 | 2nd August 2004 - 02:34 PM Last post by: Spectre |
||
|
 |
0 | OpaQue | 8,507 | 31st July 2004 - 09:13 PM Last post by: OpaQue |
||
|
2 | dontmaimyourself | 4,868 | 1st August 2004 - 07:20 PM Last post by: OpaQue |
|||
|
7 | Raptrex | 13,184 | 27th August 2004 - 11:16 PM Last post by: Spectre |
|||
|
 |
4 | NuHoaXuLa | 6,230 | 29th August 2004 - 03:12 AM Last post by: NuHoaXuLa |
||
|
0 | OpaQue | 3,416 | 29th August 2004 - 12:21 AM Last post by: OpaQue |
|||
|
11 | Triple X | 6,339 | 5th September 2004 - 02:33 AM Last post by: Triple X |
|||
|
16 | Eric Straven | 6,254 | 4th September 2004 - 07:34 PM Last post by: zip_mc |
|||
|
4 | Schweden | 4,966 | 8th September 2004 - 09:40 AM Last post by: Schweden |
|||
|
2 | Too_Hot | 3,611 | 16th September 2004 - 05:25 PM Last post by: serverph |
|||
|
Open Discussion | Time is now: 7th November 2009 - 01:56 AM |
Web Hosting Powered by ComputingHost.com.
