OptiBiz1
Active Member
Maybe this is of interest to some people. I know I asked this maybe a year ago.
I imported a list with a 700000 subscribers to see how much space was needed. The list that I imported, a generated list with our own domain only (7 characters + .com), looked like this:
<snip>
FNAME,LNAME,GENDER,COUNTRY,SHIRTCOLOR,AGE,EMAIL
Ronnie,Hancock,Male,USA,Purple,21,frailgrandeur43@<my-domain>.com
</snip>
I then checked at some intervals to see how much space was needed. I waited for the database commit to be finalized before I checked the sizes. The tables that I checked were the following and took the start sizes of them:
mw_list_subscriber.ibd
mw_list_field_value.ibd
I seem not to be able to form a table here so I do it like this instead:
Col 1: size of mw_list_subscriber.ibd
Col 2: size of mw_list_field_value.ibd
Col 3: number of imported subscribers
Col 4: increase of the subscriber db size (mw_list_subscriber.ibd)
Col 5: increase of the custom field db size (mw_list_field_value.ibd)
Col 6: Col 4 + Col 5
Col1 | Col2 | Col3 | Col4 | Col5 | Col6
------------------+-------------------+--------------+---------+----------+--------
201326592 | 541065216 | 530000 | 379 | 1003 | 1382
213909504 | 566231040 | 560000 | 381 | 994 | 1375
255852544 | 692060160 | 700000 | 365 | 975 | 1340
So it looks like for this list, with the specified custom fields, each subscriber took roughly 1350-1380 bytes.
The one answering my question last year, @VVT, told me his lists took roughly 1500 bytes per subscriber. I don't know how his list looked like.
I imported a list with a 700000 subscribers to see how much space was needed. The list that I imported, a generated list with our own domain only (7 characters + .com), looked like this:
<snip>
FNAME,LNAME,GENDER,COUNTRY,SHIRTCOLOR,AGE,EMAIL
Ronnie,Hancock,Male,USA,Purple,21,frailgrandeur43@<my-domain>.com
</snip>
I then checked at some intervals to see how much space was needed. I waited for the database commit to be finalized before I checked the sizes. The tables that I checked were the following and took the start sizes of them:
mw_list_subscriber.ibd
mw_list_field_value.ibd
I seem not to be able to form a table here so I do it like this instead:
Col 1: size of mw_list_subscriber.ibd
Col 2: size of mw_list_field_value.ibd
Col 3: number of imported subscribers
Col 4: increase of the subscriber db size (mw_list_subscriber.ibd)
Col 5: increase of the custom field db size (mw_list_field_value.ibd)
Col 6: Col 4 + Col 5
Col1 | Col2 | Col3 | Col4 | Col5 | Col6
------------------+-------------------+--------------+---------+----------+--------
201326592 | 541065216 | 530000 | 379 | 1003 | 1382
213909504 | 566231040 | 560000 | 381 | 994 | 1375
255852544 | 692060160 | 700000 | 365 | 975 | 1340
So it looks like for this list, with the specified custom fields, each subscriber took roughly 1350-1380 bytes.
The one answering my question last year, @VVT, told me his lists took roughly 1500 bytes per subscriber. I don't know how his list looked like.
Last edited: