Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing

4 More Discussions You Might Find Interesting

1. Debian

Optimizing exim performance

Hi, Recently, I experienced that exim was slow in sending outgoing mail, it was spending a lot of time in the queue, resulting in customer complains. I came across an article in the internet to optimize the performance of exim in the server. However, the location of the exim.conf is not in...

2. Web Development

Tracing a Slow MySQL Query

We have a few slow queries in forums. I am trying to track them down and see if I can fix them somehow. Here is an example from our mysql-slow.log: # Time: 090929 9:04:54 # User@Host: unixdb @ localhost # Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 75157 SELECT...

3. Filesystems, Disks and Memory

optimizing disk performance

I have some questions regarding disk perfomance, and what I can do to make it just a little (or much :)) more faster. From what I've heard the first partitions will be faster than the later ones because tracks at the outer edges of a hard drive platter simply moves faster. But I've also read in...

4. News, Links, Events and Announcements

Optimizing Apache Server Performance

I found this link useful in a discussion about Apache performance tuning: http://www.serverwatch.com/tutorials/article.php/3436911

LEARN ABOUT SUNOS

sdt

sdt(7D) 							      Devices								   sdt(7D)

NAME

       sdt - DTrace statically defined tracing provider

DESCRIPTION

       The  sdt  driver  is a DTrace dynamic tracing provider that performs dynamic instrumentation at statically-defined locations in the Solaris
       kernel.

       The sdt provider allows kernel developers to explicitly create probes at formally designated locations in the operating system  kernel  and
       loadable modules, allowing the implementor to consciously choose the points in their code that are desired probe points, and to convey some
       semantic knowledge about that point with the choice of probe name and a relevant set of arguments.

       The sdt driver is not a public interface and you access instrumentation offered by this provider  through  DTrace.  Refer  to  the  Solaris
       Dynamic Tracing Guide for a description of the public documented interfaces available for the DTrace facility and the probes offered by the
       sdt provider.

ATTRIBUTES

       See attributes(5) for a description of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWdtrp			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Private			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       dtrace(1M), attributes(5), dtrace(7D)

       Solaris Dynamic Tracing Guide

SunOS 5.10							    4 Sep 2003								   sdt(7D)

Solaris BigAdmin RSS