Results 1 to 5 of 5

Thread: size question

  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: size question

    Will having 150ish tables in my DB make it slow? If not, how many would, if ever?

    And is there a max to tables in a DB, max to columns or rows in tables?

    Thanks

  2. #2
    Join Date
    Jul 2004
    Posts
    3
    Anybody know?

  3. #3
    Join Date
    Jul 2004
    Location
    Dundee, Scotland
    Posts
    107
    In answer to your question, the number of tables in the MySQL database will not make it slow.

    MySQL handles large databases. The MySQL company know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.

    Assume:
    - A table cannot contain more than 1000 columns.
    - Up to 32 indexes per table are allowed. Each index may consist of 1 to 16 columns or parts of columns.
    - MySQL Version 3.22 had a 4 GB (4 gigabyte) limit on table size. With the MyISAM table type in MySQL Version 3.23, the maximum table size was pushed up to 8 million terabytes (2 ^ 63 bytes). Note, however, that operating systems have their own file-size limits.
    - By default, MySQL tables have a maximum size of about 4 GB. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name.

  4. #4
    Join Date
    Jul 2004
    Posts
    3
    Wow.

    Thanks for the info, that makes me feel so much better.

  5. #5
    Join Date
    Jan 2004
    Location
    Australia
    Posts
    42
    How do I know the current table size ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •