On 10/15/08 10:40, Jyri Virkki wrote: > Sunanda Menon wrote: > >> Please Code Review minor changes for the bug 6758090 : mysql need to be >> compiled with -x04 and also for CR 6759537 >> <http://monaco.sfbay.sun.com/detail.jsp?cr=6759537> mysql_config --libs >> maps to 32 bit libs for 64-bit binary at >> >> http://cr.opensolaris.org/~sunandam/6758090/ >> > > Seems ok to me as far as the diff goes. > > In the bug 6759537 I'd like to see an Evaluation explaining what > happened and what is the fix and its impact. From the diff it seems > the fix_ldpath function must've been wrong since you're removing it, > but then I wonder why was it added in the first place and does > removing it have any consequence beyond fixing the immediate error? > Answer is probably simple enough but this is the kind of rationale > that is good to record in the CR Evaluation for future reference. > > Also while the -xO4 change is simple enough, have you validated the > performance difference? > Doing sysbench tests for OLTP transactions keeping number of threads as 2 gives positive results for -x04 that shows increased performance versus -x03 .Do we need some more benchmark tests to be done or is this justifiable?
OLTP test statistics: (using -x04 flag) queries performed: read: 2913694 write: 0 other: 416242 total: 3329936 transactions: 208121 (693.73 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 2913694 (9712.23 per sec.) other operations: 416242 (1387.46 per sec.) Test execution summary: total time: 300.0027s OLTP test statistics:(using -x03 flag) queries performed: read: 1835204 write: 0 other: 262172 total: 2097376 transactions: 131086 (436.95 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 1835204 (6117.27 per sec.) other operations: 262172 (873.90 per sec.) Test execution summary: total time: 300.0037s > (Remember to link the CRs to this code review discussion thread.) > > P.S. those monaco URLs are no good on this list since they are not > visible externally. > -- Sunanda Menon Database Technology Group BLR03, x87098/91-80-66937098 http://blogs.sun.com/smenon -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/webstack-discuss/attachments/20081016/f511fcc0/attachment.html>
