Try this,
The code below will remove the last character from
each record in your file. On your Linux system
enter this line on the command line and the
results will appear in the NEW_FILE. Obviously you
can name the input and output files anything you
want.
awk '{print substr($0, 1, length-1)}'
John
Here is another solution to removing those '^M'
chars. This is a lot simpler
than my last idea :-
sed 's/^M//g' YOUR_FILE YOUR_NEW_FILE
Michael Thomas
www.abcXyz.com
-
Before posting, please check:
lto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 1:32 AM
To: mike thomas
Cc: Greg Cope; Mysql@Lists. Mysql. Com
Subject: Re: Should I switch to SCSI HD for mysql?
"mike thomas" [EMAIL PROTECTED]
writes:
Greg,
Well, I'm doing like "%stuff%" selects on a
single column
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard drive would speed up selects and inserts?
Thanks everyone!
Michael Thomas
abcXyz.com
[EMAIL PROTECTED]
Jeremy,
My queries are disk bound (I think) from watching the Redhat
system monitor when running a query.
Mike
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 4:07 PM
To: mike thomas
Cc: Mysql@Lists. Mysql. Com; [EMAIL
e.
Thanks
Michael Thomas
-Original Message-
From: greg [mailto:greg]On Behalf Of Greg Cope
Sent: Wednesday, February 07, 2001 4:09 PM
To: mike thomas
Cc: Mysql@Lists. Mysql. Com; [EMAIL PROTECTED]
Subject: Re: Should I switch to SCSI HD for mysql?
mike thomas wrote:
Hi al
Thanks for the help Kent and the rest of the list,
Would be grateful for some help interpreting some mysql system
variables. Just to recap on what I am trying to achieve, I want
to load as much of a very large key file (224704512
mykeyfile.MYI) into RAM to improve selects.
I did a "show
Richard
Thanks for the info! I have just one more question. To get the structure of
the table I did a myisamchk and did a desc on the table. The output is shown
below. From this is it possible to determine the amount of RAM I would need
for a HEAP table?
Thanks!
MichaelT
MyISAM file: