[Fwd: Limits to what ACID can handle?]

[Vitaly Osipov <vosipov () wolfegroup ie>]

Hi ppl,

this was on Focus-ids list regarding ACID - is it true that mysql is not
able to handle big databases? (>1mln records)

regards,
Vitaly
> --- Begin Message ---
>
>
> From: "Kohlenberg, Toby" <toby.kohlenberg () intel com>
>
> Date: Fri, 8 Jun 2001 12:11:53 -0700 
>
> Has anyone run into limits in mysql and/or ACID? I loaded
> a network dump that had ~880k alerts+packet dumps last night
> into a Win2k mysql+ACID install. It was doing okay up through
> 100k-200k entries then I went away and when I came back I
> failed to get any response at all. I'm curious if I'm doing something
> else wrong or if I've just run into a limitation of the packages.
>
> Thanks,
> Toby
> (all opinions are my own and in no way reflect the views of my employer)
>
>
> --- End Message ---
> --- Begin Message ---
>
>
> From: Greg Shipley <gshipley () neohapsis com>
>
> Date: Mon, 11 Jun 2001 01:17:58 -0500 (CDT)
>
>
> I've heard ramblings from *cough* Marty *cough* *cough* people saying that
> mySQL doesn't hold up as well as some other DBs past 1 million records.
> I'm no RDBMS guru, but this wouldn't surprise me.  In fairness to mySQL,
> I'm not sure how many mySQL deployments have pushed the one million mark.
>
> Us security folks are always pushing/breaking things.... :)
>
> Can anyone with a real DB background confirm this?
>
> -Greg
>
>
>
> --- End Message ---