| Author |
 Topic Search  Topic Options
|
huwnet 
Senior Member
Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: MySQL
Posted: 11 May 2004 at 11:18am |
|
Some info I need for a project!
1)What is the maximum number of records for a MySql Table?
2)Are there any free tools to setup the tables (add rows blah, blah). There is a MySQL administrator but it dosen't yet have these feautres.
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 11:22am |
1) No idea but its a lot, your not likely to fill it up
2) You can do all of that via the command line, theres a good tutorial somewhere but it's on my other HD... If I boot up into it tonight I will send you a link
|
|
huwnet
Senior Member
Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 11:35am |
|
1) I am writing a script that will calculate the 7 time table and enter it into database. So it may fill up quickly!
|
|
huwnet
Senior Member
Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 12:48pm |
|
Also what database type should I use?
MyISAM
InnoDB
HEAP
BDB
ISAM
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 1:58pm |
|
Well how many records are you looking at? Just saying it's the 7 times table doesn't say how many records you need... you could just be going up to 70 for all we know
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 2:49pm |
From the mySQL Manual that most people probably don't bother to read
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. On Linux, the current limit is 2G; on Solaris 2.5.1, the limit is 4G; on Solaris 2.6, the limit is 1000G. This means that the table size for MySQL is normally limited by the operating system.
By default, MySQL tables have a maximum size of about 4G. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name. 7.20 SHOW syntax (Get information about tables, columns,...).
If you need bigger tables than 4G (and your operating system supports this), you should set the AVG_ROW_LENGTH and MAX_ROWS parameter when you create your table. 7.6 CREATE TABLE syntax. You can also set these later with ALTER TABLE. 7.7 ALTER TABLE syntax.
If your big table is going to be read-only, you could use pack_isam to merge and compress many tables to one. pack_isam usually compresses a table by at least 50%, so you can have, in effect, much bigger tables. pack_isam.
Another solution can be the included MERGE library, which allows you to handle a collection of identical tables as one. (Identical in this case means that all tables are created with identical column information.) Currently MERGE can only be used to scan a collection of tables because it doesn't support indexes. We will add indexes to this in the near future.
|
|
|
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 2:53pm |
|
just did a quick whirl on a mySQL table and
alter table weather max_rows = 200000000000 avg_row_length = 50
did not return an error so as I doubt you hit 200 Billion rows that quick I'd say you are good to go
|
|
|
|
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 3:54pm |
|
Why would you want to store the 7* table in a database anyway?
|
|
