How much data can mysql store
MySQL is one of the databases commonly used by small and medium-sized websites. However, many people are not clear about how much data MySQL can actually support, coupled with the fact that some domestic CMS vendors have put the responsibility for the data carrying capacity on it, which has led to a lot of misunderstandings among many webmasters who don’t understand MySQL. How much data volume can MySQL actually support? In fact, the upper limit of MySQL single table is mainly related to the maximum file size supported by the operating system.
What is the maximum MySQL table size that can be reached?
MySQL 3.22 limited the table size to 4GB. due to the use of the MyISAM storage engine in MySQL 3.23, the maximum table size increased to 65536TB (2567_1 bytes). Because of the larger table sizes allowed, the maximum effective table size for MySQL databases is usually determined by the operating system’s limitations on file sizes, rather than by internal MySQL limits.
The InnoDB storage engine keeps InnoDB tables in a tablespace that can be created from several files. This allows the table size to exceed the maximum capacity of the individual files. The tablespace can include raw disk partitions, making very large tables possible. The maximum size of a tablespace is 64 terabytes.
The fact that the amount of data MySQL can handle is largely related to the structure of the table and is not a fixed value. If the table structure is simple, the amount of data it can handle is relatively larger than if the structure is complex.
According to the results of the CMS system evaluation done by D.V.B team and Cmshelp team, MySQL can run well with a single table under about 20 million records (4G), and 50 million records (10G) after database optimization.
Summary:
Mysql: MySQL 3.22 limits table sizes to 4GB.
MyISAM storage engine: Maximum table size increased to 65536TB (2567_1 bytes). Because of the larger table sizes allowed, the maximum effective table size for MySQL databases is usually determined by the operating system’s limitations on file sizes, not by MySQL’s internal limitations.
InnoDB storage engine: The InnoDB storage engine keeps InnoDB tables in a tablespace that can be created from several files. This allows the table size to exceed the maximum capacity of the individual files. The tablespace can include raw disk partitions, making very large tables possible. The maximum size of a tablespace is 64 TB.
What exactly is the database capacity of SQLServer2000 (what is the capacity of the database)
Maximum (number or size)Object SQLServer7
0SQLServer2000 batch size65,536*network packet size165,536*network packet size1 Number of short string columns per Bytes 8,0008,000 bytes per text, ntext, or image column2 Maximum (number or size) Object SQLServer7
0SQLServer2000 batch size 65,536* network packet size 165,536* network packet size 1 bytes per short string column 8, 0008,000 Number of bytes per text, ntext, or image column2GB-22GB-2 Number of bytes per GROUPBY, ORDERBY8,060 Number of bytes in each index9009002 Number of bytes per foreign key900900 Number of bytes per primary key900900 Number of bytes per row8,0608,060 Storage Number of bytes in procedure source text Lesser of batch size or 250MB Lesser of batch size or 250MB Number of aggregated indexes per data table11 Number of columns in GROUPBY, ORDERBY limited only by the number of bytes Number of columns or number of expressions in the GROUPBYWITHCUBE or WITHROLLUP statement10 Number of columns per index 1616Number of columns per foreign key1616Number of columns per primary key1616Number of columns per base data table1,0241,024Number of columns per SELECT statement4,0964,096Number of columns per INSERT statement1,0241,024Number of connections per clientMaximum configured connectionsMaximum configured connectionsMaximum configured database size1,048 ,516TB31,048,516TB3Number of databases per SQLServer instance32,76732,767Number of file groups per database256256Number of files per database32,76732,767File size (data)32TB32TBFile size (logs)4TB32TBForeign key tables per data table References253253Length of identifiers (in characters)128128Number of instances per computer tentative16Length of strings containing SQL statements (batch size)65,536*Network packet size165,536*Network packet size1Number of locks per connectionMaximum number of locks per serverMaximum number of locks per serverMaximum number of locks per SQLServer instance Number of locks2,147,483,647(static)40% of SQLServer’s memory (dynamic)2,147,483,647(static)40% of SQLServer’s memory (dynamic)Number of nested stored procedure tiers3232Nested subqueries3232Number of nested trigger tiers3232Number of nonaggregated indexes per data table 249249Number of objects open at the same time in a SQLServer instance42,147,483,647 (or available memory)2,147,483,647 (or available memory)2,147,483,6474Number of objects per database2,147,483,64742,147,483,6474Number of parameters per stored procedure1,0241,024Number of parameters per Number of REFERENCES per data table253253 Number of rows per data table limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources limited by available storage resources4 Limited by the number of objects in the database4Number of UNIQUE indexes or constraints per data table249 unaggregated indexes and 1 aggregated index249 unaggregated indexes and 1 aggregated index1
The network packet size is the size of the Tabular Format Data Scheme (TDS) packet, which is used for communication between the application program and the relational database engine
The default packet size is the size of the TDS packet. p>The default packet size is 4 KB, which is controlled by the networkpacketsize configuration option
2
In SQL Server 2000, the maximum number of bytes for any key cannot exceed 900
Keys can be defined using variable-length columns, and as long as no rows with more than 900 bytes of data are inserted in such columns, the Its maximum size can be above 900
3
When using SQLServer 2000 DesktopEngine or Microsoft Data Engine (MSDE)1
0, the database size cannot exceed 2GB
4
Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, default values, and constraints
sql2005 database limit how much
1, SQL2005 database size limit: 524258G.
2, SQL2005 database data file size limit: 16000G.
3, the number of rows of each data table, subject to the above limit and the possibility of the actual storage file size.
PS: These parameters above, in most cases, we can not touch this limit. A 16T database file is intimidating, and the average SMB has storage arrays (hard disk cabinets) of this order of magnitude.
Other related parameters, you can Baidu search: “SQLServer2005 capacity specification”.