Hi!

I am using DTrace to look at contention issues in MySQL server, but for some
reason it does not match any plockstat probes...

The interesting parts are:

- I have a master-slave setup, and it managed to match the probes on the slave
  but not on the master.

- I tried restarting the servers, and suddenly it started to work, so why did it
  fail in the first place?

$ ps -fp`pgrep -d, mysqld`
     UID   PID  PPID   C    STIME TTY         TIME CMD
    mats  7006  7005   0 14:52:45 pts/2       0:02 /bzrroot/.../mysqld --defau
    mats  7008  7007   0 14:52:45 pts/2       0:02 /bzrroot/.../mysqld --defau

$ dtrace -l -Pplockstat7006
    ID   PROVIDER            MODULE                          FUNCTION NAME
dtrace: failed to match plockstat7006:::: No probe matches description

$ dtrace -l -Pplockstat7008 | head
   ID   PROVIDER        MODULE                    FUNCTION NAME
71336 plockstat7008     libc.so.1           pthread_spin_lock mutex-acquire
71337 plockstat7008     libc.so.1        pthread_spin_trylock mutex-acquire
71338 plockstat7008     libc.so.1                 lmutex_lock mutex-acquire
71339 plockstat7008     libc.so.1               mutex_trylock mutex-acquire
71340 plockstat7008     libc.so.1             mutex_lock_impl mutex-acquire
71341 plockstat7008     libc.so.1           fast_process_lock mutex-acquire
71342 plockstat7008     libc.so.1             mutex_recursion mutex-acquire
71343 plockstat7008     libc.so.1            mutex_lock_queue mutex-acquire
71344 plockstat7008     libc.so.1       mutex_trylock_process mutex-acquire

I'm running  OpenSolaris 2008.11 snv_101b_rc2 X86 on an AMD64.

Best wishes,
Mats Kindahl
-- 
Mats Kindahl
Lead Software Developer
Replication Team
MyS.. eh... Sun Microsystems, www.mysql.com
begin:vcard
fn:Mats Kindahl
n:Kindahl;Mats
org:Sun Microsystems
adr;quoted-printable:;;Tegv=C3=A4gen 3;Storvreta;SE;74334;Sweden
email;internet:[email protected]
title:Lead Replication Software Developer
x-mozilla-html:FALSE
version:2.1
end:vcard

_______________________________________________
dtrace-discuss mailing list
[email protected]

Reply via email to