jeffr_tech ([info]jeffr_tech) wrote,
@ 2007-02-23 19:45:00
Previous Entry  Add to memories!  Tell a Friend  Next Entry
Exciting new data from the sysbench comparison.


So we got some exciting new data. I realized that we've been running with mysql 5.0.27 on my machine. I updated and re-ran the tests. I also ran with a 2.6.20.1 kernel on linux. The 'contention' refers to a bundle of contention reducing patches that are being tested for stability and inclusion in -CURRENT soon.

I would like to caution everyone against getting too excited before we finish verifying all of the results. I'm talking to some linux kernel guys now who are trying to reproduce this effect. Until then, I'm glad to see that with the same version of mysql we get the same throughput at peak. I have some scheduler changes in the queue that should address the slower ramp-up on freebsd as well.




Page 1 of 2
<<[1] [2] >>

(63 comments) - (Post a new comment)


[info]sniket
2007-02-24 02:37 pm UTC (link)
Jeff, is Transactions/Sec. = Requests/Sec.? I'm asking because in this benchmark [1] Linux drops off as well, even though not as severe as in your test.

[1] http://tweakers.net/reviews/649/9

Maybe rerun the whole thing with Postgres?

Anyway.. thank you for doing this, maybe the kernel guys can spot a bug in the kernel and fix it, which in the end will be good for everyone :)

(Reply to this) (Thread)

Its a usermode problem
(Anonymous)
2007-03-15 09:41 am UTC (link)
Please see here: http://ozlabs.org/~anton/linux/sysbench/

For the lazy: mainly a glibc malloc problem with threading. the last graph on the link looks very "scaly" to me.

(Reply to this) (Parent)

(no subject) - [info]jefferyflores, 2008-08-06 03:53 am UTC
(no subject) - [info]sterlingreves, 2008-08-10 11:15 pm UTC
(no subject) - [info]cameronsavoie, 2008-08-10 11:36 pm UTC
(no subject) - [info]hubertarnwine, 2008-08-11 04:50 pm UTC

[info]norguhtar
2007-02-24 04:16 pm UTC (link)
Strange. Check this graphs:
http://www.trinity.su/news/280.htm

Try set NOP as IO Schedulers. I'm think problem in IO.

(Reply to this) (Thread)


[info]jeffr_tech
2007-02-24 06:51 pm UTC (link)
This test doesn't do any IO at all. After the first run everything is faulted into memory and no tables are actually modified. This test was selected to help analyze bottlenecks in the operating system.

(Reply to this) (Parent)(Thread)

(no subject) - [info]norguhtar, 2007-02-24 07:19 pm UTC
(no subject) - (Anonymous), 2007-02-24 08:56 pm UTC
(no subject) - [info]norguhtar, 2007-02-25 07:17 am UTC
(no subject) - [info]johnscism, 2008-08-10 09:21 pm UTC
(no subject) - [info]frankcaudel, 2008-08-10 09:36 pm UTC
(no subject) - [info]alonsoivashche, 2008-08-11 12:34 am UTC
(no subject) - [info]daphnemundefor, 2008-08-11 01:28 am UTC
(no subject) - [info]seanrolle, 2008-08-11 01:10 am UTC
(no subject) - [info]sniket, 2007-02-24 07:41 pm UTC
(no subject) - [info]jeffr_tech, 2007-02-24 08:01 pm UTC
(no subject) - [info]sniket, 2007-02-24 08:24 pm UTC
(no subject) - [info]rashadmarciliu, 2008-08-06 03:46 am UTC

(Reply from suspended user)
(no subject) - [info]erniesorrelle, 2008-08-10 08:58 pm UTC
(no subject) - (Anonymous), 2007-02-25 05:27 pm UTC
(no subject) - [info]lesykedu, 2008-08-03 04:27 pm UTC
(no subject) - [info]newz_top, 2008-01-02 06:46 pm UTC
(no subject) - [info]nataliejenox, 2008-07-11 05:03 am UTC
(no subject) - [info]lissamacquille, 2008-08-10 11:25 pm UTC
(no subject) - [info]modestobennet, 2008-08-11 12:04 am UTC
(no subject) - [info]bartspores, 2008-08-11 12:54 am UTC
(no subject) - [info]isidroshaffir, 2008-08-11 01:37 am UTC
(no subject) - [info]sammyjurdon, 2008-08-12 11:59 am UTC

[info]lostinmind
2007-02-25 03:13 am UTC (link)
Looks awesome. Sorry about not helping with the schedgraph as I was super busy at work, but I got some time free so I'm looking in to that.

(Reply to this)


[info]_dyr
2007-02-25 08:18 am UTC (link)
Good job!

(Reply to this) (Thread)


[info]brforrbalsap
2009-03-12 04:59 pm UTC (link)
great article ang good work

step

(Reply to this) (Parent)

