Mysql Thread_concurrency On A Single-Processor QuadCore
Feb 6, 2008setting up the MySql thread_concurrency variable on a Single-Processor Xeon 2.6ghz QuadCore .
Should it be 8 (num of cores * 2) ? or 4?
setting up the MySql thread_concurrency variable on a Single-Processor Xeon 2.6ghz QuadCore .
Should it be 8 (num of cores * 2) ? or 4?
I'm just about to buy a server for my Database.
My site does 230,000 unique visitors per day and I have MySQL and Httpd on the same server with 2gb ram and quad2core....
Which Is better and would give me better mysql Performance since mysql eats up huge amounts of CPU and RAM.
AMD 64Bit 3200 Or a Intel Core 2 Duo 1.86 GHz
I know theres many other factors involved but I need to know which processor would perform better with mysql.
quad core processor vs Intel Xeon 3060 Dual Core Conroe Processor which is better any why?
View 2 Replies View RelatedI'm running postfix 2.3.5 with my alias info being drawn from a mysql database.
What i'm trying to do is setup a partial catchall setup to forward all email that's addressed *@hah.cx to uber@spamcop.net. However, I want email addressed to mikey@hah.cx, and mike@hah.cx to be directed to my local "mikey" user email account.
what's the correct value for thread_concurrency in /etc/my.cnf if the processor is
Dual Processor Dual Core Opteron 270
is it 4 or 8?
I have a core2duo at SoftLayer. MySQL 4.1.20.
I tried to add thread_concurrency=4 to my.cnf. I restarted mysqld, but thread_concurrency doesn't show up in "show variables".
Also, is TOP supposed to show the loads in each core separately?
It's recommended to make thread_concurrency = Number of CPU's x 2. But this is really effective with latest mysql5 versions?
[url]
Default 10
Range 1-512
Why to set it to 8 (4 cpus), for example, if recommended default value is 10? And why to set such a low value if range is till 512?
Also, how to check assigned value as "show variables;" command omit this value.
If you have experience with large mysql databases please share your thoughts about a new MySQL server. If all other parameters are the same, what is better for a 6-10 GB MySQL db, dedicated server?
Dual XEON or Dual Opteron 2212 Dual Core Processor?
Also, any advice on suggested RAM, partitioning, OS, etc. are welcome. Current MySQL version used is 4.1.21.
What is the point of a high end quadcore cpu with 7200 rpm sata drives ?
i see tons of offers with really nice cpu's with either a single sata drive or 2 drives on crappy fake raid.
I have old dual single core xeon servers under 50% cpu usage that end up hitting the disk IO wall before they ever get to over 60% cpu usage.
Either me and my customers dont user software thats crap and eats up cpu for no reason or im missing something.
different speed between Quadcore Q6600 2.4Ghz and Xeon 3060 Dual core 2.4Ghz? Typically i can tell the Q6600 is faster than Xeon 3060 but i am not sure which one is faster and more stable for dedicated server.
View 5 Replies View RelatedSite is currently running on a single code single cpu p4 server. Am thinking of upgrading to a quad core Xeon server.
My site is pretty dynamic with lots of hits to php / mysql, and has trouble keeping up with the requests sometimes. Would a quadcore Xeon significantly help?
Server Software:
Windows 2003 Server
php 5.2.6
apache 2
mysql 4.1
Current Setup:
P4 2.8 single core/cpu.
Proposed setup
Xeon 3210 quadcore
I guess my confusion lies in the following:
1. Can win2003 server make use of the quadcores?
2. Does php / apache / mysql make use of the quadcores?
3. Will i see a significant increase in the amount of pages i can serve?
In Terms of server speed, reliability, load handling, mysql database handling and other aspects which is better processor with same RAM config..
Processor 1 : P4 3Ghz Dual Core
Processor 2 : Intel Celeron-L Conroe 1.6 Ghz
OR
Processor 3 :Celeron Dual Core E1200's
I have always used Intel processors. Maybe just out of habit but I always have.
AMD Dual-Core Opeteron 1216 2.40GHz
or
Intel Quad-Core Xeon 2.50GHz 2.66GHz
Both would have 4GB ram.
What is the actual performance differences between these two processors? The Intel is $80 more and just not sure if it really is worth it.
Hows everybody doing. I am hosting a small network of sites (between 5-10) on a dedicated server with HostGator. I have the Standard package which gives me 1024mb as far as RAM and a Dual-Core 3040 Xeon (Conroe) as a processor goes.
My sites run extremely slow on the front end and back end. The sites are blogs which you probably know are php heavy. Not to mention a few of the sites get a decent amount of traffic (Alexa rankings of around 50K). One of the less popular sites with not as much traffic is www(dot)abnormalstyle(dot)com ...You can see how slow this site loads, its on the same server as the other sites, just using a different IP account...
I am looking to upgrade my server. When i talked to HostGator support i got the answer i would expect. "Upgrade to the next package, which is more money".
I am wondering if i would advantage from just upgrading my ram, or going with a processor first. The thing is, if i want to get the next processor i have to defiantly go with the next HostGator package, due to the fact they cant just add a new processor. They can however add more Ram.
Below are some options, if you have the time feel free to leave your comments and pick one of the options below which you feel would best suit the network of Wordpress blog sites i am using.
---------------------------------------------------------
Option 1 - Just upgrade RAM. There is no sense in going from a Dual-Core 3040 Xeon (Conroe) processor to just a Quad-Core 3210 Xeon (Kentsfield) processor, regardless of the ram, it will not make a major difference. ITS ALL ABOUT RAM!
Option 2 - Go for the next HostGator package which offers 4096mb Ram wise and Quad-Core 3210 Xeon (Kentsfield) processor wise. The Processor upgrade along with the RAM upgrade will be MUCH BETTER then just the ram upgrade itself in option 1.
After reading a lot of good reviews on Softlayer around here, I was thinking about switching to them. They have some really good deals and I'm planning on getting one of their dual opterons, but I have a question about the processor speed in relation to database intense stuff (like a forum with a good number of users on at once, or a CMS).
I have the option of either going for a Dual Opteron 248 (2.2 gHz) or a 252 (2.6 gHz) which costs $50 more. My question: is the 252 really worth the extra money compared to the 248? All I have on my server is an IPB forum with 100-450+ users on at any given time, and a static site (soon to be converted to a CMS), and I'm thinking that RAM is more important than the processor for a database app like those (that, and hard drive speed). So I wanted to know if it would be better to go with the 248 and spend the money on more Ram and a SA SCSI 10k drive or two?
I have a production windows 2003 server with 2 XEON processors. In task manager I see 4 processors: 0,1,2,3. I assume this is because these processors have hyperthreading. My question is how do I know which 2 of the 4 are the main processors. I have a service I only want to run on processor 2, which 2 would I select to do this? I really don't want to be experimenting as this is a live production server.
View 2 Replies View RelatedI have a single Intel Xeon Processor and already found a same stepping code Xeon processor to upgrade.
I'm running CentOS 4.4. If I add the 2nd processor, do I need to configure anything on the system.
Anyone has an opinion about the following processor:
CPU Intel Xeon Quad Core 3210
Planning on getting a new dedicated server with 4GB RAM, and a 500GB 7.2k SATA2 Hard Drive.
Which processor do you guys suggest? I know the Q6600 is older and runs hotter, but it has better specs than the Q8200. Would I really notice a difference if I'm only hosting static sites without any video streaming or anything?
if im going to open a web hosting business, which processor works best for a server, AMD or Intel?
View 12 Replies View RelatedIntel Dual Quad Core Harpertown Or Core i7?
What would be better for a dedicated server?
while I'm surfing the net i find this site where it has a price list for the parts of a computer and i saw an Intel Xeon processor and it's priced is affordable to me.. Hmm.. My question now is it Ok to buy this processor? because some of my I.T. friends here tell me that it is for Server based processor only and it is not suitable for PC HOME USER..
View 2 Replies View RelatedThe the provider we're considering is offering a range of processors at different price points including:
single Xeon 5110 (dual core) with 2GB memory,
single Xeon X3220 (quad) 2GB,
dual Intel Xeon 5100 with 2GB,
dual Xenon 5310 (quads) with 4GB.
Does xen run better on a double processor server rather than an intel duo?
View 1 Replies View RelatedI have read benchmark comparisons and found the Q9400 and even the Q9300 to be a better performing processor compared to the Q6600 processor, even with 2MB less L2 cache.
I am just wondering, how significant of a difference do you think the Q6600 processor and the Q9400 processor is in a server environment? Currently I have a Q6600 processor but am looking to upgrade my server, possibly to the Q9400 processor..will it be worth it? It's not that much more expensive..the only thing I am concerned about is the 2mb L2 cache loss.
My site is "kind-of" high traffic. We receive a lot of connections and visitors, and most-importantly my sites are run by PHP and MySQL databases.
Please help me choose the right processor. Currently I have 4GB DDR2-800mhz installed, which I will be upgrading to 8GB DDR2-800mhz, no matter what processor I choose to run.
I discovered that upgrading to 1ghz RAM is just not worth the extra money because the performance gain is very little and not noticeable.
Would anyone possibly know of a Intel Quad Core processor that has 8mb or more of L2 cache, 1333mhz FSB, and is comparable to the processors listed above and relatively the same in price?
I have a dual processor server and today I was monitoring CPU usage using the ‘top’ command
There was a mysql process I was tweaking around with where the CPU % kept jumping over 100%.. It went up to 155%, 175%, 180% on numerous occasions.
My question is on a dual processor machine does ‘top’ measure CPU usage between 0% and 200% or does the usages I saw earlier mean my server was getting REALLY overloaded?
I cant decide between
Dual Processor Single Core
Dual Processor Single Core Xeon - 3.00GHz (Irwindale)
Or
Single Processor - Quad Core?
Single Processor Quad Core Xeon 3220 - 2.40GHz (Kentsfield)
My site needs "raw" processing power due to the applications it runs. ram (over 2 gb) and hdd are not that important to me.
could someone point me in the right direction.
One Webhost is offering MS SQL 2005 Standard Edition (Processor Licence) for US$385 per month.
Another webhost is offering MS SQL 2005 Standard Edition with 5 CALs for US$35 per month.
The first webhost says CALs are not available and that:
"A Processor License is required for running a Web server that is open to public access. Using CALs may put you in question from Microsoft's legal point of view if the inappropriate license is applied."
Only 3 people have access to the server and the website, I think, is very standard. www.culture360.org
Our org does not wish to do anything illegal. Which one is most appropriate? The price differences are very large.
I've had a look here:
[url]
i want take your opinion in this server, i want it to start small hosting services
AMD Sempron64 3000+
1GB RAM
I am trying to decide to run my heavy database community site over at a new host but am looking to create a good package customed for high bandwidth.
I can decide from going with ONE Dual Quad-Core 2.0 Processor(4 gigs of ram) or TWO Intel Xeon 3210 2.1 GHz Quad Core Processor servers(4 gigs of ram each) with a Virtual Rack Container.
With having both the lower servers on the virtual rack, will the site manage with the same power as the Dual Quad Core since it is on a rack?