May 25, 2012

Post: Wishes for new "Pure PHP" MySQL driver

If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet the team (Georg, Andrey etc) which will be developing this driver… load balancing and fall back by itself, similar as JDBC driver does. Client size caching Would be very helpful for simple…

Post: Are PHP persistent connections evil ?

As you probably know PHPmysql” extension supported persistent connections but they were disabled in new “… MySQL versions. So persistent connections are not evil but they need some MySQL support to be properly implemented. Now with new “mysqlnd” driver for PHP effort by MySQL team I hope this…

Post: MySQL Prepared Statements

…about archiving best performance in your application using MySQL you should learn about prepared statements. These …prepared statements which JDBC, ODBC and some other drivers had forever. Now query passed to the …code. I had a lot of problems with PHP prepared statements. It is getting better but …

Comment: What's up with HandlerSocket?

driver. We’re a java/mysql shop and don’t use the c-language libraries at all. Without support in the JDBC driver…, you’d need DBD:mysql to support handlersockets, if you’re on PHP you’d want support in PHP_MYSQLND, etc. Or would handler sockets just work with those drivers (looser abstraction…

Comment: What's up with HandlerSocket?

driver. We’re a java/mysql shop and don’t use the c-language libraries at all. Without support in the JDBC driver…, you’d need DBD:mysql to support handlersockets, if you’re on PHP you’d want support in PHP_MYSQLND, etc. Or would handler sockets just work with those drivers (looser abstraction…

Comment: Wishes for new "Pure PHP" MySQL driver

a pure php driver would solve a lot of problems for people using shared … to the mysql server because its an old version of mysql! All attempts to compile php5 to use the old mysql4 driver used by php4 have failed. A pure php client…

Comment: Wishes for new "Pure PHP" MySQL driver

… for years, while it is possible to implement it in driver rather easily. Also server does not have full picture – ie… application chance of going from MySQL to something else is probably less than rewriting them from PHP to something else :) 4) It… is something which could be well build in into the driver as it is very typical task. 5) Connection pooling daemon…

Comment: MySQL wins C'T Database Contest

Vadim, I noticed that the MySQL results in the PR as 3,663opm was different from …://www.dell.com/downloads/global/solutions/mysql_network_2800.pdf? Is there any HWs configuration, or MySQL/PHP/driver source(is it different versions…

Comment: MySQL wins C'T Database Contest

… no cache – there is something in this tests that is MySQL-specific. For instance, 3664 op/min is around 60 op… be a stored procedure, otherwise we just compare drivers and essentials of Java vs PHP. If someone can show the number of…

Comment: Duplicate indexes and redundant indexes

… the PEAR::MDB2 manager module which supports pre-information-schema mysql versions and supports reverse engineering indexes and constraints. So by… be able to find out any unncessary overlap. http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Manager_Common.html