[ale] MySQL and Redhat 7.2 with ext3

[James P. Kinney III]

I'm almost positive that ext3 can handle 2GB files with no problem. With
some kernel tweaks, it can handle 2TB files. The issue is MySQL. It uses
multiple files, most of which will never exceed the 2GB size. The
headache is in blobs. There are limits on binary blob sizes in all
databases. MySQL can be set to handle some very large files (~500MB),
but the performance is supposed to drop like a rock in those situations.
Something about keeping an inode list for the blob file. 

Dumping 90-130MB/day into various tables should not be issue. Just make
sure you have a working, reliable backup system that the restore has
been tested and proven to work for database recovery. Recall the horrors
of file recovery from ext3 systems from earlier.

On Tue, 2002-09-03 at 11:27, 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.)
> 
> Thanks,
> John Cole, TCISA
> 
> Help Desk Administrator
> Lockheed Georgia Employees' Federal Credit Union
> 430 Commerce Park Drive
> Marietta, GA 30060 
> (770) 424-0060
> (800) 541-8921 
> jcole at lgefcu.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.
-- 
James P. Kinney III   \Changing the mobile computing world/
President and CEO      \          one Linux user         /
Local Net Solutions,LLC \           at a time.          /
770-493-8244             \.___________________________./

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7 



 This is a digitally signed message part