Sometimes you forget about what you did years ago, for example the ability of mysqlnd write back traces of slow queries into the PHP error log . Regardless if you use mysqlnd with ext/mysql, ext/mysqli or PDO_MYSQL, mysqlnd is able to tell you which of your code has executed a slow query. To enable the feature, you need to compile PHP with CFLAGS="-D A0". A0? Yeah, we must have had some doubts about the usefulness.

Slow queries

The MySQL server is capable of monitoring queries and recording slow queries in a slow query log. MySQL can log the following types of queries:

• SQL statements that took more than long_query_time seconds to execute
• SQL statement that required at least min_examined_row_limit rows to be examined (MySQL 5.1.21+)
• SQL statement …

The MySQL native driver for PHP (mysqlnd) is capable of collecting some 120 performance statistics. This is about twice as much as it was when I blogged about the 59 tuning screws for mysqlnd. While the basics have not not changed and the API calls for accessing the data remained the same (see previous posting) the new figures have never been described before.

The figures are for those of you who want to squeeze the last out of the PHP. Many of the statistics have been written for those who have developed mysqlnd and not for PHP users. The data is certainly still of interest for PHP experts but let me stress out again that it is for experts.

Scope

Statistics are either aggregated on on a per-connection or per-process basis. Changes to per-connection statistics also change the corresponding …

The MySQL native driver for PHP (mysqlnd) is capable of collecting some 120 performance statistics. This is about twice as much as it was when I blogged about the 59 tuning screws for mysqlnd. While the basics have not not changed and the API calls for accessing the data remained the same (see previous posting) the new figures have never been described before.

The figures are for those of you who want to squeeze the last out of the PHP. Many of the statistics have been written for those who have developed mysqlnd and not for PHP users. The data is certainly still of interest for PHP experts but let me stress out again that it is for experts.

Scope

Statistics are either aggregated on on a per-connection or per-process basis. Changes to per-connection statistics also change the corresponding …

Time left to the PHP 5.3 Release Party:

(JavaScript countdown - less than 48 hours…)

Time left to the PHP 5.3 Release Party:

(JavaScript countdown - less than 48 hours…)

We like to invite you to the PHP 5.3 release party which is an event to celebrate the 5.3 release, happening Friday, the 17th of July in Munich. The release party offers a chance to come together with other php enthusiasts and enjoy that php is alive and kicking. And of course people in favour of a decent barbecue, together with some beer and other drinks are invited.

The happening will take place at Waldwirtschaft beer garden, at any weather.
We will meet at 19:00 o’clock - open end.

The location is famous for its huge beer garden (2500 available seats, a children’s playground) and its typical Bavarian but also international food. On sunny weather you even may enjoy live-music and listen to the sounds of Jazz, Blues, Swing or Dixi.

Catering will be provided …

We like to invite you to the PHP 5.3 release party which is an event to celebrate the 5.3 release, happening Friday, the 17th of July in Munich. The release party offers a chance to come together with other php enthusiasts and enjoy that php is alive and kicking. And of course people in favour of a decent barbecue, together with some beer and other drinks are invited.

The happening will take place at Waldwirtschaft beer garden, at any weather.
We will meet at 19:00 o’clock - open end.

The location is famous for its huge beer garden (2500 available seats, a children’s playground) and its typical Bavarian but also international food. On sunny weather you even may enjoy live-music and listen to the sounds of Jazz, Blues, Swing or Dixi.

Catering will be provided …

It is getting summer in Germany: let’s have a PHP BBQ tour! The PHP BBQ tour is one week tour from Monday, 15.06. - Sunday, 21.06.2009 visiting the german PHP user groups. The tour will go through Munich, Frankfurt, Karlsruhe, Berlin, Dortmund, Hamburg and Kiel. The tour is an offering and a suggestion to the user group to come together for a barbecue instead of meeting in conference rooms in the middle of the summer, when the days are long. Everybody is invited to join me and other MySQLers on the tour to visit the PHP user group in his neighbor town.

It is getting summer in Germany: let’s have a PHP BBQ tour! The PHP BBQ tour is one week tour from Monday, 15.06. - Sunday, 21.06.2009 visiting the german PHP user groups. The tour will go through Munich, Frankfurt, Karlsruhe, Berlin, Dortmund, Hamburg and Kiel. The tour is an offering and a suggestion to the user group to come together for a barbecue instead of meeting in conference rooms in the middle of the summer, when the days are long. Everybody is invited to join me and other MySQLers on the tour to visit the PHP user group in his neighbor town.

As of PHP 5.3 the PHP MySQL extension mysqli (ext/mysqli) supports Persistent Database Connections. Persistent Connections are new to ext/mysqli but not new to ext/mysql or PDO. The news behind the news is the usage of COM_CHANGE_USER (C-API: mysql_change_user()) by ext/mysqli - no side effects any more. The "flagship" has idiot-proof Persistent Connections.

If you do not know what Persistent Database Connections are and you speak german I would like to point you to my guest …