jaymc Posted September 10, 2008 Share Posted September 10, 2008 I want to colo a server which will be dedicated to mysql as I have a lot of traffic for sql I was going to go all out and spend £1000+ on a quad core, 12GB ram etc My question is, should I be more concerned about memory than CPU power? the reason I ask this is I have a dual opteron 242 (2x CPU single core), good disks. I could use this and just buy 12GB of memory Do I really need the CPU power? Will not having mega CPU's cause me to hit bottle knecks or is mysql basicaly 80% all in the memory Cheers Quote Link to comment Share on other sites More sharing options...
Mchl Posted September 10, 2008 Share Posted September 10, 2008 I think fast disks, preferably in array will have most influence. Then CPU and then RAM. That's just from what knowledge I got on internet. I never configured a server for MySQL myself, so I'll also be glad to read some advice. Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 10, 2008 Author Share Posted September 10, 2008 You rate CPU before RAM? Seriously.. Can anyone else advise on this.. Quote Link to comment Share on other sites More sharing options...
Mchl Posted September 10, 2008 Share Posted September 10, 2008 Told you am no expert on this Quote Link to comment Share on other sites More sharing options...
NoDoze Posted September 10, 2008 Share Posted September 10, 2008 I've built many servers and my understanding is that MySQL uses a lot of RAM.... So ever since I was told that I've always made sure there was more RAM than average. Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 11, 2008 Author Share Posted September 11, 2008 But do I need powerful as hell CPU's or will 2 basic opterons do the trick, with 12GB of ram and some nice DISKS Quote Link to comment Share on other sites More sharing options...
corbin Posted September 11, 2008 Share Posted September 11, 2008 DBs can get CPU intensive, especially if there are poorly written queries causing lots of sorting or full table scans, but for the most part, I would imagine the CPU, as long as it's decent would be fine. I would probably balance CPU, RAM and the HDD, with slightly more emphasis on RAM/HDD. Which model of Opteron? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 12, 2008 Share Posted September 12, 2008 Yes, there's a huge difference between disk-bound vs. I/O bound... Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 12, 2008 Author Share Posted September 12, 2008 optedon 242, 2nd series. Think they are 1.8gz each eqiiv, so 3.6ghzof power Should suffice with nice disks and he'll of a lot of ram Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 16, 2008 Author Share Posted September 16, 2008 Change of plan, I know have a Dell PowerEdge 6600 which has 32GB of memory and 4x single core Xeon 2.5Ghz I want to virtualise this so I can split it into Virtual Severs using Vmware or Xen I need to know if I can get away with assiging the mysql virtual server 1 CPU,with 16GB of memory As I've stated above I know the more memory you can give mysql for key buffers etc the faster it will run as it will not need to touch disks as much, but does it still need a fair amount of CPU power, if so, how much? Is 2.5Ghz going to be enough or is there a good chance I will notice performance bottle knecks Cheers Quote Link to comment Share on other sites More sharing options...
corbin Posted September 17, 2008 Share Posted September 17, 2008 Just of curiosity, why do you need a dedicated MySQL serv? Do you have a ton of web sites, or do you have 1 that has a ton of SQL stuff? Anyway, I would think 2.5GHz would be fine unless you're doing anything that would require lots of CPU power. (Wow, that was the most useless advice I've ever given.) How many queries do you run per second? Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 17, 2008 Author Share Posted September 17, 2008 Its just one website which is mysql driven and I have plans to grow it by 500% so I need to plan for the future Building a platform with load balancing etc, but at the moment I just need to know how CPU intensive mysql is Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.