Re: database sizes. was Does a blank field take up disk space?

On 7/31/2016 7:10 PM, John Levine wrote:
>> And what are you doing that has "hundreds of millions of rows"? I have
>> yet to see anyone who is planning that to even get to hundreds of
>> thousands of rows.
>
> It's not a very good idea to make assertions about databases you know
> nothing about.
>

Over 30 years of experience with many RDB's and users gives me a bit of knowledge. And people who are asking questions like this never have a database anywhere near the size they claim.

> I use a mysql database on my 1U server to track the incoming mail and
> what I did with it. The table of incoming SMTP connections has 276
> million rows, and the table of recipient addresses has 416 million
> rows, each partitioned into three pieces.
>
> The table listing the spam complaints has 23 million rows, and of the
> recipients of the spam has 37 million rows.
>
> It's using stock mysql from the FreeBSD ports. The performance is adequate
> for what I'm doing, and it has no problem keeping up with all the incoming
> mail and logging it in real time.
>

And if you ever had to do anything serious with it, you'd find performance is terrible. But obviously all you're doing is using it for logging - which is low overhead.

You might as well just use a flat file.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================