Maxmimum numbers of table in MySQL database

[Mrugesh Panchal]

Dear All,

In MySql database maximum how many numbers of tables can we
create?
Please reply me. And also Is there is difference between InnoDB and
MyISSAM.

Thank you,
Panchal Mrugesh

[mahavir]

Hello Mrugesh

In mysql database we add n... number of table in one database
but there is some limitation with InnoDB and MyISSAM database because
in InnoDB only indexes will create with the table. and in MYISSAM
database type there is total 3 files are created ex. in backend side.
there is only limitation with the memory space with admin is allowed
how many files want to create on that.

[kalpesh mahida]

Hi Mrugesh,

The number of tables in a database is constraint by the operating system, 

So, Number of tables in a database = Number of files you can create in a directory.

MyISAM table stores your table information in three files. i) .frm ii) .MYD and iii) .MYI so it requires three files per table where as in case of InnoDB only one table is used.

So you can have more number of InnoDB table in a database compare to MyISAM.

There are few other constraint imposed on the size of table.

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.         

Operating System    File-size Limit Win32 w/ FAT/FAT32    2GB/4GB Win32 w/ NTFS    2TB (possibly larger) Linux 2.2-Intel 32-bit    2GB (LFS: 4GB) Linux 2.4+    (using ext3 file system) 4TB Solaris 9/10    16TB MacOS X w/ HFS+    2TB NetWare w/NSS file system    8TB

You can have more info on table size constraints from the here.

Hope this will help you.

Kalpesh Mahida

--
You received this message because you are subscribed to the Google
Groups "PHP :: Be a part of it" group.
To post to this group, send email to
php-be-a-...@googlegroups.com
To unsubscribe from this group, send email to
php-be-a-part-o...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/php-be-a-part-of-it?hl=en?hl=en

[Mrugesh Panchal]

Really Great Kalpesh....

Thank you...

But I have one question in my mind that if there are so, many tabales
in DB than at tha that phpmyadmin or SQLYog will do there
functionality well
means There will be the case of hang of application like that?

Thank you again Kalpesh Mahida...
Great!!!!

On Jul 19, 9:58 pm, kalpesh mahida <kalpesh.mah...@gmail.com> wrote:
> Hi Mrugesh,
>
> The number of tables in a database is constraint by the operating system,
> So, Number of tables in a database = Number of files you can create in a
> directory.
>
> MyISAM table stores your table information in three files. i) .frm ii) .MYD
> and iii) .MYI so it requires three files per table where as in case of
> InnoDB only one table is used.
>
> So you can have more number of InnoDB table in a database compare to MyISAM.
>
> There are few other constraint imposed on the size of table.
>
> The effective maximum table size for MySQL databases is usually determined
> by operating system constraints on file sizes, not by MySQL internal limits.
> The following table lists some examples of operating system file-size
> limits. This is only a rough guide and is not intended to be definitive. For
> the most up-to-date information, be sure to check the documentation specific
> to your operating system.

> *Operating System* *   File-size Limit* Win32 w/ FAT/FAT32    2GB/4GB Win32

> w/ NTFS    2TB (possibly larger) Linux 2.2-Intel 32-bit    2GB (LFS: 4GB)
> Linux 2.4+    (using ext3 file system) 4TB Solaris 9/10    16TB MacOS X w/
> HFS+    2TB NetWare w/NSS file system    8TB
>
> You can have more info on table size constraints from the

> here<http://dev.mysql.com/doc/refman/5.0/en/full-table.html>
> .

>
> Hope this will help you.
>
> Kalpesh Mahida
>

> On Mon, Jul 19, 2010 at 7:13 PM, mahavir <jspmaha...@gmail.com> wrote:
> > Hello Mrugesh
>
> >        In mysql database we add n... number of table in one database
> > but there is some limitation with InnoDB and MyISSAM database because
> > in InnoDB only indexes will create with the table. and in MYISSAM
> > database type there is total 3 files are created ex. in backend side.
> > there is only limitation with the memory space with admin is allowed
> > how many files want to create on that.
>
> > On Jul 19, 6:25 pm, Mrugesh Panchal <panchal.mrug...@gmail.com> wrote:
> > > Dear All,
>
> > >          In MySql database maximum how many numbers of tables can we
> > > create?
> > > Please reply me. And also Is there is difference between InnoDB and
> > > MyISSAM.
>
> > > Thank you,
> > > Panchal Mrugesh
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "PHP :: Be a part of it" group.
> > To post to this group, send email to
> > php-be-a-...@googlegroups.com
> > To unsubscribe from this group, send email to

> > php-be-a-part-o...@googlegroups.com<php-be-a-part-of-it%2Bunsu...@googlegroups.com>