Jereymy,
Thanks a lot for your explanation on "Repair with key cache", I was reading
the online help, but could not get a clear picture of what was going on. So
I gess allocating as much memory as posible to the key buffer will improve
the performance of this stage?
Thanks
Ramon
-O
Wednesday, May 01, 2002 12:55 PM
To: 'Ramon Arias'; [EMAIL PROTECTED]
Subject: RE: mysqlimpor and fixed length files.
[snip]
The way that I have been doing it so far is by coverting the source data
into tab delimited format with a 'C' utility that I wrote and then loading
it u
Brian!
Using mysqlimport with no delimiters worked fine.
Thanks a lot...
Ramon
-Original Message-
From: Brian Ivins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:36 PM
To: 'Ramon Arias '; '[EMAIL PROTECTED]'
Subject: RE: mysqlimpor and fixed
tep that I am
trying to avoid requires a few hours of waiting an about 50 Gigs of extra
disk space. Any suggestions?
Ramon
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 9:54 AM
To: 'Ramon Arias'; [EMAIL PROTECTED]
Subject: RE:
Jay
I need to break it up into fields
Ramon
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 9:26 AM
To: 'Ramon Arias'; [EMAIL PROTECTED]
Subject: RE: mysqlimpor and fixed length files.
[snip]
Is there a way to import data
Hello there!
Is there a way to import data that is in fixed length format into MySQL?
Ramon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
I am running a pretty big database in MySQL, about 120 million records.
Indexes are very important for the performance of the database. Every time I
alter the tables to add indexes I takes about 3 hours of processing time. I
was wondering what would be a good rule of thumb for optimizing the serve
