Quoting Divacky Roman <[EMAIL PROTECTED]> (from Fri, 6 Oct
2006 09:57:38 +0200):
On Wed, Oct 04, 2006 at 08:52:51PM -0400, Jerry Bell wrote:
I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram.
I've looked through some of the lists here and have seen super-smack
results in the 42k qps range on a 2 dual core opteron system. I'm able to
get up to about 34k with the wide at the back of my server whilest rubbing
the side of it.
Here's what I've done:
built both mysql 5.0 and 5.1 from ports with build_static and
optimazations on.
changed the clock to TSC
added the following to my /etc/libmap.conf file:
[mysqld]
libc_r.so.5 libthr.so.2
libc_r.so.6 libthr.so.2
libthr.so.2 libthr.so.2
libpthread.so.1 libthr.so.2
libpthread.so.2 libthr.so.2
And this is about the best result I get:
2950# super-smack -d mysql select-key-mysql.smack 10 10000
Query Barrel Report for client smacker1
connect: max=200ms min=0ms avg= 20ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 200000 0 0 34440.88
Are there any other optimizations I need to do to mysql or freebsd? I'm
still not 100% convinced that I've done everything I need to use libthr
instead of libpthread.
on UP people recomend to use TSC instead of acpi timer
He uses the TSC already... but nobody suggested the gettimeofday()
wrapper so far: http://wiki.freebsd.org/MySQL
Bye,
Alexander.
--
Success is the sole earthly judge of right and wrong.
-- Adolf Hitler, "Mein Kampf"
http://www.Leidinger.net Alexander @ Leidinger.net: PGP ID = B0063FE7
http://www.FreeBSD.org netchild @ FreeBSD.org : PGP ID = 72077137
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "[EMAIL PROTECTED]"