Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 91 Next 1 Older Entries

Displaying posts with tag: PHP (english) (reset)

PHP: ping mysqlnd.team
Employee +0 Vote Up -0Vote Down

PING mysqlnd.team (MySQL) - 56(84) bytes of data
64 bytes from mysqlnd.team - icmp_seq=1 ttl=3weeks time=1month


Yes, there are delays. But not for the reason that we are having any problems. We have been borrowed out to other teams recently. A short status report.

PONG from mysqlnd.team

Andrey could not resist and has continued researching on parallel and background query operation. Georg was not too happy about this. Not that Georg does not support the idea, no, but Andrey had some other urgent assignments. Well, Andrey sometimes works in sort of waves: do little for some time, hack like crazy on other days. Again, Miha Nedok from http://www.izklop.com/, our alpha-beta-everything-tester number one, has given Andrey’s code studies a test drive and he did not


  [Read more...]
PHP: ping mysqlnd.team
Employee +0 Vote Up -0Vote Down

PING mysqlnd.team (MySQL) - 56(84) bytes of data
64 bytes from mysqlnd.team - icmp_seq=1 ttl=3weeks time=1month


Yes, there are delays. But not for the reason that we are having any problems. We have been borrowed out to other teams recently. A short status report.

PONG from mysqlnd.team

Andrey could not resist and has continued researching on parallel and background query operation. Georg was not too happy about this. Not that Georg does not support the idea, no, but Andrey had some other urgent assignments. Well, Andrey sometimes works in sort of waves: do little for some time, hack like crazy on other days. Again, Miha Nedok from http://www.izklop.com/, our alpha-beta-everything-tester number one, has given Andrey’s code studies a test drive and he did not


  [Read more...]
PHP: "mysqlnd is awesome"
Employee +0 Vote Up -0Vote Down

Things start rolling! mysqlnd is among the five most desired features for PHP 5.3 according to a PHP 5.3 Feature Summary email from Ilia, who - at the time of writing - was doing the release management of PHP.

Thanks everybody for your trust in mysqlnd and your support! We shall try not to disappoint you in the future and continue with the development. Of course, as the core feature mature more and more, we will try to spend time on implementing new, useful tricks and try to provide you with additional documentation, if time permits.

Meanwhile we are still looking for your feedback. Tell us about your positive and negative experiences with mysqlnd. Jürgen Krieger did so in his forums posting and concludes And i have to say

  [Read more...]
PHP: "mysqlnd is awesome"
Employee +0 Vote Up -0Vote Down

Things start rolling! mysqlnd is among the five most desired features for PHP 5.3 according to a PHP 5.3 Feature Summary email from Ilia, who - at the time of writing - was doing the release management of PHP.

Thanks everybody for your trust in mysqlnd and your support! We shall try not to disappoint you in the future and continue with the development. Of course, as the core feature mature more and more, we will try to spend time on implementing new, useful tricks and try to provide you with additional documentation, if time permits.

Meanwhile we are still looking for your feedback. Tell us about your positive and negative experiences with mysqlnd. Jürgen Krieger did so in his forums posting and concludes

  [Read more...]
PHP: "mysqlnd is awesome"
Employee +0 Vote Up -0Vote Down

Things start rolling! mysqlnd is among the five most desired features for PHP 5.3 according to a PHP 5.3 Feature Summary email from Ilia, who - at the time of writing - was doing the release management of PHP.

Thanks everybody for your trust in mysqlnd and your support! We shall try not to disappoint you in the future and continue with the development. Of course, as the core feature mature more and more, we will try to spend time on implementing new, useful tricks and try to provide you with additional documentation, if time permits.

Meanwhile we are still looking for your feedback. Tell us about your positive and negative experiences with mysqlnd. Jürgen Krieger did so in his forums posting and concludes

  [Read more...]
PHP: 59 tuning screws for mysqlnd
Employee +0 Vote Up -0Vote Down

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.

I must confess, I grossly underestimated the time it takes to write only a few words about some of them. Here is a first batch of comments on some 20 figures. Already those some 20 figures should give you an idea how the mysqlnd statistics might help you with bottleneck analysis, monitoring. Or you use the statistics to identify scripts that select more rows than they consume, open more connections than needed, …

How to access client statistics with mysqlnd

