CODEWITHSUNDEEP
mysqldatabase
Alex Mathew
Alex Mathew

Reputation: 1554

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?

Upvotes: 9

Views: 32953

Answers (3)

Kyalo Kitili
Kyalo Kitili

Reputation: 1034

This comes from their docs. MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).

Upvotes: 0

Tom Gullen
Tom Gullen

Reputation: 61729

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.

Upvotes: 12

Sher Singh
Sher Singh

Reputation: 287

https://forums.mysql.com/read.php?22,379547,381106

InnoDB Size Limits

  • Max # of tables: 4 G
  • Max size of a table: 32TB
  • Columns per table: 1000
  • Max row size: n*4 GB
  • 8 kB if stored on the same page
  • n*4 GB with n BLOBs
  • Max key length: 3500
  • Maximum tablespace size: 64TB
  • Max # of concurrent trxs: 1023

Nanda Kishore Toomula

Sr DBA,Nokia India

CMDBA 5.0

Upvotes: 0

Related Questions