Topic: Available php_mysql(i).dll for PHP 5.2.9+ and MySQL 5.1.30+

[Steffen]

As follow up from thread at http://www.apachelounge.com/viewtopic.php?t=2772 :

Tom was so kind to build php_mysql.dll and php_mysqli.dll for MySQL 5.1.30+ and PHP 5.2.9+.

Backup and replace the php_mysql.dll and php_mysqli.dll in your PHP \EXT directory with these replacements to use MySQL 5.1.30 (or higher) with PHP 5.2.9 (or higher).

Also replace the libmysql.dll in the PHP dir with the file included in your MySQL 5.1.30+ \lib\opt directory.

Download www.apachelounge.com/download/ The file PHP-5.2.9+_MySQL-5.1.30+.zip

Tom and Steffen

[htdavis]

Will these work with the x64 installs?
I just tried it with my test box and and phpinfo() doesn't report that either is available.

[tdonovan]

re: "Will these work with the x64 installs? "
No, these are 32-bit binaries.
It will require someone with a 64-bit system to build the x64 binaries.

-tom-

[jeffrito]

Thanks, I installed these on a generic WAMP box with PHP 5.2.9 and MySQL 5.1.32. The correct client API is reported in phpinfo() and all works fine.

However, a problem I am becoming obsessed with was not resolved and it seems like your knowledge of the interactions of the various libraries may allow you to point me in some direction (other than jumping off a cliff).

I have a great big database that is pretty much optimized and here are two similar queries:

QUERY 1
=========
SELECT count(*)
FROM calldetail
INNER JOIN sources ON calldetail.SourceID = sources.SourceID
INNER JOIN supplier ON sources.SupplierID = supplier.SupplierID
WHERE sources.MediaType = 'LF TV'
AND supplier.SupplierID = '27264066900148'
AND calldetail.InitiatedDate
BETWEEN '2009-05-14 00:00:00'
AND '2009-05-14 23:59:59'

QUERY 2
=========
SELECT calldetail.CallID, count(*)
FROM calldetail
INNER JOIN sources ON calldetail.SourceID = sources.SourceID
INNER JOIN supplier ON sources.SupplierID = supplier.SupplierID
WHERE sources.MediaType = 'LF TV'
AND supplier.SupplierID = '27264066900148'
AND calldetail.InitiatedDate
BETWEEN '2009-05-14 00:00:00'
AND '2009-05-14 23:59:59'
GROUP BY 1

In MySQL command line client and MySQL Query Browser, both queries run pretty much instantaneously. "4" and the 4 corresponding records are the respective results, so we're not talking a lot of data here and all is good in dbadmin land.

In any PHP scripts using mysqli (for example, phpmyadmin using mysqli extension), Query 1 runs instantaneously, but Query 2 consistenly takes around 45 seconds to process! Ouch! The mysql profiler (via phpmyadmin) shows the query running instantaneously, but in reality it shows up in the process list as "sending data" for those 45 seconds. Every. Time. Yuk.

What would account for the dramatically different results when running the second query through php->mysqli vs. e.g., the mysql query browser app?

Thanks.

[waldbauer.com]

Does it work with the new 5.1.35 too ?

[Steffen]

Yeap, it runs here fine.

Steffen

[waldbauer.com]

Strange - i installed the 5.1.35 and it runs but phpmyadmin reports 5.1.32 still ?!

[Steffen]

Not here, from phpadmin:

Server: 127.0.0.1 via TCP/IP
Server version: 5.1.35
Protocol version: 10
User: father@localhost
MySQL charset: UTF-8 Unicode (utf8)
Web server
Apache
MySQL client version: 5.1.35
PHP extension: mysql

Steffen

[waldbauer.com]

All right; i see. There seems to be an issue with the installer on windows in 5.1.35 which rolls back for some reason and mysql would not be installed. So i downloaded the 5.1.35 NO INSTALL package and copied manually the files over the existing installation. This works for me now too.

[Steffen]

I did not use the installer either. I build a VC9 version.

Steffen

[waldbauer.com]

What is the difference in a VC9 to the original from mysql ?

[lael]

apache is crashing when using this mysqli library... I assume that the problem is because I am using a VC6 version of apache and php (can't find a VC9 compiled version of php).

Is there either - someplace to get a 5.2 version of php compiled with php (can then download apache from this site)

or

somewhere to download a VC6 compatible version of the mysql libraries? (mysql.dll and mysqli.dll)

Thanks!
Lael

[lael]

apologies - i had forgotten to replace the libmysql.dll from \lib\opt

works fine.

[waldbauer.com]

Hi steffen !

I use your php_mysql.dll libs for my sambar and i assume there is sometning wrong which corrupts the heap so may you can provide infos about compiling the sources for 5.1.41 ?!

[waldbauer.com]

Can someone please provide the way to compile the php_mysql.dll and php_mysqli.dll for newer releases. Thank you.

[NewEraCracker]

Thanks for this

I am using php 5.2.14 and mysql 5.1.50 and works flawless

[NewEraCracker]

Time for someone to compile this with MySQL 5.1.53 and PHP 5.2.15

From PHP 5.2.15 ChangeLog:

[James Blond]

I guess it is a nice to have for PHP 5.2. However this is the last release for PHP 5.2. Within PHP 5.3 there is mysqlnd, so no need to compile against a specific mysql version.
It is recommend to upgrade to 5.3

[Smitty]

Has anybody built these DLLs for MySQL 5.5? Some of us are still running PHP 5.2.17.

[NewEraCracker]

Hello,

Can anyone post a topic with a tutorial that explains how I can build this DLLs from source?

I currently got a development environment with windows xp, visual studio 6 service pack 6, visual c++ 6 processor pack and windows 2003 sdk (feb 2003)

Thank you.

---

Edit:

I've read this http://www.php.net/manual/en/install.windows.building.php and used the knowledge I gathered to build a more updated mysql(i) extension:
http://www.apachelounge.com/viewtopic.php?t=3890

For those wishing an extension compatible with mysql 5.5. I wasn't capable of building it so people wishing to use it will have to upgrade to php 5.3.