Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

MySQL capacity

Started by Komp, Jan 27 2009 11:18 AM

This topic has been archived. This means that you cannot reply to this topic.

4 replies to this topic

#1
Komp

Posted 27 January 2009 - 11:18 AM

Newbie

Members
3 posts

Hi all!

Guys... I've got a question... does any body know how many tables can a MySQL DB handle???

Thanks in advance.

Komp.

#2
Xav

Posted 27 January 2009 - 12:18 PM

Writes binary right handed and hex left handed

Members
13,118 posts

I quote the MySQL forums site:

Quote

There are no server limits on number of tables for a database but, because each MyISAM table has associated files, then any os limits on the number of files allowed will have an effect. InnoDB tables and indexes etc. are stored in a single tablespace, with a maximum two billion tables.

Jordan said:

Good members, like yourself, stick around and post for ages to come!
Mr. Xav | Blog | Forums

#3
Komp

Posted 27 January 2009 - 01:07 PM

Newbie

Members
3 posts

2 billion??? dam... I guess thats enough for me xD jjaj :P

thx a lot

c ya

#4
Guest_Jordan_*

Posted 27 January 2009 - 01:10 PM

Guests

That is just InnoDB tables. You can have as many rows as you like inside the InnoDB tables. You must also consider Operating System limitations and Hardware limitations such as the number of files in a sub-directory (since each database is a new file) and the amount of free HD space you have (since each row takes up space).

I've also moved this to the database section since it isn't related to PHP.