CODEWITHSUNDEEP
mysqlphpmyadmin
TDo
TDo

Reputation: 744

How many rows can MySQL store?

So I am a beginner and have just learned MySQL by myself for a few months. I always use phpMyAdmin in my work. My past work only involved tables with about 100k rows so there is no major issue.

However my client now wants to store about 8 million rows in a table. Is it too much for MySQL/phpMyAdmin to store and handle?

Thanks very much.

Upvotes: 7

Views: 15072

Answers (2)

Abishek V Ashok
Abishek V Ashok

Reputation: 523

Just Google it:

In InnoDB, with a limit on table size of 64 terabytes and a MySQL row-size limit of 65,535 there can be 1,073,741,824 rows. That would be minimum number of records utilizing maximum row-size limit. However, more records can be added if the row size is smaller

This is what it says.

So as the answer there can be 1,073,741,824 rows.

Upvotes: 19

Imran
Imran

Reputation: 3072

We don't know how big or small of your record. Short records can few integer fields or our records might be really big with hundreds of text or varchar fields. So measure of file size is the best way . This Officilal Information may help you

enter image description here

Upvotes: 4

Related Questions