[ale] MySQL and Redhat 7.2 with ext3

Jim jcphil at mindspring.com
Tue Sep 3 11:48:40 EDT 2002


I asked because the optimization tasks are different, depending on your 
objective. In this case, you need to look closely at indexing. But people on 
the MySQL mailing list report running databases with a million rows without 
problems. So, MySQL is certainly up to the task of holding large amounts of 
information. 

On Tuesday 03 September 2002 11:40 am, John Cole wrote:
> Howdy!
>
> I'll be dumping large quantities of data every day (actually, every second
> but each day it's about 90-130MB total).
>
> I'll also be doing searches from this database for analyzing the data.
>
> The tables are populated with several fields (the largest field has 250
> characters worth of data at most)
>
> (perhaps I should have stated,   How do I ensure that MySQL will accept
> that much data without dieing)
>
> Thanks,
> John
>
> -----Original Message-----
> From: Jim [mailto:jcphil at mindspring.com]
> Sent: Tuesday, September 03, 2002 11:28 AM
> To: John Cole; 'ale at ale.org'
> Subject: Re: [ale] MySQL and Redhat 7.2 with ext3
>
> On Tuesday 03 September 2002 11:27 am, John Cole wrote:
> > Howdy all!
> >
> > I'm trying to create a rather large database.
> > I'm using MySQL and Redhat 7.2 with ext3 for my file system.
> >
> > How do I ensure that ext3 will handle large files?  Also, how do I ensure
> > that MySQL will accept them?
> >
> > (I'll be dumping ~90-130MB everyday to it.)
>
> What are you asking about in relation to MySQL? Do you want tables to
> contain
> very large files? Or are you just expecting the overall database to be very
> large?
>
> ---
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should
> be
>
> sent to listmaster at ale dot org.
> Disclaimer: The information contained in this email is proprietary and
> confidential.  It is intended solely for the use of the person identified
> and intended as the recipient. This document is forwarded to you in such a
> form (E-mail) that LGEFCU cannot guarantee the completeness and/or
> correctness of its contents and information. If you have received this
> E-mail message in error, please notify us immediately. Please also delete
> this document from your computer. This document may not be reproduced,
> copied, distributed, published, modified, or furnished to third parties,
> without the prior written consent of LGEFCU. LGEFCU specifically disclaims
> any responsibility or liability for any personal information or opinions of
> the author expressed in this email.


---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.






More information about the Ale mailing list