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@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
Edited 2 time(s). Last edit at 01/28/2009 06:05PM by Jason Bradfield.