Re: system requirements for MySQL db requiring large selects
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 the operating system and MySQL will be able to utilize all the RAM available? Regarding hard drives you mentioned SCSI drives in RAID set up, I was looking at 15000 rpm scsi drives (thats what the max rpm i could find), does these has to be in RAID 0 setup ? if so how many drives do you think would be good. Our data will not exceed 75 - 100 Gig. Thanks again Karthik --- Brent Baisley [EMAIL PROTECTED] wrote: 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). PowerPC would mean running Linux or AIX, OSX won't really take advantage of 64bit until 10.4. If your queries are going to be scanning big chunks of the tables, the data won't be cached, so you want very fast disks setup in a RAID. SCSI or Fibrechannel would be good. Are you going to be having lots of simultaneous queries or sequential big queries? Opteron will give you better throughput, but Xeon will be better at multitasking (i.e. simultaneous queries). Opteron has it's own memory controller, so if you have a lot of calculations you'll be doing in RAM, that would be an excellent chip because of it's bandwidth between CPU and RAM. If money is no object, a Power5 (PowerPC) based system can scale pretty high, going well beyond dual or quad processors in a single box. On Jan 23, 2005, at 12:12 PM, why me wrote: 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 will help us find a suitable server for our need. Information on what hardware to use including how many computers, processor, ram, hard drive spec would be helpful. Budget is not a constrain but performance (select) need to be high. I have heard MySQL is the best for fast and large selects, but is it worth looking at other database like Oracle? Thanks TM __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: system requirements for MySQL db requiring large selects
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). PowerPC would mean running Linux or AIX, OSX won't really take advantage of 64bit until 10.4. If your queries are going to be scanning big chunks of the tables, the data won't be cached, so you want very fast disks setup in a RAID. SCSI or Fibrechannel would be good. Are you going to be having lots of simultaneous queries or sequential big queries? Opteron will give you better throughput, but Xeon will be better at multitasking (i.e. simultaneous queries). Opteron has it's own memory controller, so if you have a lot of calculations you'll be doing in RAM, that would be an excellent chip because of it's bandwidth between CPU and RAM. If money is no object, a Power5 (PowerPC) based system can scale pretty high, going well beyond dual or quad processors in a single box. On Jan 23, 2005, at 12:12 PM, why me wrote: 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 will help us find a suitable server for our need. Information on what hardware to use including how many computers, processor, ram, hard drive spec would be helpful. Budget is not a constrain but performance (select) need to be high. I have heard MySQL is the best for fast and large selects, but is it worth looking at other database like Oracle? Thanks TM __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
system requirements for MySQL db requiring large selects
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 will help us find a suitable server for our need. Information on what hardware to use including how many computers, processor, ram, hard drive spec would be helpful. Budget is not a constrain but performance (select) need to be high. I have heard MySQL is the best for fast and large selects, but is it worth looking at other database like Oracle? Thanks TM __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need info. on system requirements of MySQL
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://lists.mysql.com/[EMAIL PROTECTED]
System requirements for MySQL?
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 or minimum requirements for this? Help! Thanks, Chris Peterson
Re: System requirements for MySQL?
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 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 or minimum requirements for this? Help! Thanks, Chris Peterson -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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