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]