I know that the "what kind of server should I buy?" question comes up regularly here, but the various discussions in the archives don't seem to address my issue.
My current server is an old PII desktop with 64M memory and a 6GB hard drive, running FreeBSD. Thanks to the glories of FreeBSD and the speed of MySQL, and my relatively limited needs, this has been perfectly adequate up to now--I've never had any speed-related issues, the thing never crashes (I had a MySQL process running for about 320 days before someone accidentally unplugged the computer). On my busiest days I don't get more than a few hundred queries, and my current tables are all pretty simple. I'm about to start work on a considerably more complex project, and I'll need to get a new server for it. I have about 600M of XML that I want to convert to MySQL, and I will have to do the same thing on a roughly weekly basis--as the underlying data gets revised elsewhere I'll need to re-import the whole batch. When it's in the database, I'll then want to serve it on an intranet, do various statistical analyses, etc. The final format will involve at least six and possibly more tables, the largest being about 2 million rows; it will be heavily indexed. However, while I'll need the final queries to execute with reasonable speed, I still don't expect a particularly large amount of traffic. I want to stick with MyISAM tables, so I can use fulltext indexes (and heavy concurrent access won't be a major problem, so InnoDB shouldn't be necessary); I'm using 3.23.39 now and would probably upgrade to 4.0.X to take advantage of some of the newer features. I want to stick with FreeBSD. I'd be grateful for any advice on what my server needs might be, even if that advice is the familiar "bigger, faster, stronger". My main concern is that doing my weekly importation of the XML shouldn't take the entire week. Also, I haven't figured out exactly how I'm going to manage the conversion (e.g., through an object-relational model, or more directly); this project is bigger than anything I've worked on before and I'm trying to approach it with caution. Thanks. Jesse Sheidlower --------------------------------------------------------------------- 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