News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Johannes Schlüter's Blog:
MySQL Query Analyzer and PHP
September 30, 2011 @ 12:56:54

Johannes Schlüter has a new post to his blog today mentioning the beta release of the mysqlnd_ms plugin (previously mentioned by Ulf Wendel and a new feature that can be plugged into the MySQL Enterprise Monitor to make the Query Analyzer directly use PHP instead.

When running a PHP-based application with MySQL it is often quite interesting to see what actually happens on the database sever. Besides monitoring of the system load etc. it is often interesting to see what queries are actually executed and which of them are expensive. A part of MySQL Enterprise Monitor is the MySQL Query Analyzer which helps answering these questions.

This was handled via a proxy that sat between the database and app server and ran through the queries looking for improvements. This new plugin keeps it closer to PHP itself without having to hit against the proxy. You can see the result in these two screenshots from inside the Manager application. You also have the side benefit of getting a stack trace of it running through the app to help you identify the spots most needing improvement in the code too.

0 comments voice your opinion now!
mysql query analyze mysqlndms plugin enterprise monitor


blog comments powered by Disqus

Similar Posts

Stefan Mischook's Blog: Cannot load mysql extension error - Video Tutorial How To

Ryan Malesevich's Blog: iTunes Stats for Macintosh with PHP & MySQL Part 1

Thilanka Kaushalya's Blog: How to use Mysql Transactions with PHP

Doug Brown's Blog: Zend_Cache is Saving me Money!

Ibuildings blog: Wow, this is so cool! (Guide to Enterprise PHP Development)


Community Events





Don't see your event here?
Let us know!


list podcast community laravel series voicesoftheelephpant tips library symfony framework api interview language introduction developer deployment release zendserver bugfix conference

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework