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

fasttrap

fasttrap(7D)							      Devices							      fasttrap(7D)

NAME

       fasttrap - DTrace user instruction tracing provider

DESCRIPTION

       The  fasttrap  driver  is a DTrace dynamic tracing provider that performs dynamic instrumentation of arbitrary instructions in Solaris pro-
       cesses. The fasttrap driver implements the DTrace fasttrap and pid providers.

       The fasttrap 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
       fasttrap provider.

SPARC ONLY

       The fasttrap provider provides a DTrace probe that fires each time a user process executes an instruction. The pid provider allows for  the
       dynamic	creation  of  DTrace  probes  corresponding  to  instruction locations inside any user process specified using a process ID and an
       instruction address or symbol name. Together these providers permit DTrace users to perform instrumentation of Solaris user  processes  and
       to  trace  the  interactions  between  processes  and the operating system. See the chapter entitled "User Process Tracing"  in the Solaris
       Dynamic Tracing Guide for information on how to use these providers to instrument processes.

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							      fasttrap(7D)

Solaris BigAdmin RSS