Testing with php 5.1

[peterlaursen]

I just tested HTTP-tunnelling with SQLyog with php 5.1 (beta 2 is just released, and final will be very soon).

Php 5.1 introduces a new “database abstraction layer” and comes with new versions of mysql- and mysqli- extensions.

However there seems to be a memory consumption problem with SQLyog when tunnelling with php5.1. It uses quite a lot more memory than it does with php 5.04. This might still be an issue with the php 5.1 beta-2 but this is just for your information. I suggest you look into it …

All test done with Sqlyog 5.07 RC2. And the SQLyogtunnel.php file used for this experiment is the one shipped with 4.07 RC2.

BTW: I believe that some error message(s) displayed by SQLyog are incorrect. When php MySQL-extension are not found it displays something like “php was not compiled with MySQL-extension – SQLYog tunnelling needs that extension”. Extensions don't need to be compiled into php-binary! With php5 you wouldn't normally do it – at least not on Windows (but it is normal to compile the MySQL extension into php4. The binary downloads available for php4 have that, the binary downloads available for php5 don't) (With my local installation I simply activated the mysql and mysqli extension by copying php_mysql.dll and php_mysqli.dll into the Apachebin directory and activating them from the php.ini-file.).

Note: I edited this about an hour after first post.

[peterlaursen]

pic shows use with php 5.1.

Note that it is not Apache.exe (and thus not the php-system) that uses this. It is SQLyog .exe!

It occurs like that when data traffic over TCP has come to an end.

Nothing like it appears when not using tunnelling.

To reproduce simply click on checkbox “show all” with a reasonable big DB (remember to tunnel!), open Task Manager and a Network Monitoring program and watch things.

[Ritesh]

Thanks for the info.

[Author]

Posts