How much data can handle MySQL?

I

itsme

New member
Hello,

I hope that someone speaks English here and can answer my question. I can understand German, so you can write in German.

I just purchased B1G Mail licence but still can not decide to use this script on my site or not.

I have a busy dating website with 30 000 registered users and ~200-600 users online all the time. I would like to offer free email with 10 MB mailbox to all users.

I decided to store data in MySQL because I don't want millions and millions of tiny files on my server if I store data in files.

My worries are about MySQL. If I have 30 000 users and each user has some 5000 messages in his/her mailbox:
30 000 x 5 000 = 150 000000

That's 150 million rows in one table!

Yes, yes, I know, not all users will have 50000 messages in their mailboxes, but the number of users increases about +2000/month.

I can't imaggine how long time will need MySQL to find messages for each user in the table with 150 000000 rows.

I don't know - maybe it's not a problem at all. I just never had such large tables and I don't know if it's possible at all.

Another problem: I have Fedora Core 2 installed and even don't know yet if it supports files larger than 2 GB.

Does anyone use B1G Mail with such a large amount of users?

Thank you.
 
Hi,

you should let b1gMail save the mails in files. Then, the MySQL table is used as an index to search mails very fast.
If you are saving mails in the table itself, it grows rapidly and MySQL will take very long time to search the table for a certain row.
 
You must log in or register to reply here.
Back
Top