mysql可以存储多少行? [英] How many rows can mysql store?

问题描述

所以我是一个初学者，几个月来我自己才学习MySQL.我总是在工作中使用phpmyadmin.我过去的工作仅涉及具有约10万行的表，因此没有大的问题.

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.

但是，我的客户现在希望在一个表中存储约800万行.对于MySQL/phpmyadmin来说，存储和处理太多了吗?

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?

非常感谢

推荐答案

只需对其进行Google搜索:

Just Google it:

在InnoDB中，表大小限制为64 TB，MySQL行大小限制为65,535，可以有1,073,741,824行.那将是利用最大行大小限制的最小记录数.但是，如果行大小较小，则可以添加更多记录

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

这就是它的意思.

因此，答案可能有1,073,741,824行.

这篇关于mysql可以存储多少行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！