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

Floss Valley Blog: Developing AJAX Application using Smarty and Xajax

Jonathan Street's Blog: Plugins for php frameworks

Joshua Eichorn's Blog: HTML_AJAX Wordpress Plugin Tutorial

DevShed: Using Directory Iterators and MySQL with Adapter Objects with PHP

ThinkPHP Blog: Oracle with PHP and PDO


Community Events

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


podcast language framework voicesoftheelephpant xdebug library series laravel5 example community extension opinion introduction php7 unittest release interview install laravel api

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