RE: special characters messing me up

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: >http://www.

RE: special characters messing me up

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)}'

RE: Should I switch to SCSI HD for mysql?

Hodgkinson [mailto:[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 "

RE: Should I switch to SCSI HD for mysql?

heap table. 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? &

RE: Should I switch to SCSI HD for mysql?

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. Mys

Should I switch to SCSI HD for mysql?

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] ---

RE: Possible to load only index MYI file into RAM?

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 status;"

Possible to load only index MYI file into RAM?

Hi all, Would be real grateful for some help on speeding up selects on a large table (20+ million rows). My question is: Is it possible to load just the index MYI file into RAM and if this is possible, will this improve performance on selects? Thank you for any help. Michael Thomas -

RE: Sizing HEAP table using .MYD/MYI

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: d

Sizing HEAP table using .MYD/MYI

Hi all I have a large table (20 million records) that I want to load into RAM to improve selects. I understand (from previous posts) that I must create a HEAP table. Please correct me if I'm wrong on this. My question is - how much RAM do I need if the MYI and MYD files are as follows :- 214M Ja

RE: examples of large mysql databases

Brett, Regarding large tables in mysql, I am using tables with 20 million rows+ and it works just fine. The tables only have two columns. The first is varchar[50] and the second column an int type. Regarding speed of access to the data, selects like "select field1 from table1 where field1='abcd'