Hello. What is the maximum number of rows in a MySql table? I have a very large list of numbers ~11GB that I would like to store, (they are in a text file now).
Also, I'm debating as storing these as char(25) or varchar(25), or if MySql has a 64 bit unsigned integer data type. Advice?
2006-11-02 07:31:51 · 6 answers · asked by EjayHire 2 in Computers & Internet ➔ Programming & Design
It's supposed to be unlimited. In real-world applications though I'd cap the max. number of addressable rows at 32 bit (4 billion rows). If you go over that you're either going to crash, or have some serious performance issues. 4 billion rows is only insufficient if you're trying to do something like catalog every man/woman/child on earth.
Use "BigInt unsigned" for storing 64 bit unsigned... Considering the size of your data set, this could save you considerable space (8 bytes per entry instead of a potential 21).
I know this exists in MySQL v 5.0, I don't know about other versions. Be ~careful~ when doing math with numbers of this size. Very often they'll get rounded.
More information about numeric data types in MySQL 5 can be found in my source link below.
2006-11-02 07:43:13 · answer #1 · answered by Dracolytch 2 · 0⤊ 0⤋
There is no max amount of rows that it can store, it is all dependant upon the memory you have allocated for your database. Are all your numbers 25 characters long, if so then using char(25) or varchar(25) will both work good, if the numbers vary, I would suggest just setting them with no limit. This will save you memory if you have several numbers that aren't the full 25.
From my experience I would just say to store them as varchars, you can look into what SQL has for internal data types, but I've never encountered anything like that. I hope this helps. Best Wishes :-)
2006-11-02 07:41:02 · answer #2 · answered by rachelle105210 5 · 0⤊ 0⤋
Your data should easily fit into one table in MySql.
While originally MySql was designed for small to medium-sized databases, today's version can easily cope with terabyte-sized databases. In other words, having a table with several million records is nothing that would get MySql sweating ;)
2006-11-02 07:40:01 · answer #3 · answered by Martin I 3 · 0⤊ 0⤋
circulate to gadgets/possibilities/edit/circulate determination after enter/ come to a sort upon appropriate come to a sort on column A and Column B enter your concepts, it is going to routinely to the main remarkable cellular successively eg a1, b1, a2, b2
2016-11-27 00:01:00 · answer #4 · answered by paula 4 · 0⤊ 0⤋
as many as you can fit... is this a trick question?
2006-11-02 08:11:04 · answer #5 · answered by cheeryeyeore 3 · 0⤊ 0⤋
as many as you can fit... is this a trick question?
2006-11-02 07:34:50 · answer #6 · answered by xerocs 5 · 0⤊ 0⤋