Statistics are only available with mysqlnd. Statistics can

  [Read more...]
PHP: 59 tuning screws for mysqlnd
Employee +0 Vote Up -0Vote Down

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.

I must confess, I grossly underestimated the time it takes to write only a few words about some of them. Here is a first batch of comments on some 20 figures. Already those some 20 figures should give you an idea how the mysqlnd statistics might help you with bottleneck analysis, monitoring. Or you use the statistics to identify scripts that select more rows than they consume, open more connections than needed, …

How to access client statistics with mysqlnd

Statistics are only

  [Read more...]
PHP: mysqli_debug() - ?m?/dump memory information
Employee +0 Vote Up -0Vote Down

Andrey has implemented a little mysqlnd only addition to mysqli_debug(): ‘m’ - dump memory information. It works like the other options described in PHP: Debugging ext/mysqli and mysqlnd with the only difference that it is only available with mysqlnd.

Without option ‘m’

This is a short example of mysqlnd freeing the meta data of a result set.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : persistent=0
| | | | info : Freeing fields metadata
| | | | info : Freeing zend_hash_keys
| | | | info : Freeing metadata structure
| | | >mysqlnd_res_meta::free
[...]

Additional mysqlnd memory allocation debug information with option ‘m’

Same trace excerpt but with memory debugging turned on. The control string used for this trace was

  [Read more...]
PHP: mysqli_debug() - ‘m’/dump memory information
Employee +0 Vote Up -0Vote Down

Andrey has implemented a little mysqlnd only addition to mysqli_debug(): ‘m’ - dump memory information. It works like the other options described in PHP: Debugging ext/mysqli and mysqlnd with the only difference that it is only available with mysqlnd.

Without option ‘m’

This is a short example of mysqlnd freeing the meta data of a result set.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : persistent=0
| | | | info : Freeing fields metadata
| | | | info : Freeing zend_hash_keys
| | | | info : Freeing metadata structure
| | | >mysqlnd_res_meta::free
[...]

Additional mysqlnd memory allocation debug information with option ‘m’

Same trace excerpt but with memory debugging turned on. The control string

  [Read more...]
PHP: Debugging ext/mysqli and mysqlnd
Employee +0 Vote Up -0Vote Down

One good news, one bad news - that’s the frank way we blog about mysqlnd. The last posting on significant memory savings (40%) and new tuning options was good news. The bad news: mysqlnd might have bugs. How to report and debug these bugs - using mysqli_debug() - is subject of this posting.

Where to send mysqlnd problem reports, how to contact

Due to a low feedback rate - which is disappointing in a certain way - we are in the comfortable situation that you may report issues or ask questions on pretty much every channel: on the mailing list php@lists.mysql.com, on http://bugs.mysql.com/, on http://bugs.php.net/, by private mail (georg/andrey/uwendel at mysql dot com) or even using a blog comment. Of course, if you are a MySQL

  [Read more...]
PHP: Debugging ext/mysqli and mysqlnd
Employee +0 Vote Up -0Vote Down

One good news, one bad news - that’s the frank way we blog about mysqlnd. The last posting on significant memory savings (40%) and new tuning options was good news. The bad news: mysqlnd might have bugs. How to report and debug these bugs - using mysqli_debug() - is subject of this posting.

Where to send mysqlnd problem reports, how to contact

Due to a low feedback rate - which is disappointing in a certain way - we are in the comfortable situation that you may report issues or ask questions on pretty much every channel: on the mailing list php@lists.mysql.com, on http://bugs.mysql.com/, on http://bugs.php.net/, by private mail (georg/andrey/uwendel at mysql dot com) or even using a blog comment.

  [Read more...]
PHP: mysqli_fetch_all()
Employee +0 Vote Up -0Vote Down

Do you happen to have functions that read all rows of a database result into one array, without processing the rows, and pass the array to other functions? For example, do you fetch results in your database class and pass them to a template engine displaying? If so, here is excellent news for you. mysqli_fetch_all(), which comes with mysqlnd, does the task of fetching the data sometimes twice as fast as mysqli_fetch_array(). Reason being: it saves a loop with function calls…

mixed mysqli_fetch_all( mysqli_result $result [, int $resulttype] )

The new API call, which is only available if you build ext/mysqli with mysqlnd support, does fetch all rows of a result set into an array with just one function call:


