Re: system requirements for MySQL db requiring large selects

2005-01-25 Thread why me
Thanks for your reply Brent. It was really useful. Looks like Opteron would be a good choice since there wont be several multiple queries at the same time but instead we will be happy if the single query runs fast. You had mentioned adding more RAM would help, how much RAM would be ideal ? Does

Re: system requirements for MySQL db requiring large selects

2005-01-24 Thread Brent Baisley
Tough question since a lot of performance is dependent on how you structure your queries, your database design and indexing. But, going with what you provided... You have big tables, so you will want lots of RAM. That means a 64bit system like Opteron, Itanium or PowerPC based (ok and Xeon).

system requirements for MySQL db requiring large selects

2005-01-23 Thread why me
We are looking for buying a new server for running MySQL database. The database is around 50-70G and individual tables run to 5 - 15 GB. There wont be any frequent updates instead we need maximum select performance. There will be multiple table joins to perform our query. I hope your experience

need info. on system requirements of MySQL

2003-07-10 Thread Sasi Bhushan C - CTD, Chennai.
Hi Sir, I need minimum system requirements for installing MySQL server. This is for service definition. Please provide me the info/link from where I can get the info. Thanks, Bhushan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

System requirements for MySQL?

2001-03-15 Thread Chris Peterson
I cant seem to find system requirements anywhere for MySQL, even inside the hundreds of pages of the manual... I wish to run the latest stable release on MySQL on a Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional 4.5 server. Where could I find recommended

Re: System requirements for MySQL?

2001-03-15 Thread Charles L Hagen
Cold Fusion 4.5 Server is a hog. If you can run that you probably have enough memory for MySQL. I would not run them simultaneously with less than 384 MB ram. Charles Hagen On Thu, 15 Mar 2001, Chris Peterson wrote: I cant seem to find system requirements anywhere for MySQL, even inside