Page 1 of 1

Dedicated MySQL Server

Posted: Fri Apr 17, 2009 8:25 pm
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?

Re: Dedicated MySQL Server

Posted: Fri Apr 17, 2009 11:38 pm
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.