Skip to: categories | main content

Symfony 2 and mysqlnd

MySQL PHP

In a previous blog posting I was mentioning that I'm working on a small hobby PHP project. As I'm using this project to update myself to current frameworks I've decided to use Symfony2. Symfony provides a nice feature, which is the Symfony Profilier, an extensive logging and reporting system for Symfony2 developers to understand what's going on. A part of it is the Doctrine query logger which lists all database queries executed by Doctrine and their execution time.

This is nice but when we're using mysqlnd in our PHP build we have more information available. "So why not use that information," I thought and built a new bundle for Symfony2 doing exactly that. The JSMysqlndBundle will take all the 150 or so statistic values collected, so they can be seen in the profiler (click screenshot for a larger view).

As this is the initial value, a quick Sunday morning hack, it has not all features I can imagine. Things one could do include

Any takers? - Code away!
Posted by Johannes Schlüter in MySQL, PHP Comments: (6) Trackbacks: (2)
Defined tags for this entry: , , ,
Related entries by tags:
< MySQL Query Analyzer and PHP | mysqlnd_qc and Symfony2 >

Trackbacks
Trackback specific URI for this entry

mysqlnd_qc and Symfony2
Previously I was writing about combining Symfony2 and mysqlnd to get more statistics on what is going on below the surface in the database communication when using a Symfony2 application via the Symfony2 profiler. Now that's not all that can be done and I
Weblog: Johannes Schlüter
Tracked: Oct 07, 22:53
Making use of PHP mysqlnd statistics
One of the great things of mysqlnd as a base library for PHP's MySQL support are the collected statistics. mysqlnd collects about 160 different statistical values about all the things going on. When having such an amount of raw data it, obviously, is quit
Weblog: Johannes Schlüter
Tracked: Apr 02, 18:10

Comments
Display comments as (Linear | Threaded)

Grayson said,

Sunday, October 2. 2011 at 20:34 (Link) (Reply)

This rocks. Do you know if there is a way to use mysqlnd with Doctrine 2? If so, how do you configure the two together? Thanks.
Johannes said,

Sunday, October 2. 2011 at 21:45 (Link) (Reply)

mysqlnd is deep in the PHP stack, Doctrine won't directly notice it. Doctrine is built on top of PDO. PDO then uses the PDO_mysql driver and this driver can use either libmysql or mysqlnd. mysqlnd is the default on Windows and some Linux distributions. See phpinfo() -> pdo_mysql -> "Client API", which either mentions libmysql or mysqlnd.

See also http://php.net/mysqlnd especially the chapter http://php.net/mysqlnd.overview

(mind that this bundle also requires that the mysqli extension is available, you don't have to use it, but it has to be there)
Gordon Franke said,

Monday, October 3. 2011 at 19:53 (Link) (Reply)

Cool. I have build some similar tool MySQLndUhTool for debug php applications see https://github.com/gimler/MySQLndUhTool/
Johannes said,

Monday, October 3. 2011 at 20:56 (Link) (Reply)

Cool!
Lenny said,

Wednesday, October 5. 2011 at 16:13 (Reply)

Is there a simple way to get these statistics using PDO? The manual only talks about functions for mysqli . For example :mysqli_get_client_stats()
Johannes Schlüter said,

Friday, October 7. 2011 at 22:58 (Reply)

mysqli_get_client_stats() will contain statitics for stuff executed via PDO_mysql, too. Actually the naming is bad and it should be mysqlnd_client_stats() or similar. Maybe we will fix that in a later version of PHP. So yes you need mysqli, but it works for PDO, too.

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA


To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA