News Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Zend Developer Zone:
MySQLND, MySQL_UH and other goodies available to PHP programmers
January 26, 2011 @ 11:16:02

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.
0 comments voice your opinion now!
mysqlnd mysqluh nativedriver loadbalance shard mysql tutorial


Internet Super Hero:
PDO_MYSQLND 1.0.2-alpha released
May 09, 2008 @ 11:19:57

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.

0 comments voice your opinion now!
mysqldn nativedriver release alpha pdo download


Internet Super Hero:
59 tuning screws for mysqlnd
September 13, 2007 @ 07:50:34

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).

0 comments voice your opinion now!
tuning screw mysqlnd nativedriver performance statistics tuning screw mysqlnd nativedriver performance statistics



Community Events





Don't see your event here?
Let us know!


list tool laravel security introduction conference symfony language series framework release opinion interview version composer community podcast artisanfiles library voicesoftheelephpant

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework