Dedicated MySQL Server

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
socket1
Forum Commoner
Posts: 82
Joined: Mon Dec 08, 2008 7:40 pm
Location: Shokan, New York

Dedicated MySQL Server

Post by socket1 »

How much traffic (Queries an hour) would the possibility of a dedicated MySQL server benefit. If the apache / php server is just a single core processor (3ghz) and has about 2gb of ram and then a dedicated MySQL server has a 2.5ghz processor with 2gb of ram. The dedicated server would be connected through a 100baseT switch full-duplex. What difference would this make in the speed of queries?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Dedicated MySQL Server

Post by califdon »

Maybe none. Results would depend on the size of the database(s), the kind of queries (select, insert, update, complexity of joins), how many simultaneous users, just for starters. It's pretty hard to even guess about these things. Usually the best you can do is start small and test to see whether you have a performance problem or not. If you do, then you can start to analyze what is causing the problem and only then decide what solution is appropriate.
Post Reply