Home > MySQL > Maximum table we have a mysql database

Maximum table we have a mysql database

1. Limits on Number of Databases and Tables (giới hạn số table trong một CSDL MySQL)

Theo thông tin trên MySQl version 5.0, MySQl không giới hạn số table trong một CSDL. Khi thiết kế CSDL với kiểu engine InnoDB còn hỗ trợ lên tới 4 tỷ table, một con số rất lớn đáp ứng đủ cho các hệ thống website lớn.

MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of directories.
MySQL has no limit on the number of tables. The underlying file system may have a limit on the number of files that represent tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables.

2. Limits on Table Size (dung lựng lưu trữ của một bảng)
Tuy nhiên dung lượng lưu trự lại trên một table lại bị giới hạn, tùy theo định dạng của từng hệ thống

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

Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. Use NTFS instead.

nhantam
Web Design & Development in Ho Chi Minh (Saigon)

Advertisements
  1. 20/01/2015 at 21:24

    Reblogged this on SutoCom Solutions.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: