What is maximum records quantity a MySQL table can store?

mysql innodb myisam
Ivan picture Ivan · Oct 8, 2010 · Viewed 11.7k times · Source

How many records can a MySQL MyISAM table store? How many InnoDB can?

Answer

Thariama picture Thariama · Oct 8, 2010

You can't count by number of records because your table can have really short records with only a few int fields or your records might be really long with hundreds of fields.

So it has to be measured in the file size of the tables.

For MYSQL: The table size limit is based on the operating system drive file system that MySQL is installed on, ranging from 2GB to 2TB.

See the MySQL reference manual for full explanations of limits for each operating system.

Concerning InnoDb and MyIsam i do not know.

Related questions

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?

Read More
MyISAM versus InnoDB

I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would also include updates which I consider to be one read and one write. The reads can be dirty (e.g. …

Read More
What's the difference between MyISAM and InnoDB?

I understand that this question has been asked before, but most of the time it is asked in relation to a specific database or table. I cannot find an answer on this site that describes the two engines and their …

Read More