To Upgrade Server, Question About Dual-core Servers And Best Config For Mysql
Jun 2, 2008
I'm running a message board and it looks like I've outgrown the low end xeon 3040 1.86GHz dual core server, and the bulk of the CPU load is going to mysqld. I'm debating between offloading the DB to a dedicated server vs upgrading the existing server and hosting the web server and db on the same machine.
Any thoughts on the better approach? fwiw, the load from apache seems next to nothing right now, but I am also planning on adding an SMTP server for user registrations and general support email.
I'm also not super familiar with dual-core and dual processor machines. Does shifting mysql to a dual core or dual proc machine help (vs a single core/single proc machine)? since there is just one mysql daemon, does having a second core or proc. buy me anything?
View 10 Replies
ADVERTISEMENT
Apr 2, 2007
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.
View 7 Replies
View Related
Jan 23, 2008
Which one you suggest for running database server and VPS's?
Dual Xeon3ghz 1mb dual core vs Quadcore 6600 2.4ghzx4 core 8mb.
View 4 Replies
View Related
Mar 17, 2008
we've currently got a 2 server setup, apache+mysql
Mysql server is a Xeon 3.2Ghz with 2Gb ram, scsi 73gb raid1 disks
Server has been running a while, steadily increasing in traffic. whilst 90% of the time it's running ok (load around 0.5 - 1.0, cpu around 25-50% busy mainly mysql, disk i/o around 3% busy) during heavy traffic times everything slows right down
At the moment the mysql box is only running mysql so we've allocated about 1.5gb out of the 2gb to mysql.
At present, when we get busy the apache server is queing up requests as it waits for the mysql server. Query log shows most queries are <1sec, any other's are being optimised but due to the nature of our website there are a few pesky queries (only occasionally being slow though).
question is, can this config be tuned any more or is it time for an upgrade - mainly ram to add more innodb buffers?
Here's the result of tuning-primer.sh
Code:
SLOW QUERIES
The slow query log is enabled.
Current long_query_time = 2 sec.
You have 9 out of 159346 that take longer than 2 sec. to complete
Your long_query_time seems to be fine
BINARY UPDATE LOG
The binary update log is enabled
The expire_logs_days is not set.
The mysqld will retain the entire binary log until RESET MASTER or PURGE MASTER LOGS commands are run manually
Setting expire_log_days will allow you to remove old binary logs automatically
See http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html
WORKER THREADS
Current thread_cache_size = 384
Current threads_cached = 15
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 150
Current threads_connected = 4
Historic max_used_connections = 18
The number of used connections is 12% of the configured maximum.
Your max_connections variable seems to be fine.
MEMORY USAGE
Max Memory Ever Allocated : 1 G
Configured Max Per-thread Buffers : 5 G
Configured Max Global Buffers : 803 M
Configured Max Memory Limit : 6 G
Physical Memory : 1.99 G
Max memory limit exceeds 90% of physical memory
KEY BUFFER
Current MyISAM index space = 82 K
Current key_buffer_size = 5 M
Key cache miss rate is 1 : 1862
Key buffer fill ratio = 100.00 %
Your key_buffer_size seems to be fine
QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size
SORT OPERATIONS
Current sort_buffer_size = 16 M
Current read_rnd_buffer_size = 7 M
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 4.00 M
You have had 0 queries where a join could not use an index properly
Your joins seem to be using indexes properly
join_buffer_size >= 4 M
This is not advised
OPEN FILES LIMIT
Current open_files_limit = 11095 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 5467 tables
You have a total of 732 tables
You have 155 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current max_heap_table_size = 255 M
Current tmp_table_size = 256 M
Of 21109 temp tables, 35% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Note! BLOB and TEXT columns are not allow in memory tables.
If you are using these columns raising these values might not impact your
ratio of on disk temp tables.
TABLE SCANS
Current read_buffer_size = 7 M
Current table scan ratio = 929 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 117
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
Server is mainly Innodb due to previous row-locking issues.
View 4 Replies
View Related
Apr 26, 2009
What's a better choice DUAL XEON 2.8GHZ 533FSB w/HT or Pentium D 925 3.0 Dual Core?
View 11 Replies
View Related
Nov 7, 2007
I am going to buy a new server and I am unsure of which route to take.
Basically the cost is identical for a Dell server with:
1 AMD Operton Dual Core 2.4Ghz
OR
2 AMD Operton Dual Core 2.0Ghz
What is the felling? Does the 4 cores out weight the extra 400 mhz per processor, but only having 2 cores?
The server will be running:
Windows 2003 Standard x32
Plesk 8.2
IIS 6.0 [ Application Pools Setup ]
MySQL
Microsft SQL Express 2005 [ONLY CAN USE 1 CPU/CORE]
MailEnable
Can my applications even handle/utilize four cores?
View 6 Replies
View Related
Apr 22, 2008
Shall I chose the xeon quad core 2.4 GHZ or the dual core 2.66 GHZ for an adserver's database?
View 3 Replies
View Related
Nov 27, 2007
Which is the better performer?
(1x) Quad Core Intel Xeon X3220 2.40GHz 2x4M Cache
OR
(2x) Dual Core AMD Opteron 2216 2.4GHz 2X1MB Cache 1Ghz HyperTransport
This is for a web/application server running, Windows 2003 Server Professional, IIS, MySQL, MSSQL 2005 Express, Plesk 8.5. The price is about the same.
View 14 Replies
View Related
Feb 20, 2007
I want to colo dual xeon 3ghz/ 2 x 250 sata drive and Dual core 3.0 / 2 x250 Sata drive.
How much amp these server need? One colo company said 4amp for dual and 2 for dual core. Do I need 6amp for 2 servers? Rack comes with 15amp so I need half rack?
View 8 Replies
View Related
Feb 3, 2008
quad core processor vs Intel Xeon 3060 Dual Core Conroe Processor which is better any why?
View 2 Replies
View Related
Oct 30, 2008
can someone give a comparison betwen this two
Intel Quad Core Xeon X3210 vs Dual-Core 3040 Xeon
View 7 Replies
View Related
Mar 8, 2008
I have a server running Fedora 4 and WHM/cPanel. I would like to upgrade the linux kernel to the latest version, so mosey in via SSH and type "yum -y upgrade". It downloads a few things and tells me everything is hunky dory.
Now, the version it says it is currently running is: 2.6.17-1.2142_FC4 #1 Tue Jul 11 22:41:14 EDT 2006
Is that the really the newest version available? Maybe I'm confused as to how this works, but if I go to kernel.org it tells me the most recent stable version of the kernel is 2.6.24.3. Is this because I am running FC4?
View 7 Replies
View Related
May 4, 2009
different opinions on dual cpus and dual core.
But say: I have 2 servers, one with a dual CPU and another one with a single CPU but dual core. The CPUs have all the same specification (bus speed, cache, frequency, etc). Which one would perform better for web hosting (php, mysql)?
View 13 Replies
View Related
Mar 19, 2008
AMD Dual Core X2 4000+ vs Pentium IV 3.0
which processor better?
View 3 Replies
View Related
Mar 31, 2009
where is currently the "best" places to rent a dual core atom with about 2gb of ram, storage requirements are very low sub 50gb.
I am interested in getting two of these in total in different dcs (US/EU only).
Also something which I feel would be interesting is getting one up with a SSD. Has any one come across any where offering this?
There seems to be alot of variation on prices directly in the atom niche, and then we you compare it to the same companies offering on their bigger brothers (quad core xyz) it makes things much more confusing.
I have no interest in cheaper 5 year old hardware which might compare speed wise
View 14 Replies
View Related
Oct 7, 2008
Plesk shows my CPU details as below
CPU - INTEL Pentium III (Katmai) EM64T Family 6 Model 23 Stepping 6 ~1995MHz
VPS provider promised Dual core Xeon CPU. Is above CPU a Dual core Xeon?
View 13 Replies
View Related
May 21, 2007
How would processor performace compare assuming the harddrives were the same and the amount of ram was the same? For example, how would a system with older dual xeon 2.4 or 2.8 cpus compare to Intel Core2 Duo E4300 socket 775, 2x 1.8Ghz/1M L2 system?
I am guessing that the Intel Core2 Duo would win, but by how much? I am sure this is hard to compare since ram speeds are different as well, but hopefully someone can make an estimate.
View 12 Replies
View Related
May 29, 2008
Which one is better?
Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz goes with 2GB RAM
and
Dual Opteron 246 2.0 Ghz goes with 4GB RAM
I use this server for a little big forum with about 16,000 member, 300 members + visitors online everytime and 2 more sites (small sites).
One more question, Is 10Mbps switch port or 100Mbps switch port affected to speed?
View 8 Replies
View Related
Feb 17, 2008
There are a lot of changes in the naming convention Duo Core Quad Core, Core2Dual, Core2Quad. I wonder for Dual Core Xeon 3Ghz (which we called previously) would would be its equivalent or better now than is easily found on the market?
View 0 Replies
View Related
Jun 4, 2007
I'm trying to install CentOS 4.4 in dual core 2 box without success, can't even finish installation. Read about a bug closed because it doesn't happen in CentOS 5, thus leaving me no option but to use unstable cPanel 11. Does anyone have any clue about this? Seems strange that there's no workaround.
View 2 Replies
View Related
May 16, 2009
I just got an Atom 330 and it shows that i have 4 Cores. Is it normal?
cat /proc/cpuinfo | grep Atom
model name : Intel(R) Atom(TM) CPU 330 @ 1.60GHz
model name : Intel(R) Atom(TM) CPU 330 @ 1.60GHz
model name : Intel(R) Atom(TM) CPU 330 @ 1.60GHz
model name : Intel(R) Atom(TM) CPU 330 @ 1.60GHz
View 10 Replies
View Related
Jun 24, 2008
Does the single physical processor Core 2 Duo beat the Dual (physical) CPU AMD Opteron 244 in general?
I am curious as I don't see many people offering them anymore, and someone told me that the Core 2 Duos are actually faster than the 2 CPU Opteron I am talking about.
View 11 Replies
View Related
Nov 22, 2007
Which CPU is better 2 physical CPU of 2.8ghz Xeon vs Single CPU of quad core 6600.
Quad core got more FSB and L2 Cache and less power.
View 13 Replies
View Related
Aug 18, 2008
Does anyone have an opinion on the Intel Dual Xeon Quad Core Clovertown versus the AMD Dual Core Dual Opteron? I'm assuming the Xeon is better. I recently put in an order for one, and I'm hoping I made the right decision (Yes I know it would have made more sense to ask before ordering but that's not how I roll) .
View 8 Replies
View Related
Nov 23, 2007
Trying to determine how much better, if any, the Dual Opteron 265 would be over the Quad 6600... this is for a dedicated server.
Also... would it be worth $20 per month more for a Dual Opteron 2212?
View 3 Replies
View Related
May 12, 2008
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....
View 7 Replies
View Related
May 6, 2009
Would you provide some quick considerations, if Intel Q9400 Quad Core would be "better" than Dual Xeon 2.80GHz/Hyperthreaded at the same price?
well, I know xeon is an old one, but does it worth bothering to change from Xeon to that Q9400?
View 5 Replies
View Related
Sep 7, 2007
What's better? I guess for a forum that has 200+ people on throughout the day. Both would have 2gb of ram.
View 1 Replies
View Related
Apr 15, 2009
How much do you think the lowest price I can get for these specs?
Dual Processor Quad Core Xeon E5405 - 2.00GHz (Harpertown)
12Gig ram
100Mbit line with 5,000GB+ Bandwidth
250GB hdd
Just wondering because I'm looking around and its hard to spot a good deal these days.
View 11 Replies
View Related
Mar 23, 2008
Can 260w PSU handle this cpu?
[url]
and the the motherboard 4 or 8 GB of RAM plus two SATA HD?
View 8 Replies
View Related
Dec 9, 2007
Which one is better: Dual Xeon 2.8GHz/HT vs Dual Core Xeon 2.4GHz (3060) for shared hosting with database intensive? Both with 4GB RAM.
View 3 Replies
View Related
