Forum Moderators: open
1: AMD 64 - AMD Athlon64 3000
512MB DDR400 SDRAM
120GB SATA HDD
2: XR - Pentium IV 2.4GHz
512MB DDR400 SDRAM
80GB IDE HDD*
*Hard drive space is not important for me, because I just need 10 Gig space,
which one is better?
Furthermore, IDE disks for servers are hardly sold nowadays. So your second option is probably not a new server, but a server of a few years old with a higher chance to crash in the coming years.
How are the drives partitioned? Proper partitioning to separate program and dataspace and a cluster size matching your database datablock size also improves performance.
Which OS/distribution is running on these servers? Are they well maintained or do you need to upgrade every six months?
What types of systemboards are in it? Genuine Intel or another A-brand, or some B-brand that has the same specs on paper but a lower reliability?
You see, more questions than answers but chosing the right server for a specific application is much more than just naming a processor, RAM size/speed and disk size.
Most of hits are in static pages (html and php that don't use DB) , but I also have a message board system (run with Minibb) and a very simple dynamic image gallery this two use DB,
when the online users on my message board increase my website became terribly slow,(I don't have bandwidth problem, my server has a 100mbs switch) and I think if I move my DB to another machine it help the main server performance, Am I right?
so with my web hosting company plans and my bodget, I can select one of those server that I mention in the first post.
I don't know anything about advantage or disadvantage of AMD or Intel, and even don't sure that moving the DB to one of those servers help me or not,
You probably have more need for RAM on a database server than on a web server, so it makes no sense to have 1/2 the RAM on your database server as you have on your web server. You could actually DECREASE performance!
sometimes, my website return 504 error, when there are too many connection at the same time
and I'm so confuse that which one is better:
1- increasing RAM in the main server,
2- having Mysql server in a seperate machine,
3- get a more powerfull cpu for my server!
sometimes, my website return 504 error, when there are too many connection at the same time
That's a strange one. 504 is a "gateway timeout". You should only get this error if your web server is acting as a proxy or gateway to another system. Do you have your web site (or part of your website) set-up as a proxy?
It means that the proxy server timed-out waiting for the system that it is proxying.
Of course, there's nothing preventing some software you have installed on your server from inappropriately returning this status code for some other kind of error.
Errors related to "too many connections" may be as simple a fix as changing your server configuration to allow more connections!
Most web servers do NOT "tune" themselves automatically to the capabilities of your hardware. It is up to YOU, as webmaster, to determine appropriate settings for various limits, and change the configuration files accordingly.
You need to find out exactly what resources (if any) are being stressed, instead of trying to guess at what might improve the situation.
No, I just have a simple website! a board (with minibb), an image gallery(it's with a simple php script) and
some static pages!
my hosting tech support told me lots of connection in the same time can crash the apache! I set the online client to unlimited, but it does not fix the problem, I even disable creation of logs file to decrease resource usage!
after then I change mysql configuration, it didn't help too!
the tech support told me if you have your DB in another machine the problem may solve!
Most web servers do NOT "tune" themselves automatically to the capabilities of your hardware. It is up to YOU, as webmaster, to determine appropriate settings for various limits, and change the configuration files accordingly.
if you know some professional guy for tuning up my server or knowing any book or manual to doing this please pm me, or tell me here, I'll appreciate it.
You would get a 504 error from the proxy server if your site were very slow at answering requests.
I'm not a big PHP user, but I am guessing that PHP might give a 504 error if it does not get a response from MySQL. Can PHP users comment?
The hosting company could use a reverse proxy server setup for security, performance or multiplexing reasons.
If the connection between your php and mysql server takes too long, the front-end proxy might decide that the hosting server is not reachable and return the 504.
