On 22 Feb 2008, at 17:51, Matt.Ingenthron at Sun.COM wrote: > Martin MC Brown wrote: >> Hi, >> >>>>> This is predicated on having data on which to base this decision >>>>> though. >>>>> >>>> >>>> >>>> If somebody wants me to do any necessary tests with the various >>>> MySQL versions and SPARC/intel combinations with 32bit/64bit let >>>> me know. >>>> >>> Yes, if you have any chance of doing that, it would be great! >> >> >> OK, here are the headline results for x86. Tests were doing using >> MySQL 5.0.56 (which I happen to be smoke testing at the moment), on >> the same machine, running snv_81. > > Thanks! Quite useful. > > Could you share any details on the build. Which compiler did you > use, any optimization flags, etc.? It would be useful to have that > info.
For i386: > COMP_CALL_INFO="CC='cc' CFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none - > nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=generic' CXX='CC > ' CXXFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin= > %all -features=no%except -xlibmil -xlibmopt -xtarget=generic' LDFLAGS > ='' ASFLAGS=''" > COMP_RUN_INFO="CC='cc' CFLAGS=' -DDBUG_OFF -xO3 -mt -fsimple=1 - > ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt - > xtarget=generi > c -DBIG_TABLES -DHAVE_RWLOCK_T' CXX='CC' CXXFLAGS=' -DDBUG_OFF - > xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -features=n > o%except -xlibmil -xlibmopt -xtarget=generic -DBIG_TABLES - > DHAVE_RWLOCK_T' LDFLAGS=' ' ASFLAGS=''" For x86_64: > COMP_CALL_INFO="CC='ccache gcc' CFLAGS='-m64 -O2 -mtune=k8 - > DMY_ATOMIC_MODE_RWLOCKS' CXX='ccache gcc' CXXFLAGS='-m64 -O2 - > mtune=k8 -D > MY_ATOMIC_MODE_RWLOCKS' LDFLAGS='-m64 -O2 -mtune=k8 -static- > libgcc' ASFLAGS=''" > COMP_RUN_INFO="CC='ccache gcc' CFLAGS=' -DDBUG_OFF -m64 -O2 - > mtune=k8 -DMY_ATOMIC_MODE_RWLOCKS -DHAVE_RWLOCK_T' CXX='ccache > gcc' CX > XFLAGS=' -DDBUG_OFF -m64 -O2 -mtune=k8 -DMY_ATOMIC_MODE_RWLOCKS - > fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T' LD > FLAGS='-m64 -O2 -mtune=k8 -static-libgcc ' ASFLAGS=''" I'll do similar Studio12 builds over the weekend and re-run as well. MC -- Martin 'MC' Brown, mc at mcslp.com Everything MCslp: http://planet.mcslp.com
