Check that your file size limit on your machine is more than the
usual 4GB. I have a 23 million row database, and it translates
into 3GB data file, 3GB index file. 1 billion records would never
fit. My record length is about 300 bytes.
If you need more than a 4GB data file, you should check o
Interesting subject ;-)
Can you provide some more information; Like exactly what failed, any
errors you received, if it crashed, how big the database files got
before the failure happened etc.
Magyari Istvan wrote:
>
>
> Hi,
>
> I have been trying to build a 1 billion row database, in mysql
Hi,
An int datatype takes 4 bytes and a bigint 8 bytes. . Since there is an index
created with bigint it will take an additional 8 bytes for the data and
some more
bytes for the pointer to the table rows. Thus a bare minimum
of 20+ bytes is consumed corresponding to a row of data. A billion recor
Hi,
An int datatype takes 4 bytes and a bigint 8 bytes. . Since there is an index
created with bigint it will take an additional 8 bytes for the data and
some more
bytes for the pointer to the table rows. Thus a bare minimum
of 20+ bytes is consumed corresponding to a row of data. A billion recor
Check that your file size limit on your machine is more than the
usual 4GB. I have a 23 million row database, and it translates
into 3GB data file, 3GB index file. 1 billion records would never
fit. My record length is about 300 bytes.
If you need more than a 4GB data file, you should check o
Interesting subject ;-)
Can you provide some more information; Like exactly what failed, any
errors you received, if it crashed, how big the database files got
before the failure happened etc.
Magyari Istvan wrote:
>
>
> Hi,
>
> I have been trying to build a 1 billion row database, in mysql
