Use Dtrace to monitor your queries.

Developing MySQL on Solaris requires you to install a suitable compiler and other tools, but you may be surprised to know that most of the material is there already, or easy to install if it's not. But even more so, there is a huge wealth of information that you can get about your application while it's running, both with and without using more traditional debugging methods. We'll cover setting up a suitable environment, where to find the things you need, and and how to make use of the process monitoring tools and debugging environment to get the best out of development on Solaris generally, and MySQL specifically.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!

Developing MySQL on Solaris requires you to install a suitable compiler and other tools, but you may be surprised to know that most of the material is there already, or easy to install if it's not. But even more so, there is a huge wealth of information that you can get about your application while it's running, both with and without using more traditional debugging methods. We'll cover setting up a suitable environment, where to find the things you need, and and how to make use of the process monitoring tools and debugging environment to get the best out of development on Solaris generally, and MySQL specifically.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Using DTrace with MySQL - current state, future prospects, and lots of examples

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!

DTrace is breakthrough tool for on-demand tracing and analysis of any software. As MySQL internals are open, it is possible to extract incredibly valuable information about database work - without performance overhead or even need to restart a server. This talk covers and merges knowledge and practice from both DTrace and MySQL worlds - and explains why D in DTrace means 'dynamic'.

This session will give an overview of the new set of static DTrace probes introduced in MySQL 6.0 with examples on how to use them in real-life monitoring and performance tuning tasks.

Query analysis can help highlight issues in the SQL in your application, but there are many ways of getting that information. Obvious choices are explain and the slow-query log, but newer solutions, such as live query monitoring, mysql proxy and DTrace provide additional benefits.

This session will introduce DTrace, OpenSolaris's Dynamic Trace Facility, which can be used to give unprecedented access to the inner workings of MySQL. We will explore specific MySQL DTrace probes and the DTrace pid provider, which allows the gathering of information about any function within a process.