Actually there is a maximum table limit , for MyISAM tables .. and that is 8
million terabytes, if you can ever reach that :
The limitations in MySQL is limited by the OS limits...
See: http://www.mysql.com/doc/T/a/Table_size.html
Gurhan
-Original Message-
From: Inbal Ovadia [mail
* Inbal Ovadia
> Is there any limitation about the number of rows in a table
> and about the number of tables that i can put in mysql?
The number of rows in a table is normally limited by the type of the primary
key. A TINYINT can only hold 256 values, thus you can only have 256 rows in
a table w
Hey,
> Hi,
> Is there any limitation about the number of rows in a table
> and about the number of tables that i can put in mysql?
Question has been asked many times. Check the lists.
Answer : no, only limited by drive space.
EG
--
[snip]
Is there any limitation about the number of rows in a table
and about the number of tables that i can put in mysql?
[/snip]
You are limited by disk space, RAM, and processing power. There are no AFIAK
"physical" limitations to MySQL itself.
Jay
-
