Tag Archives: dtrace

stupid dtrace trick

Posted on March 15, 2009 by Domas Mituzas

So, if there is no way to flush status variables of a server, one could use dtrace (and run SHOW GLOBAL STATUS ;-) #!/usr/sbin/dtrace -Fws int *zero; BEGIN { zero=alloca(4); *zero=0; } pid$target:mysqld:add_to_status*:1b { copyout(zero,uregs[R_ECX],4); copyout(zero,uregs[R_EDX],4); } P.S. This is … Continue reading →

Posted in mysql | Tagged | Comments Off

plockstat fail!

Posted on February 6, 2009 by Domas Mituzas

Solaris has this beautiful tool ‘plockstat’ that can report application lock contention and hold events (hold events turn into contention events at parallelism.. ;-) It is just a frontend to a set of dtrace rules, that monitor mutexes and rwlocks. … Continue reading →

Posted in mysql | Tagged , , | 3 Comments

Packing for MySQL Conference 2009

Posted on December 16, 2008 by Domas Mituzas

Yay, coming to Santa Clara again (4th conference in a row!:). I can’t imagine my year without MySQL Conference trip anymore. To get a free ticket I’ll present on two topics, MySQL Security (lately I have related role, and have … Continue reading →

Posted in mysql | Tagged , , | 2 Comments

dtrace!

Posted on October 3, 2008 by Domas Mituzas

At the MySQL developer conference I accidently showed up some of things we’ve been doing with dtrace (I used it in few cases and realized the power it has), and saw some jaws drop. Then I ended up doing small demos … Continue reading →

Posted in mysql | Tagged , , , | 3 Comments