Hi,
I'm using the latest open solaris as my desktop, and the other developers here
are using the latest ubuntu.. we have have a sql statement in our application
that is taking 19 seconds to complete on the ubuntu machines but 30 seconds on
my solaris machine.. I am trying to find out why there is such a difference...
They are both running 64 bit with mysql 5.1.30
ie bin/mysql Ver 14.14 Distrib 5.1.30, for pc-solaris2.10 (x86_64) using
readline 5.1
My output for truss while the sql is executing is here..
root at elmo:/opt/mysql/mysql# truss -c -p 7771
^C
syscall seconds calls errors
read .023 921 1
write .128 9521
open .000 18
close .000 20
unlink .003 12
time .000 77
lseek .017 8071
getpid .000 10
fcntl .000 1
lwp_park .000 1
lwp_unpark .000 1
lstat .000 10 2
readlink .000 14 14
priocntlsys .000 1 1
mmap .000 1
munmap .003 1
memcntl .000 1
pread .673 123806
pwrite .966 126334
pollsys .000 66
resolvepath .000 8 4
-------- ------ ----
sys totals: 1.819 268895 22
usr time: 27.564
elapsed: 33.480
Does anyone have any ideas, or where I should look..
The my.cnf files are pretty much identical, I have visually checked over the
output for show variables and they are configured the same..
Also, for what the query is doing 19 seconds is very good, I'm not complaining
about the time to execute the query.. I just do not what to concede to the fact
that ubuntu is performing better then solaris...
Jason
--
This message posted from opensolaris.org
