At boot time you can pass a flag to lilo to force
a certian amount of ram..
i think it's something like this:
lilo: linux mem=256
307,000 rows in mysql is easy, mysql can handle
a lot more rows than that.
You shouldn't have any trouble with this amount of data.
---------------------
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-----Original Message-----
From: Mike Mike [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 11:38 AM
To: [EMAIL PROTECTED]
Subject: Inserting 307,284 lines. Is this ok?
Hello
I was wondering if inserting 307,284 is to much to put
into one table. Can MySQL handle this? Its a 70MEG
File. I have a 550 with 256MEG ram but it only shows
64. I don't know how to make it show 256 and running
redhat 6.1. The table has 12 colums and does not have
much data in each record. My question is should I
break this up into a couple of tables so that each
table will have say 50,000 records and I can just
search through them with dates.
Thanks for any help.
--Mike
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php