Archiv für den Monat October, 2010

PHP: the 38 characters of the mysqlnd profiler

Thursday, October 28th, 2010

Recently I was forced to benchmark a mysqlnd plugin on Windows. X-Debug was no help. It worked flawless on Windows but it can’t tell you what goes on inside a PHP user space API call, for example, you will not know how much time mysqli_query() spends reading a result set. Very Sleepy is […]

Posted in PlanetMySQL (english), PHP (english), PlanetPHP (english) | 2 Comments (read more) »

PHP: 62 characters to see all MySQL queries

Thursday, October 14th, 2010

Did you ever want to see the database queries an arbitrary PHP MySQL application runs? It takes two free downloads and 62 characters to see them.

Get PHP 5.3.4-dev
Get PECL/mysqlnd_qc
Add 19 characters to your configure line: –enable-mysqlnd-qc
Add 43 characters at the end of applications source, e.g. using the auto_append_file configuration setting: var_dump(mysqlnd_qc_get_query_trace_log());
Start your query analysis

array(329) {
[…]

Posted in PlanetMySQL (english), PHP (english), PlanetPHP (english) | 3 Comments (read more) »

The mysqlnd query cache meets Oxid at the IPC 2010

Wednesday, October 13th, 2010

How amusing: an ancient write-up on the first PHP Kongress in 2000 edition written by one who later became a mentor of the autor of phpOpenTracker. How boring: a silver guy talking at the 10th aniversary of the conference about some 60% performace benefit for Oxid eShop, an example of a modern award-winning software, if […]

Posted in PlanetMySQL (english), PlanetPHP (english) | Comments Off