homepage Welcome to WebmasterWorld Guest from 54.204.94.228
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
Forum Library, Charter, Moderator: open

Webmaster Hardware Forum

    
which one is better for a mysql server?
saeed

5+ Year Member



 
Msg#: 3316343 posted 12:23 am on Apr 20, 2007 (gmt 0)

I have to move my databases to another machine, and I have two option:

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?

 

lammert

WebmasterWorld Senior Member lammert us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3316343 posted 3:21 am on Apr 20, 2007 (gmt 0)

Without knowing your application and your database activity it is difficult to decide. But in general, more RAM will reduce disk access and speed things up with lower disk wear. So independent of your server choice, I would increase the RAM size because 512MB is low end.

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.

saeed

5+ Year Member



 
Msg#: 3316343 posted 7:21 am on Apr 20, 2007 (gmt 0)

Thanks lammert,
My main server specification is:
Intel CeleronD 2.8 GHz CPU, 1 GB DDR2-800 RAM, 250 GB SATA Hard Drive, the OS is FreeBSD 6.1-RELEASE-p11, and it run just one website with about 100K page views/day.

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,

jtara

WebmasterWorld Senior Member jtara us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3316343 posted 12:16 am on Apr 21, 2007 (gmt 0)

Of the two, I would go with the first (AMD). I would up the RAM.

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!

saeed

5+ Year Member



 
Msg#: 3316343 posted 12:05 am on Apr 24, 2007 (gmt 0)

jtara
I don't know much about server hardware, but I told that most of CPU and RAM usage in my website is on static pages,

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!

jtara

WebmasterWorld Senior Member jtara us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3316343 posted 12:30 am on Apr 24, 2007 (gmt 0)

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.

saeed

5+ Year Member



 
Msg#: 3316343 posted 3:48 am on Apr 24, 2007 (gmt 0)

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?

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.

jtara

WebmasterWorld Senior Member jtara us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3316343 posted 5:01 am on Apr 24, 2007 (gmt 0)

Do you use a proxy server at your ISP to access the web? (Unrelated specifically to your web site - check your browser settings?)

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?

saeed

5+ Year Member



 
Msg#: 3316343 posted 6:39 am on Apr 24, 2007 (gmt 0)

This error happen for all of my visitors! but this is not a php error, when the php failed to connect to mysql it give some other errors (like too many connection errors or connection failed etc..)

lammert

WebmasterWorld Senior Member lammert us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3316343 posted 11:54 am on Apr 24, 2007 (gmt 0)

The 504 is generated by a proxy server in between the visitor and your webserver. Could it be that your hosting provider has a front-end proxy server using reverse proxy to internal hosting servers? I have a reverse proxy setup to another server and it sometimes gives this error when there are problems reaching the site server.

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved