On the Zend Developer Zone today there's a new post from Cal Evans mentioning some goodies that are available to PHP programmers in the world of MySQL.

PHP 5.3 shipped with a new driver for MySQL, mysqlnd or MySQL Native Driver. While one of it's biggest features is that it gives us a mysql driver that is part of PHP so it doesn't suffer from licensing issues that the previous driver did. However, in the redesign, the architecture was changed.

He mentions the mysqlnd_uh that's a part of this new MySQL driver and an interesting article from Ulf Wendel about its use in transparent load balancing and sharding. The article includes code that randomly picks a MySQL server for the script to use.

The article is a bit difficult to read at time but trust me, stick with them because the stuff in there is the stuff you want in your head when you are working on your next application.

The Internet Super Hero blog has announced the release of the latest alpha version of the mysql native driver for PDO - version 1.0.2-alpha (PDO_MYSQLND):

I am glad to announce the availability of the first alpha version of PDO_MYSQLND. PDO_MYSQLND is a PHP PDO driver for MySQL based on the MySQL native driver. PDO_MYSQLND 1.0.2-alpha is available for download on http://downloads.mysql.com/forge/pdo_mysqlnd_preview.

Updates include fixes for return values, patches for memory leaks, more code coverage and some "very promising results" running on a set of dedicated testing machines.

The Internet Super Hero blog has posted 59 statistics they've generated while they were sting the latest versions of the mysqlnd (native driver) in PHP:

59 - that is the number of statistics collected by mysqlnd. When I started writing this blog post, I hoped it would be easy going describing them. But it wasn't. Some ten days ago, we've had 51 statistics and near zero tests for them. Now we have 59 statistics. And, in a certain way, every figure is a tuning screw in the hand of one who knows what they do.

The list of stats presented include functionality for:

• buffered_sets, ps_buffered_sets
• rows_buffered_from_client_normal, rows_buffered_from_client_ps
• rows_fetched_from_client_ps_buffered
• unbuffered_sets, ps_unbuffered_sets
• rows_fetched_from_client_ps_unbuffered
• flushed_normal_sets, flushed_ps_sets

Check out the rest of the post for the numbers and results (as well as some images showing the difference between buffered and unbuffered results).

The Internet Super Hero blog has posted 59 statistics they've generated while they were sting the latest versions of the mysqlnd (native driver) in PHP:

59 - that is the number of statistics collected by mysqlnd. When I started writing this blog post, I hoped it would be easy going describing them. But it wasn't. Some ten days ago, we've had 51 statistics and near zero tests for them. Now we have 59 statistics. And, in a certain way, every figure is a tuning screw in the hand of one who knows what they do.

The list of stats presented include functionality for:

• buffered_sets, ps_buffered_sets
• rows_buffered_from_client_normal, rows_buffered_from_client_ps
• rows_fetched_from_client_ps_buffered
• unbuffered_sets, ps_unbuffered_sets
• rows_fetched_from_client_ps_unbuffered
• flushed_normal_sets, flushed_ps_sets

Check out the rest of the post for the numbers and results (as well as some images showing the difference between buffered and unbuffered results).