Geek Answers Handbook

How much data can be stored in MySQL?

I'm just new to 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 a different database? Which is faster? I mean, what has the highest write / read speed? Do I need to reconfigure to add more data?

+6
database mysql
source share
2 answers

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 speed almost does not concern you, your bottleneck will be your Internet connection.

+12
source share

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

InnoDB size limits

  • Maximum number of tables: 4 G
  • Maximum table size: 32 TB
  • Columns per table: 1000
  • Maximum line size: n * 4 GB
  • 8 kB when saving on the same page
  • n * 4 GB with n BLOB
  • Maximum key length: 3500
  • Maximum table space size: 64 TB
  • Maximum number of simultaneous trxs: 1023

Nanda Kishore Toomula

Sr DBA, Nokia India

CMDBA 5.0

0
source share

More articles:


All Articles