Tag Archives: dtrace

stupid dtrace trick

Posted on 2009/03/15 by

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 ,

plockstat fail!

Posted on 2009/02/06 by

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 2008/12/16 by

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 2008/10/03 by

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