$all_rows = mysqli_fetch_all($res);

The one mysqli_fetch_all() call does exactly the same
  [Read more...]

PHP: mysqli_fetch_all()
Employee +0 Vote Up -0Vote Down

Do you happen to have functions that read all rows of a database result into one array, without processing the rows, and pass the array to other functions? For example, do you fetch results in your database class and pass them to a template engine displaying? If so, here is excellent news for you. mysqli_fetch_all(), which comes with mysqlnd, does the task of fetching the data sometimes twice as fast as mysqli_fetch_array(). Reason being: it saves a loop with function calls…

mixed mysqli_fetch_all( mysqli_result $result [, int $resulttype] )

The new API call, which is only available if you build ext/mysqli with mysqlnd support, does fetch all rows of a result set into an array with just one function call:


$all_rows = mysqli_fetch_all($res);

The one mysqli_fetch_all() call
  [Read more...]

PHP: ?Our users notified us of better performance?
Employee +0 Vote Up -0Vote Down

Miha Nedok from http://www.izklop.com wrote us a few days ago about their mysqlnd test run:

I wish I had another production box to test. But what we and our users see now, actually the users notified our team that the site is suddenly “always loading fast”.. The only change… you guessed it mysqlnd installed. It wasn’t slow before, but people noticed performance degradation at times that the site is most visited when libmysql was used.

Hick-ups solved

After a little hick-up during the first days the server is now running stable with ext/mysql @ mysqlnd. Immediately after the installation of mysqlnd, Miha noticed that persistent connections got closed because of a low

  [Read more...]
PHP: “Our users notified us of better performance”
Employee +0 Vote Up -0Vote Down

Miha Nedok from http://www.izklop.com wrote us a few days ago about their mysqlnd test run:

I wish I had another production box to test. But what we and our users see now, actually the users notified our team that the site is suddenly “always loading fast”.. The only change… you guessed it mysqlnd installed. It wasn’t slow before, but people noticed performance degradation at times that the site is most visited when libmysql was used.

Hick-ups solved

After a little hick-up during the first days the server is now running stable with ext/mysql @ mysqlnd. Immediately after the installation of mysqlnd, Miha noticed that persistent connections got closed because of a low

  [Read more...]
PHP: mysqlnd and its tests
Employee +0 Vote Up -0Vote Down

You want to run the mysqlnd tests, because you never trust anybody else test results? In particular you are getting sceptical if anybody claims to have reached a certain level of stability? Read on, here’s a step-by-step for faking your own test results.

New tests …

PHP extensions can test their userland (PHP) functionality using so called “phpt Tests”. phpt Tests consist of several parts with their main part being regular PHP code to test PHP. On the website of the PHP Quality Assurance Team you can find a documentation of the phpt Tests syntax on the page Writing Tests, if your are interested in the details. Most extensions contain a tests/ subdirectory in the PHP source

  [Read more...]
PHP: mysqlnd and its tests
Employee +0 Vote Up -0Vote Down

You want to run the mysqlnd tests, because you never trust anybody else test results? In particular you are getting sceptical if anybody claims to have reached a certain level of stability? Read on, here’s a step-by-step for faking your own test results.

New tests …

PHP extensions can test their userland (PHP) functionality using so called “phpt Tests”. phpt Tests consist of several parts with their main part being regular PHP code to test PHP. On the website of the PHP Quality Assurance Team you can find a documentation of the phpt Tests syntax on the page Writing Tests, if your are interested in the details. Most extensions contain a tests/

  [Read more...]
PHP: What is mysqlnd, do I need it?
Employee +0 Vote Up -0Vote Down

A blog comment from Ian makes me wonder if I failed to state clearly what mysqlnd is. See below for his comment. Ian, I am thankful for your blog comment and question! Probably you are not the only reader who needs a little more background knowledge about mysqlnd. Please allow me to answer your question in public and in depth. FAQ: What is mysqlnd, do I need it?.

The acronym “mysqlnd” stands for “MySQL native driver for PHP”. This pretty much says nothing to most people, I guess.

  • “native”: Is it written in PHP? No, that would be two slow. As you probably know, PHP itself is a program written in C. Therefore native means C and tightly integrated into PHP on the level of C. This is for sure a good thing as the driver can try to
  [Read more...]
