Search code examples
mysqldatabase

How much data can be stored in MySQL?

I am just a beginner in MySQL, I need to know how much data can be stored in MySQL. I am developing a web crawler, can I store all the data in MySQL, or do I need to use another Database? Which is more faster? What I mean is, which has the highest Writing/Reading Rate? Do I need to reconfigure to add more data?

Solution

  • Depends on the 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+                   4TB
Solaris 9/10                 16TB
MacOS X w/ HFS+              2TB
NetWare w/NSS file system    8TB

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

    Your write/read rate is of little concern to you; your bottleneck will be your internet connection.