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 Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/ 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. Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-638477 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.. Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-638492 Share on other sites More sharing options...
Mchl Posted September 10, 2008 Share Posted September 10, 2008 Told you am no expert on this Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-638494 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. Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-638553 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 Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-639220 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? Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-639372 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... Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-639516 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 Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-639852 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 Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-643026 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? Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-643493 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 Link to comment https://forums.phpfreaks.com/topic/123637-solved-server-spec/#findComment-643644 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.