Re: mysql performance on 4 * dualcore opteron
- From: Sven Petai <hadara@xxxxxx>
- Date: Wed, 5 Apr 2006 17:30:51 +0300
On Wednesday 05 April 2006 08:31, David Xu wrote:
Can you disable log-bin option in my.cnf to see if it is a FS bottleneck
when you are running update-smack ? please run Linux and FreeBSD
with same hardware and my.cnf configuration, thanks.
I know this is not very right, but it can be used to narrow down some
kernel performance problem.
I can't test disabling log-bin option right now since those 8 core systems
were shipped out to client today, but I will probably get access to some
identical servers next week, so I will then test this and whatever other
suggestions you people can come up with.
Until then can we maybe consentrate on
* why does 8 core machine get so awful select score without renicing mysqld
* why is select result on linux >65000 q/s while fbsd can do only about 21000
q/s
But the bencmark results that I stated for 8 core machines were done on 4
_identical_ servers, with following operating system installations:
server 1 - suse enterprise linux 9 with kernel 2.6.5-7.97-smp, mysql
4.0.18-32.1, reiserfs
server 2 - Fedora core with kernel 2.6.9-22-ELsmp, mysql 4.1.12, ext3
server 3 & server 4 - freebsd 6.1 beta 4,generic-smp kernel, mysql 4.1.12_2
from ports, ufs2 + softupdates, libthr
While it was not the very _same_ hardware, the machines were absolutelly
identical in every aspect and fbsd results on 2 servers were identical within
the limits of measurement error so it's rather unlikely that some hardware
glitch can be blamed for the differences.
The mysql configuration file was also identical - default my-huge.cnf with
max_connections change @
http://bsd.ee/~hadara/debug/mysql3/2way/my.cnf
Hardware spec of those servers was:
motherboard: Thunder K8QSD Pro
hdd: scsi seagate cheetah 10K7
ram: 8 * 3200 CL3 kingston ECC 1G
cpu: 4 * opteron 870 (2Ghz dualcore)
Results for other UP and dual machines that I mentioned were given just to
give some general feeling about scalability.
So just to state the 8 core results in a more concise manner:
smack suse fedora fbsd 6.1b4
-----------------------------------------------------
select 76857 67000 21000
update 10047 8072 4100
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"
- References:
- mysql performance on 4 * dualcore opteron
- From: Sven Petai
- Re: mysql performance on 4 * dualcore opteron
- From: David Xu
- mysql performance on 4 * dualcore opteron
- Prev by Date: Re: mysql performance on 4 * dualcore opteron
- Next by Date: Re: mysql performance on 4 * dualcore opteron
- Previous by thread: Re: mysql performance on 4 * dualcore opteron
- Next by thread: Re: mysql performance on 4 * dualcore opteron
- Index(es):
Relevant Pages
|
|