linux kernel config
(Anonymous)
2007-02-25 10:42 am UTC (link)
Could you post your linux kernel .config somewhere ?
You should also check that no debug feature are enabled.

(Reply to this) (Thread)


[info]gerrythurlo
2008-08-11 04:30 am UTC (link)
Also if you're trying to debug no ACPI support you can look at your kernel config output for the following; Code: cat /boot/ configfilename |grep -i ACPI Code: cat /boot/ configfilename |grep -i THERMAL You again are looking for entries that end with a "=m" and not a "is not set" Good Luck.

(Reply to this) (Parent)


[info]iskatel
2007-02-25 12:20 pm UTC (link)
Can you test mysql 5.0.33(34) on RHEL4 with all updates or on RHEL5 beta2 ?

(Reply to this) (Thread)


[info]katyakusmick
2008-08-11 02:32 am UTC (link)
5 Patch Status: Future Patch P4 Change #: Description   Platforms Version OS Browser ZCO ZCB Zimbra Mobile Network - RHEL 5 - RHEL 5 bit) - RHEL 4 - RHEL 4 bit) - Ubuntu 6.

(Reply to this) (Parent)

(Reply from suspended user)
Please test FreeBSD 6.2
(Anonymous)
2007-02-25 10:49 pm UTC (link)
Can you test FreeBSD 6.2-RELEASE???
To compare the diffrence beetwen 6.2 and 7.0-CURRENT...

Please... :)

(Reply to this)

Response times ?
(Anonymous)
2007-02-25 10:53 pm UTC (link)
Hi !

interesting results, as I've already encountered corner cases with linux 2.6 scheduler, notably antivirus processes freezing for several seconds. It would be interesting to note transaction times. I would bet that they will be really unequal on 2.6. Could you test the same on plain 2.4 (not RHEL nor any O(1) scheduler) ? It will probably be below 2.6 in terms of performance, but the difference in the shape and response times may provide some tuning hints.

(Reply to this)


[info]diegocg
2007-02-26 12:06 am UTC (link)
Apparently a kernel hacker has been able to reproduce the problem - http://lkml.org/lkml/2007/2/25/191

(Reply to this)

Glibc problems?
(Anonymous)
2007-03-12 10:56 pm UTC (link)
http://ozlabs.org/~anton/linux/sysbench/

(Reply to this) (Thread)

Re: Glibc problems?
[info]mesut12
2009-07-18 07:16 am UTC (link)
Good on your

Lida
Lida
Lida

(Reply to this) (Parent)

solved (glibc problem)
(Anonymous)
2007-03-13 08:37 am UTC (link)
http://ozlabs.org/~anton/linux/sysbench/

(Reply to this)

Problem found and meta solved
(Anonymous)
2007-03-14 10:36 am UTC (link)
http://ozlabs.org/~anton/linux/sysbench/

(Reply to this)


[info]sjmurdoch
2007-03-15 10:28 am UTC (link)
It appears to be a glibc malloc() problem, as switching to the Google malloc fixes the problem.

(Reply to this) (Thread)


(Anonymous)
2007-03-29 04:22 pm UTC (link)
Very cool, so glibc is the problem. Has GNU been made aware of this issue? Is there a way to track this issue and see if GNU will restructure the malloc code to handle multiple threads better?

(Reply to this) (Parent)


[info]masmedia
2007-04-02 11:28 am UTC (link)
words so I'll just say nice find.

(Reply to this)


[info]7wrc
2007-05-02 03:55 am UTC (link)
Good job.

(Reply to this)


[info]selenation
2007-05-07 11:41 pm UTC (link)
Thanks for the useful information, keep up the good work.

(Reply to this)


[info]amandaqixy
2007-06-01 04:31 pm UTC (link)
Actually great stuff!

(Reply to this)


[info]ttrtt
2007-09-02 01:51 pm UTC (link)
delete

(Reply to this)

(Reply from suspended user)
thanks
[info]oyunlar
2007-12-29 12:35 am UTC (link)
God job thanks
kadın hastalıkları

(Reply to this)


[info]dianagaqej
2008-06-25 03:01 pm UTC (link)
well done!

(Reply to this)

Hey
[info]oyunindir
2008-06-28 07:17 pm UTC (link)
words so I'll just say nice find.

oyun indir

(Reply to this)


[info]freegames99
2008-09-27 07:52 am UTC (link)
Well done

(Reply to this)


[info]sence1
2009-03-12 03:44 am UTC (link)
Koxp, Koxp 1726 Koxp

(Reply to this) (Thread)


[info]nuochoa
2009-10-16 07:33 am UTC (link)
yea ! what ??????///
------------
nuoc hoa | Nuoc hoa nam | Nuoc hoa nu

(Reply to this) (Parent)

(Reply from suspended user)

(63 comments) - (Post a new comment)

Page 1 of 2
<<[1] [2] >>

Create an Account
Forgot your login or password?
Login w/ OpenID
English • Español • Deutsch • Русский…