Dedicated MySQL Server
Moderator: General Moderators
Dedicated MySQL Server
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
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.