Is this Dedicated Server good enough to Run MySQL on Linux Ubuntu?

Question

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

score 3 · Accepted Answer · answered May 01 '12 at 16:26

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.

score 2 · Answer 2 · edited Apr 13 '17 at 12:42

2

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.

edited Apr 13 '17 at 12:42

Community

1

answered May 01 '12 at 16:53

RolandoMySQLDBA

185,223
33
326
536

Is this Dedicated Server good enough to Run MySQL on Linux Ubuntu?

2 Answers2