Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Maximum number of inserts in MySQL

What is the maximum number of inserts we can achieve with MySQL 5.7 and MySQL 8.0 assuming that the supporting hardware is optimal.
Best Answer
-
It depends on your frame of reference. How much data can you put into a table/schema? Inserts per second?
An InnoDB table can have a maximum of 1017 columns with a maximum of 64 secondary indexes. With 64k pages you can have a maximum of 256tb size tables. And you can always have multiple tables so the biggest amount of data is dependent more on your hardware and operating costs.
And do not forget the old MySQL protocol lets you send a maximum of roughly 1GB at a time.
So what do you mean by maximum inserts?
Dave Stokes
MySQL Community Manager
Answers
-
It depends on your frame of reference. How much data can you put into a table/schema? Inserts per second?
An InnoDB table can have a maximum of 1017 columns with a maximum of 64 secondary indexes. With 64k pages you can have a maximum of 256tb size tables. And you can always have multiple tables so the biggest amount of data is dependent more on your hardware and operating costs.
And do not forget the old MySQL protocol lets you send a maximum of roughly 1GB at a time.
So what do you mean by maximum inserts?
Dave Stokes
MySQL Community Manager