• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

How many tables can I create with one created MySql database?

Hello,

Please can someone answer me, how many tables can I create with one created MySql database? I wish to program a dynamic user database and want to create up to 300 tables, is that possible or is there a any limits?

Thanks in advance!
Mike
0
idiwa
Asked:
idiwa
  • 4
1 Solution
 
PeeweeCommented:
idiwa,

It is certainly possible to create over 300 tables! MySQL has been known to handle thousands of tables with Terabytes of data.

I shall look at where some bottlenecks may occur.

Peewee

0
 
PeeweeCommented:
idiwa,
thinking about one of the obvious bottle necks will be your server spec, ie your ram processor and general infrastructure.

http://www.mysql.com/information/presentations/presentation-oscon2000-20000719/index.html

regards
Peewee
0
 
PeeweeCommented:
idiwa,
also have a quick look at:

http://www.mysql.com/doc/C/r/Creating_many_tables.html

peewee
0
 
PeeweeCommented:
idiwa,
glad to be of help.

Peewee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now