Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a web application that runs simple logic. Most of the SQL procedures that I have only do simple selects, some simple join table and some simple inserts. I want to get a dedicated server for My Database, I found one but I didn't get it yet. I want to get some of your opinion on this machine before paying for it. I know I can benchmark it but only after I own it. So any idea if this one is enough for 5000 users per day doing simple reads and simple insertion into MySQL with InnoDB Engine ?

  • Core i5 Quad Core i5-2400 3.10 GHz
  • 16 GB DDR3-1333 UDIMM
  • 250 GB SATA HDD (7200 RPM)
  • 100 Mbps Uplink Port Speed
  • Ubuntu 10.04 - 64 Bit
share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

It's hard to know / to figure out:

Even some simple reads, could be IO hungry. And the amount of users doesn't tell us how many request ( read / write).

Without more data, it hard to tell, but that seem to be a good server. I believe that it'll be good enough, but that's just a opinion.

share|improve this answer
add comment

Two things catch my attention

  • MEMORY
  • CPU

I have addressed these issue in past posts

Please follow suggestions centered around InnoDB as multiple core engagement is only available in MySQL 5.5's native InnoDB as well Percona's XtraDB.

share|improve this answer
    
Thanks a lot guys. I really appreciate your opinion. It meant a lot to me :) –  Alex May 1 '12 at 17:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.