Archiv für den Monat October, 2009

PHP: the mysqlnd slow query log (incl. backtrace)

Friday, October 23rd, 2009

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 […]

PHP: 150 performance tuning screws for mysqlnd

Friday, October 16th, 2009

Yes, 150 means we added some 30 performance statistics to the MySQL native driver for PHP (mysqlnd) since monday. The new statistics are explained in three words: counting COM_* commands. COM_* commands refers to the command packets of the MySQL client server protocol. For example, COM_QUERY is used to execute nonprepared SQL statements.

Please check […]

Warum ich ext/mysql mag…

Tuesday, October 13th, 2009

Es gibt drei Extensions mit deren Hilfe ein PHP-Skript auf einen MySQL Server zugreifen kann: ext/mysql, ext/mysqli und PDO_MYSQL. Alle drei sind geeignet, um die Entwicklungsgeschichte von PHP und MySQL Revue passieren zu lassen, alle drei sind geeignet, um Kopfschütteln oder Staunen hervorzurufen. Heute: Grundlagen des Verbindungsaufbaus mit ext/mysql - wie verbinde ich PHP mit […]

Frisch aus der Mailbox - http://www.phpblogstars.de/

Tuesday, October 13th, 2009

Ohne Kommentar, da zu neu für mich. Urteilt selbst was Gabriele, die sich auch in der PHP UG München engagiert, auf die Beine stellt:

http://www.phpblogstars.de/ - Alle deutschsprachigen PHPBlogs an einer Stelle

PHP: 120 tuning screws for mysqlnd

Monday, October 12th, 2009

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) […]