Brett,
I am using mysql to log RADIUS accounting for a big ISP.
The accounting table has 10 fields of different types with one index on an
aggregate of 3 fields. The record is fixed length.
Mysql is reasonably fast and handles tables until you reach the 2 GB file
size limit where it fails (this is my OS limit).
The nicest features (alas it is not perfect yet) are MERGE table and
compressed tables. My MERGE table has more than 75 millions records and
still fast.
> -----Original Message-----
> From: Brett Paden [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 19, 2001 6:13 PM
> To: [EMAIL PROTECTED]
> Subject: examples of large mysql databases
>
>
> I have been using mysql for many years and have failry reliable
> web-based applications using tables with 3 million+ records.
>
> I am curious as to other people's experiences with larger amounts of
> data, like 5 to 50 million record tables (I am assuming each record
> has dozens of columns of various datatypes). We are looking into
> switching to Oracle simply to handle the size of our data, but are
> wondering what other people's experiences have been. We are very
> happy with the functionality and flexibility of mysql, and don't need
> RDBMS features like transaction management, triggers, or stored
> proceedures.
>
> I am new to the list, so if there are existing threads on this topic I
> should be reading, please let me know what subject headings I should
> search on.
>
> Thanks!
>
>
> --
> Brett Paden
> [EMAIL PROTECTED]
> http://www.trimeros.com
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