PHP: What is mysqlnd, do I need it?
Employee +0 Vote Up -0Vote Down

A blog comment from Ian makes me wonder if I failed to state clearly what mysqlnd is. See below for his comment. Ian, I am thankful for your blog comment and question! Probably you are not the only reader who needs a little more background knowledge about mysqlnd. Please allow me to answer your question in public and in depth. FAQ: What is mysqlnd, do I need it?.

The acronym “mysqlnd” stands for “MySQL native driver for PHP”. This pretty much says nothing to most people, I guess.

  • “native”: Is it written in PHP? No, that would be two slow. As you probably know, PHP itself is a program written in C. Therefore native means C and tightly integrated into PHP on the level of C. This is for sure a good thing
  [Read more...]
PHP: mysqlnd checked in to PHP 6 (HEAD)
Employee +0 Vote Up -0Vote Down

Recently mysqlnd, the MySQL native driver for PHP, has been checked in to the PHP 6 (HEAD) development tree on cvs.php.net. This blog posting gives a quick overview how you can build PHP 5 and PHP 6 with mysqlnd support.

What mysqlnd is and what not

If you do not know what mysqlnd is or not is, read up the details on http://dev.mysql.com/downloads/connector/php-mysqlnd/. In short: mysqlnd is is a replacement for the libmysql, the MySQL Client Library. It it closely integrated into PHP and it is distributed under the terms of the PHP license. You can now compile

  [Read more...]
PHP: mysqlnd checked in to PHP 6 (HEAD)
Employee +0 Vote Up -0Vote Down

Recently mysqlnd, the MySQL native driver for PHP, has been checked in to the PHP 6 (HEAD) development tree on cvs.php.net. This blog posting gives a quick overview how you can build PHP 5 and PHP 6 with mysqlnd support.

What mysqlnd is and what not

If you do not know what mysqlnd is or not is, read up the details on http://dev.mysql.com/downloads/connector/php-mysqlnd/. In short: mysqlnd is is a replacement for the libmysql, the MySQL Client Library. It it closely integrated into PHP and it is distributed under the terms of the PHP license. You can now compile

  [Read more...]
PHP: Is mysqlnd stable?
Employee +0 Vote Up -0Vote Down

Is mysqlnd stable, is mysqlnd ready for wider consumption? Judging from the latest set of tests: yes!

During the development of mysqlnd, the MySQL native driver for PHP - an alternative to libmysql, a good number of new tests have been written. Let’s see how ext/mysql and ext/mysqli perform when running the test suite. Please note that this is a snapshot and figures might be slightly different when you repeat the test runs: mysqlnd is under constant development and your setup is likely to differ from mine.

PHP 6 , MySQL 5.1.15-beta

ext/mysql   Number of Tests Warned Failed Passed Code Coverage HEAD @  [Read more...]
PHP: Is mysqlnd stable?
Employee +0 Vote Up -0Vote Down

Is mysqlnd stable, is mysqlnd ready for wider consumption? Judging from the latest set of tests: yes!

During the development of mysqlnd, the MySQL native driver for PHP - an alternative to libmysql, a good number of new tests have been written. Let’s see how ext/mysql and ext/mysqli perform when running the test suite. Please note that this is a snapshot and figures might be slightly different when you repeat the test runs: mysqlnd is under constant development and your setup is likely to differ from mine.

PHP 6 , MySQL 5.1.15-beta

ext/mysql   Number of Tests Warned Failed Passed Code  [Read more...]
MySQL native driver for PHP: mysqlnd-5.0.1-beta available
Employee +0 Vote Up -0Vote Down

Dear Developers,

we are proud to announce the beta version of the MySQL native driver for PHP: mysqlnd 5.0.1-beta. The software is available for download on http://dev.mysql.com/downloads/connector/php-mysqlnd.

The MySQL native driver for PHP is an additional, alternative way to connect from PHP 5 and PHP 6 to the MySQL Server 4.1 or newer. It is a replacement for libmysql, the MySQL Client Library. From now on you can use ext/mysqli either together with libmysql as you did in the past or with mysqlnd. The MySQL native driver for PHP can connect to MySQL Servers 4.1 or newer.

As stated before, we have no plans to remove libmysql support from ext/mysqli, which would

  [Read more...]
MySQL native driver for PHP: mysqlnd-5.0.1-beta available
Employee +0 Vote Up -0Vote Down

Dear Developers,

we are proud to announce the beta version of the MySQL native driver for PHP: mysqlnd 5.0.1-beta. The software is available for download on http://dev.mysql.com/downloads/connector/php-mysqlnd.

The MySQL native driver for PHP is an additional, alternative way to connect from PHP 5 and PHP 6 to the MySQL Server 4.1 or newer. It is a replacement for libmysql, the MySQL Client Library. From now on you can use ext/mysqli either together with libmysql as you did in the past or with mysqlnd. The MySQL native driver for PHP can connect to MySQL Servers 4.1 or newer.

As stated before, we have no plans to

  [Read more...]
Future versions of mysqlnd to support PHP 5
Employee +0 Vote Up -0Vote Down

Q: Will future versions of mysqlnd support PHP 5?
A: Yes, future versions of mysqlnd will support PHP 5.

However, currently we focus all our development efforts on implementing core functionality like Unicode support and support for Prepared Statements. The reason is that we do not want to be distracted by differences between PHP 5 and PHP 6 at the moment. Once the missing core functionality has been implemented, we will try to port mysqlnd to PHP 5. There is no time plan for PHP 5 support, but we see the need for it.

Thanks to both Ilia and Andi for pointing out that we had forgotten to explain our PHP 5 plans in the announcement of mysqlnd!

Future versions of mysqlnd to support PHP 5
Employee +0 Vote Up -0Vote Down

Q: Will future versions of mysqlnd support PHP 5?
A: Yes, future versions of mysqlnd will support PHP 5.

However, currently we focus all our development efforts on implementing core functionality like Unicode support and support for Prepared Statements. The reason is that we do not want to be distracted by differences between PHP 5 and PHP 6 at the moment. Once the missing core functionality has been implemented, we will try to port mysqlnd to PHP 5. There is no time plan for PHP 5 support, but we see the need for it.

Thanks to both Ilia and Andi for pointing out that we had forgotten to explain our PHP 5 plans in the announcement of mysqlnd!

About the performance of mysqlnd-5.0.0-alpha
Employee +0 Vote Up -0Vote Down

I have written a long, long blog entry How fast is mysqlnd-5.0.0-alpha?.I do not want to spam the Planets with all of it. It’s aimed at PHP and MySQL users that want to hear in detail what we know about the performance of the first alpha release of the MySQL native driver for PHP.

The following table demonstrates pretty well where we are with mysqlnd. For a first alpha it shows an acceptable performance.

As an example of a realistic benchmark, we have followed the decision of the german computer magazine c’t and choosen the Dell DVD Store. Last year a MySQL team had won (german press release (http://www.mysql.de/news-and-events/press-release/release_2006_35.html)) a database performance

  [Read more...]
About the performance of mysqlnd-5.0.0-alpha
Employee +0 Vote Up -0Vote Down

I have written a long, long blog entry How fast is mysqlnd-5.0.0-alpha?.I do not want to spam the Planets with all of it. It’s aimed at PHP and MySQL users that want to hear in detail what we know about the performance of the first alpha release of the MySQL native driver for PHP.

The following table demonstrates pretty well where we are with mysqlnd. For a first alpha it shows an acceptable performance.

As an example of a realistic benchmark, we have followed the decision of the german computer magazine c’t and choosen the Dell DVD Store. Last year a MySQL team had won (german press release

  [Read more...]
MySQL native driver for PHP: mysqlnd-5.0.0-alpha
Employee +0 Vote Up -0Vote Down

Dear Developers,

we are proud to announce the first alpha version of the MySQL native driver for PHP: mysqlnd 5.0.0-alpha. The software is available for download on http://dev.mysql.com/downloads/connector/php-mysqlnd.

The MySQL native driver for PHP is an additional, alternative way to connect from PHP 6 to the MySQL Server 4.1 or newer. It is a replacement for libmysql, the MySQL Client Library. From now on you can use ext/mysqli either together with libmysql as you did in the past or with mysqlnd. The MySQL native driver for PHP requires PHP 6 and can connect to MySQL Servers 4.1 or newer.

We have no plans to remove libmysql support from

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 of 91 Next 1 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.